Are You Smarter Than a 5 th Grader?
1,000,000 5th Grade Topic 1 5th Grade Topic 2 4th Grade Topic 3 4th Grade Topic 4 3rd Grade Topic 5 3rd Grade Topic 6 2nd Grade Topic 7 2nd Grade Topic 8 1st Grade Topic 9 1st Grade Topic , , , ,000 50,000 25,000 10,000 5,000 2,000 1,000
Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet? / Themes / Sheet Options / Page Setup / Arrange / Themes / Sheet Options / Page Setup / Arrange
5th Grade Topic 1 Answer / Sheet Options Return
Which command do you use to remove manual page breaks from a worksheet area? / Select break, press Delete on keyboard / Select Remove Page Break from the Breaks drop-down area / Select break, press Backspace on keyboard / Select break, press Remove Page Break from Shortcut Menu / Select break, press Delete on keyboard / Select Remove Page Break from the Breaks drop-down area / Select break, press Backspace on keyboard / Select break, press Remove Page Break from Shortcut Menu
5th Grade Topic 2 Answer / Select Remove Page Break from the Breaks drop-down area Return
On which short-cut menu can a user hide a row or column from view without permanently deleting the information? / Choose the Hide command on the Shortcut menu / Choose the Show/Hide command on the Home Ribbon / Choose the Hide command on the Quick Access Toolbar / Choose the Disappear command on the Shortcut menu / Choose the Hide command on the Shortcut menu / Choose the Show/Hide command on the Home Ribbon / Choose the Hide command on the Quick Access Toolbar / Choose the Disappear command on the Shortcut menu
4th Grade Topic 3 Answer / Choose the Hide command on the Shortcut menu Return
Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy? / Print area / Background / Breaks / Effects / Print area / Background / Breaks / Effects
4th Grade Topic 4 Answer / Breaks Return
Which command on the Home Ribbon do you use to remove cells, rows, or columns from a worksheet or table? / Delete / Remove / Format / Format as Table / Delete / Remove / Format / Format as Table
3rd Grade Topic 5 Answer / Delete Return
Which command on the Home Ribbon do you use to format row height and column width, organize sheets, and protect or hide cells in a worksheet? / Sort & Filter / Insert / Form / Format / Sort & Filter / Insert / Form / Format
3rd Grade Topic 6 Answer / Format Return
Which term describes the blank portions of a page that fall outside the main body of the printed document? / Margins / Borders / Frames / Edges / Margins / Borders / Frames / Edges
2nd Grade Topic 7 Answer / Margins Return
John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D? / Split / Unhide / Freeze Panes / Hide / Split / Unhide / Freeze Panes / Hide
2nd Grade Topic 8 Answer / Unhide Return
Joan is showing her spreadsheet to a customer and does not want the customer to be able to see the wholesale prices column. What option should she choose? / Header / Freeze / Scale / Hide / Header / Freeze / Scale / Hide
1st Grade Topic 9 Answer / Hide Return
Jack would like to force the data in his spreadsheet to fit on one page when printed. Which option should he select? / Freeze / Header / Hide / Scale / Freeze / Header / Hide / Scale
1st Grade Topic 9 Answer / Scale Return
Million Dollar Question Grade Level Topic 11 Jim would like to print only the cell range A1:F20. What page setup option should he change? / Orientation / Page Break / Print area / Print titles Jim would like to print only the cell range A1:F20. What page setup option should he change? / Orientation / Page Break / Print area / Print titles
Jim would like the data in Row 1 of his spreadsheet to repeat on every page of his printout. What page setup option should he change? / Print area / Print titles / Page break / Orientation / Print area / Print titles / Page break / Orientation
1,000,000 Answer / Print titles Return
Thanks for Playing!
HideJack would like to force the data in his spreadsheet to fit on one pagewhen printed. Which option should heselect?ScaleJim would like the data in Row 1 of his spreadsheet to repeat on everypage of his printout. What page setup option should he change?Print TitlesWhich command do you use to remove manual page breaks from aworksheet area?Select Remove Page Break from the Breaks drop-down areaJack would like the data in Row 10 not to display on his spreadsheet.Which option should he select?HideWhich command group on the Page Layout Ribbon controls the presenceof gridlines and headings on aworksheet?Sheet OptionsWhich set of formatting choices includes a set of colors, fonts, and effectsthat you can apply to a worksheet to enhance its appearance?
ThemeWhich command on the Home Ribbon do you use to replace information ina selected cell with new information or new formatting?Find & SelectJoan wants to be able to view row 1 as well as column A while scrollingthrough her worksheet. Which option should she choose?FreezeJohn would like to change the order of the worksheets in his workbook.Which option would he choose?MoveVirgil wants to emphasize the sheet tabs in his workbook. Which commandshould he choose?Tab colorJack would like the data in Row 1 to remain stationary on the screen whilehe scrolls. Which option should he select?FreezeWhich command on the Home Ribbon do you use to format row heightand column width, organize sheets, and protect or hide cells in aworksheet?FormatHow is an exact copy of a worksheet created within the same workbook?Right click the sheet tab then choose Move or Copy from the ShortcutmenuDavid wants to change all occurrences of "North Carolina" to "NC" in hisspreadsheet. What command should he use to complete this task?
Find and ReplaceWhat is a single character, word, or phrase in a cell on a worksheet that istypically used in searches?StringVirgil needs to transfer a worksheet in the current workbook to a differentworkbook. Which command should he choose?MoveJohn would like to remove a worksheet from his workbook. Which optionwould he choose?DeleteHow would you move sheet tabs to a new position in the workbook?Click and drag the sheet tab to the new locationVirgil wants to customize the sheet tabs in his workbook with the namesJune, July, and August. Which command should he choose?RenameWhat feature of Microsoft Excel keeps a portion of a worksheet visiblewhile the other portion scrolls?Freeze PanesDavid wants to arrange the employee salaries in Column A of hisspreadsheet from lowest to highest. What command should he use tocomplete this task?SortWhich command on the Home Ribbon do you use to temporarily hidespecific values on a worksheet based ona criterion?
Sort & FilterWhich command on the Home Ribbon do you use to organize data inascending or descending order?
Upload your study docs or become a
Course Hero member to access this document
Upload your study docs or become a
Course Hero member to access this document
End of preview. Want to read all 77 pages?
Upload your study docs or become a
Course Hero member to access this document