Excel Lesson 7
Quiz by Lisa DeCastillia
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- view complete results in the Gradebook and Mastery Dashboards
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
19 questions
Show answers
- Q1Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel?Page layoutHomeDataHide45sEditDelete
- Q2Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select?ScaleHeaderFreezeHide45sEditDelete
- Q3What command do you use to insert information into a worksheet that will display at the top and bottom edges of the printed page?MarginsPrint titlesHeader & FooterPage setup45sEditDelete
- Q4Which term describes the blank portions of a page that fall outside the main body of the printed document?MarginsFramesEdgesBorders45sEditDelete
- Q5Joan 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?Page BreakFreezeSplitHide45sEditDelete
- Q6John's spreadsheet includes multiple pages of records. If John wants to view his headings while scrolling through his spreadsheet what should he do?Freeze PanesHideSplitUnhide45sEditDelete
- Q7Which 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?InsertFormatSort & FilterForm45sEditDelete
- Q8Jim 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?OrientationPrint areaPrint titlesPage break45sEditDelete
- Q9Jack would like to force the data in his spreadsheet to fit on one page when printed. Which option should he select?HeaderFreezeHideScale45sEditDelete
- Q10Which command on the Home Ribbon do you use to remove cells, rows, or columns from a worksheet or table?RemoveDeleteFormat as TableFormat45sEditDelete
- Q11Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?Sheet optionsPage setupArrangeThemes45sEditDelete
- Q12John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D?UnhideSplitHideFreeze panes45sEditDelete
- Q13Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet to enhance its appearance?DesignLayoutThemeTemplate45sEditDelete
- Q14In Microsoft Excel, what do you use to emphasize certain entries and make the worksheet easier to read and understand?ConfiguringPrintingFormattingArranging45sEditDelete
- Q15Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?Print areaBackgroundEffectsBreaks45sEditDelete
- Q16Which command do you use to remove manual page breaks from a worksheet area?Select break, press Remove Page Break from Shortcut MenuSelect break, press Backspace on keyboardSelect break, press Delete on keyboardSelect Remove Page Break from the Breaks drop-down area45sEditDelete
- Q17Which command do you use to format a cell or selected cells quickly by choosing from a defined list of styles?Cell styleConditional formattingFormFormat as table45sEditDelete
- Q18Trey would like to apply a rule to the data in cell range A1:F20 that will highlight numbers greater than 50,000 with a yellow fill color and dark yellow text. Which formatting style should he select?BordersConditional FormattingCell StyleFormat as Table45sEditDelete
- Q19Column B in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column B?NumberTextDateCurrency45sEditDelete