Excel Lesson 8
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
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
13 questions
Show answers
- Q1Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select?HeaderFreezeScaleHide45s
- Q2John would like to change the order of the worksheets in his workbook. Which option would he choose?DeleteMoveCopyInsert45s
- Q3David wants to change all occurrences of "North Carolina" to "NC" in his spreadsheet. What command should he use to complete this task?SortFind and ReplaceFilterAutoFill45s
- Q4Virgil wants to emphasize the sheet tabs in his workbook. Which command should he choose?Tab colorInsertMoveRename45s
- Q5What feature of Microsoft Excel keeps a portion of a worksheet visible while the other portion scrolls?RotateFreeze PanesZoomSelect45s
- Q6Which command on the Home Ribbon do you use to replace information in a selected cell with new information or new formatting?FontFormat CellCell StylesFind & Select45s
- Q7John would like to remove a worksheet from his workbook. Which option would he choose?CopyMoveDeleteInsert45s
- Q8What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches?ThreadStringKeyText45s
- Q9How would you move sheet tabs to a new position in the workbook?Choose Move on the Home Ribbon.Click and drag the sheet tab to the new location.Choose Relocate on the Quick Access ToolbarChoose Move on the Insert Ribbon45s
- Q10Virgil wants to customize the sheet tabs in his workbook with the names June, July, and August. Which command should he choose?Tab ColorMoveInsertRename45s
- Q11Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose?InsertRenameTab ColorMove45s
- Q12How is an exact copy of a worksheet created within the same workbook?Right-click the sheet tab, then choose Move or Copy from the Shortcut MenuWhile pointing to the Select All button, choose Move or Copy from the Shortcut MenuChoose Move or Copy from the Quick Access ToolbarWhile pointing to the sheet tab, choose Copy from the Shortcut Menu45s
- Q13Joan wants to be able to view row 1 as well as column A while scrolling through her worksheet. Which option should she choose?SplitFreezePage BreakHide45s