MS Excel Honors #2 Question Preview (ID: 54103)
Review #2.
TEACHERS: click here for quick copy question ID numbers.
John’s spreadsheet includes multiple pages of records. If John wants to view his headings while scrolling through his spreadsheet what should he do?
a) Freeze Payne
b) Split
c) Hide
d) Unhide
Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel?
a) Home
b) Page Layout
c) Data
d) View
Jim 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?
a) Orientation
b) Page Break
c) Print Area
d) Print Titles
Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select?
a) Freeze
b) Header
c) Hide
d) Scale
Jack would like to force the data in his spreadsheet to fit on one page when printed. Which option should he select?
a) Freeze
b) Header
c) Hide
d) Scale
Joan 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?
a) Freeze
b) Split
c) Page Break
d) Hide
John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D?
a) Freeze
b) Split
c) Hide
d) Unhide
In Microsoft Excel, what is used to emphasize certain entries and make the worksheet easier to read and understand?
a) Formatting
b) Printing
c) Arranging
d) Configuring
Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet to enhance its appearance?
a) Layout
b) Template
c) Theme
d) Design
Which term describes the blank portions of a page that fall outside the main body of the printed document?
a) Borders
b) Edges
c) Frames
d) Margins
Which command on the Home Ribbon is used to format row height and column width, organize sheets, and protect or hide cells in a worksheet?
a) Insert
b) Form
c) Sort
d) Format
Which command on the Home Ribbon is used to remove cells, rows, or columns from a worksheet or table?
a) Delete
b) Remove
c) Format
d) Format as Table
Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?
a) Print Area
b) Breaks
c) Background
d) Effects
Which command is used to remove manual page breaks from a worksheet area?
a) Select break, press Delete on keyboard
b) Select Remove Page Break from the Breaks drop-down area
c) Select break, press Backspace on keyboard
d) Select break, press Remove Page Break from Shortcut Menu
Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?
a) Themes
b) Page Setup
c) Sheet Options
d) Arrange
Virgil wants to emphasize the sheet tabs in his workbook. Which command should he choose?
a) Insert
b) Move
c) Rename
d) Tab Color
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
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
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
John would like to remove a worksheet from his workbook. Which option would he choose?
a) Insert
b) Delete
c) Copy
d) Move
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: 54103 in the upper right hand corner or click here.
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 54103 in the upper right hand corner or click here.
TEACHERS / EDUCATORS
Log In | Sign Up / Register
Log In | Sign Up / Register