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
Freeze
B
Hide
C
Header
D
Scale
2) Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?
A
Sheet Options
B
Page Setup
C
Arrange
D
Themes
3) Carl notices that the data in cell E4 reads #######. What command could Carl choose to correct this problem?
A
Subscript Formatting
B
AutoFit
C
Wrao Text
D
Special Formatting
4) Jack would like to force the data in his spreadsheet to fit on one page when printed. Which option should he select?
A
Scale
B
Header
C
Hide
D
Freeze
5) In Microsoft Excel, what do you use to emphasize certain entries and make the worksheet easier to read and understand?
A
Arranging
B
Configuring
C
Formatting
D
Printing
6) Which command do you use to remove manual page breaks from a worksheet area?
A
Select Remove Page Break from the Breaks drop-down area
B
Select break, press Backspace on keyboard
C
Select break, press Delete on keyboard
D
Select break, press Remove Page Break from Shortcut Menu
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
Hide
B
Split
C
Freeze Panes
D
Unhide
8) Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel?
A
Page Layout
B
Data
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
Template
B
Theme
C
Layout
D
Design
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
Page Setup
B
Header Footer
C
Print titles
D
Margins
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
Print Area
B
Orientation
C
Page Break
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
Freeze
B
Split
C
Hide
D
Page Break
13) Which command on the Home Ribbon do you use to remove cells, rows, or columns from a worksheet or table?
A
Format
B
Delete
C
Remove
D
Format as Table
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
Format Cells
B
Number
C
Font
D
Paragraph
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
Split
C
Freeze Panes
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
View Ribbon
B
Page Layout Ribbon
C
Insert Ribbon
D
Home 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
Wrap Text
D
Merge and Center
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
Conditional Formatting
C
Cell Style
D
Form
19) Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel?
A
Font
B
Effects
C
Alignment
D
Size
20) Column D in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column D?
A
Text
B
Date
C
Number
D
Currency
*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?