John would like to change the order of the worksheets in his workbook. Which option would he choose?
What is Move
100
Joan wants to be be able to view row 1 as well as column A while scrolling through her worksheet. Which option should she choose?
What is Freeze
100
John's spreadsheet includes multiple pages of records. If John wants to view his headings while scrolling through his spreadsheet what should he do?
What is Freeze Panes
100
Which command on the Home Ribbon do you use to replace information in a selected cell with new information or new formatting?
Find and Select
100
What command do you use to increase or decrease the view of a selected cell or range of cells to fill the Excel Window area for better visibility?
What is Zoom to selection
200
What feature of Microsoft Excel keeps a portion of a worksheet visible while the other portion scrolls?
What is Freeze panes
200
How would you move sheet tabs to a new position in the workbook?
What is Click and drag the sheet tab to the new location
200
How is an exact copy of a worksheet created within the same workbook?
What is Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu
200
What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches?
What is String
200
Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select?
What is Freeze
300
Where is the spellchecker located?
What is Review ribbon
300
In a worksheet, which command suggests other words with a similar meaning that can be used?
What is Thesaurus
300
Which ribbon contains commands to add a comment about a selected cell in a worksheet?
What is Review
300
Who is the best, greatest-looking, most swaggie person in the entire school, without a doubt?
What is Caleb
300
What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook?
What is Protect Workbook
400
Which group on the Formulas Ribbon contains the command that checks for common errors found in a formula?
What is Formula Auditing
400
Trey 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?
What is Conditional formatting
400
Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?
What is Sort and Filter
400
How do you quickly modify a table style to meet user preferences?
What is Right-click on a style and choose Duplicate
400
What is the process of bringing data containing text fields separated by commas into Excel called?