Harold wants to drag select cells A1 to D7. How can he accomplish this?, Long press Alt then click A1 then click D7., Select A1 then D7 while pressing shift, Type A1:D7 in the formula bar, Press Ctrl + A., What is the formula that will subtract the contents of the cells A7 from A8?, A7 - A8, = A7 - A8, A7 - A8 =, =SUM (A7:A8), How can you create a new tab in Windows Excel?, In the ribbon, select Home>Tabs>Add Tabs then input how many you like to add., Press Ctrl + A then press Ctrl + Shift + n., You can’t add tabs in Microsoft Excel., Press Shift>F11, What computer program that gives the user the ability to create tables and edit their values., Presentation, Word, Spreadsheet, Outlook, Which Ribbon Menu is needed to be selected to change the font?, Home, Insert, Page Layout, Cell Formatting, How do you resize a column or width?, Select the cell the press right click, select format cell then change height and width values., In the Formula bar type (h[value]:w[value])., Click the cell then in the ribbon select format cell then change height and width values., Click and drag the column or row heading, How do you change formula style in a sheet?, Click Insert > Cell Formatting > Table Format > Table Style, Click Home > Format as Table > Table Style, Click Cell Formatting > Format Table > Table Style, You have to select each cell then add cell borders to each of them, What is the formula that will add the contents of the cells C1 and C10?, C1 + C10, = C1 + C10, C1 + C10 =, =SUM (C1:C3), Which Ribbon Menu is needed to add a Chart?, Home, Insert, Page Layout, Cell Formatting, With this formula = Expense!C12, what does the Expense! part means?, It a variable that allows quick reference of a value., It is formula label, allowing the user to manage all the formula., It indicates that the c12 to be displayed is on the sheet Expense, This is not a proper use of the formula., Which feature is primarily used to change the appearance of text in a document?, Font formatting, Mail Merge, Track Changes, Page Break, A student needs to make all major headings consistent throughout a long report. Which feature should be used?, WordArt, Styles, Text Box, Columns, You are preparing a research paper and need to create a list of headings with corresponding page numbers automatically. What should you insert?, Footnote, Table of Contents, Bookmark, Caption, A document contains several pages, but you want the introduction to use Roman numerals while the main body uses Arabic numerals. What should you use?, Page Color, Section Breaks, Line Spacing, Indentation, A report has headings that appear differently even though they are supposed to have the same format. Which is the most likely cause?, Different styles or manual formatting were applied, The document has too many pages, The printer is not connected, The file is saved as PDF, A document's table of contents does not show one of the major headings. What should the student check first?, Whether the heading uses an appropriate heading style, Whether the page is in landscape orientation, Whether the font is colorful, Whether the document has a watermark, Which method is most appropriate for reviewing changes made by different people to a document?, Track Changes, WordArt, Page Borders, Columns, A teacher wants students to suggest corrections without permanently changing the original document. Which feature should be recommended?, Comments and Track Changes, Mail Merge, SmartArt, Page Color, A student wants the spreadsheet to display "PASSED" when a student's grade is 75 or higher and "FAILED" otherwise. Which function is appropriate?, SUM, COUNT, IF, MAX, A spreadsheet contains the formula =B2*C2 in D2. When it is copied to D3, it becomes =B3*C3. What type of cell reference is being used?, Absolute reference, Fixed reference, Mixed reference, Relative reference, A teacher sorts a class record by Score from highest to lowest. What is the primary purpose of this operation?, Create a mathematical average, Arrange records according to score order, Remove students below the passing score, Change the actual scores, What is the purpose of a presentation theme?, To automatically create all content, To prevent editing, To provide a consistent visual design throughout the presentation, To replace the speaker, A slide contains a long paragraph explaining a process. How can it be improved?, Convert key information into concise points and visuals, Increase the paragraph's font size only, Add more paragraphs, Use several decorative fonts, Which presentation is most effective for a formal academic report?, Clear structure, readable text, relevant visuals, and consistent design, Slides filled with paragraphs and decorative effects, Slides using different fonts and colors on every page, Slides containing only animations, A student creates a presentation with 20 lines of text on every slide. Which improvement would be most appropriate, Summarize key ideas and use visuals where appropriate, Reduce the font size, Add more text, Use more transitions, A presenter wants to emphasize three major findings from a research study. What is the best approach?, Highlight the three findings using concise text and appropriate visuals, Place the entire research paper on the slides, Use animation on every word, Hide the findings until the final slide

EMP TECH REVIEW

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?