Microsoft Excel 1.08 Question Preview (ID: 45604)


Excel 2016. TEACHERS: click here for quick copy question ID numbers.

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

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

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

Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose?
a) Insert
b) Move
c) Rename
d) Tab Color

Which command on the Home Ribbon do you use to replace information in a selected cell with new information or new formatting?
a) Font
b) Format Cell
c) Cell Styles
d) Find Select

John would like to remove a worksheet from his workbook. Which option would he choose?
a) Insert
b) Delete
c) Copy
d) Move

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

Virgil wants to emphasize the sheet tabs in his workbook. Which command should he choose?
a) Insert
b) Move
c) Rename
d) Tab Color

Virgil wants to customize the sheet tabs in his workbook with the names June, July, and August. Which command should he choose?
a) Insert
b) Move
c) Rename
d) Tab Color

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

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

David wants to change all occurrences of 'North Carolina' to 'NC' in his spreadsheet. What command should he use to complete this task?
a) AutoFill
b) Filter
c) Find and Replace
d) Sort

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: 45604 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register