MS Excel Honors #3 Question Preview (ID: 54107)


Final Review. TEACHERS: click here for quick copy question ID numbers.

John would like to change the order of the worksheets in his workbook. Which option would he choose?
a) Insert
b) Delete
c) Copy
d) Move

Joan wants to be able to view row 1 as well as column A while scrolling through her worksheet. Which option should she choose?
a) Freeze
b) Split
c) Page Break
d) Hide

What feature of Microsoft Excel keeps a portion of a worksheet visible while the other portion scrolls?
a) Zoom
b) Select
c) Freeze Panes
d) Rotate

How would sheet tabs be moved to a new position in the workbook?
a) Choose Move on the Home Ribbon
b) Click and drag the sheet tab to the new location
c) Choose Move on the Insert Ribbon
d) Choose Relocate on the Quick Access Toolbar

How is an exact copy of a worksheet created within the same workbook?
a) While pointing to the sheet tab, choose Copy from the Shortcut Menu
b) Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu
c) While pointing to the Select All button, choose Move or Copy from the Shortcut Menu
d) Choose Move or Copy from the Quick Access Toolbar

What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches?
a) Text
b) String
c) Thread
d) Key

Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select?
a) Freeze
b) Header
c) Hide
d) Scale

What command will arrange Microsoft Excel windows so that they appear side-by-side on the screen?
a) Zoom to Selection
b) New Window
c) Arrange All
d) Freeze Panes

Where is the spell checker feature located in Microsoft Excel?
a) Home Ribbon
b) Page Layout Ribbon
c) Review Ribbon
d) View Ribbon

Which ribbon contains commands to add a comment about a selected cell in a worksheet?
a) Home
b) Insert
c) Data
d) Review

What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook?
a) Protect Workbook
b) Protect Sheet
c) Share
d) Protection

All of the FBLA officers have access to the spreadsheet of member contact information. Which feature of Excel allows others to view who made changes to the spreadsheet, when the changes were made, and what was changed?
a) Track Changes
b) Change History
c) History
d) Names Manager

Lilly is creating a spreadsheet for FBLA and would like all of the advisors at her school to be able to make changes to the spreadsheet at the same time. What command allows her to do this?
a) Share Workbook
b) Protect Workbook
c) Tracking Changes
d) Export

Lilly is creating a spreadsheet for FBLA and would like to see the changes advisors have made to the workbook. What command allows her to do this?
a) Share Workbook
b) Protect Workbook
c) Tracking Changes
d) Export

Lilly is making changes to a spreadsheet created by her FBLA advisor. She wants to add a note informing her advisor of an incorrect address for a member. What option in the comments group should be used?
a) New
b) Delete
c) Edit Comment
d) Show Link

Lilly is making changes to a spreadsheet her FBLA Advisor created. She would like to make a change to the comment she made in the spreadsheet. What option in the comments group should she choose?
a) New
b) Delete
c) Edit Comment
d) Show Link

Which file name would be used for an Excel 2019 template?
a) budget.xltx
b) budget.xlsx
c) budget.xlsm
d) budget.xlt

Which symbol is required for Excel to recognize one of the four constants that refer to the same general area of a table?
a)
b) =
c) \
d) #

Which Excel command allows a user to display hidden ribbon tabs?
a) Change the Ribbon
b) Customize the Ribbon
c) General
d) Quick Access Toolbar

Which process allows the user to create a custom template?
a) click Save As and set the file type to .xlsx
b) click Save and set the file type to .xlz
c) click Save As and set the file type to .xls
d) click Save As and set the file type to .xltx

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 54107 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links