Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Microsoft Excel 1.06-1.07 (Part 2)
Test Description: Part 2
Instructions: Answer all questions to get your test result.
1) Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select?
A
Hide
B
Freeze
C
Scale
D
Header
2) Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?
A
Arrange
B
Themes
C
Sheet Options
D
Page Setup
3) Carl notices that the data in cell E4 reads #######. What command could Carl choose to correct this problem?
A
Special Formatting
B
Subscript Formatting
C
AutoFit
D
Wrao Text
4) Jack would like to force the data in his spreadsheet to fit on one page when printed. Which option should he select?
A
Hide
B
Freeze
C
Scale
D
Header
5) In Microsoft Excel, what do you use to emphasize certain entries and make the worksheet easier to read and understand?
A
Configuring
B
Formatting
C
Arranging
D
Printing
6) Which command do you use to remove manual page breaks from a worksheet area?
A
Select break, press Backspace on keyboard
B
Select break, press Remove Page Break from Shortcut Menu
C
Select Remove Page Break from the Breaks drop-down area
D
Select break, press Delete on keyboard
7) 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
Unhide
B
Freeze Panes
C
Hide
D
Split
8) Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel?
A
Data
B
Page Layout
C
View
D
Home
9) 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
Design
B
Layout
C
Template
D
Theme
10) What command do you use to insert information into a worksheet that will display at the top and bottom edges of the printed page?
A
Header Footer
B
Margins
C
Page Setup
D
Print titles
11) 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
Page Break
B
Print Area
C
Orientation
D
Print Titles
12) 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
Hide
B
Freeze
C
Page Break
D
Split
13) Which command on the Home Ribbon do you use to remove cells, rows, or columns from a worksheet or table?
A
Format
B
Remove
C
Format as Table
D
Delete
14) Which dialog box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet?
A
Paragraph
B
Number
C
Font
D
Format Cells
15) John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D?
A
Hide
B
Freeze Panes
C
Split
D
Unhide
16) Where can you find the command to apply a fill color to a cell or range of cells in a worksheet?
A
Insert Ribbon
B
Page Layout Ribbon
C
Home Ribbon
D
View Ribbon
17) Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?
A
Center
B
Orientation
C
Merge and Center
D
Wrap Text
18) Which command do you use to format a cell or selected cells quickly by choosing from a defined list of styles?
A
Format as Table
B
Cell Style
C
Form
D
Conditional Formatting
19) Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel?
A
Effects
B
Size
C
Alignment
D
Font
20) Column D in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column D?
A
Currency
B
Date
C
Number
D
Text
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?