Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel 1.01-1.02 (Part 2)
Test Description: 1.01-1.02
Instructions: Answer all questions to get your test result.
1) Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings?
A
Zoom
B
Workbook views
C
Window
D
Show
2) Jennifer needs to identify the values in column B for a statistics report. Which type of entry should she use in the column header?
A
values
B
labels
C
formulas
D
functions
3) Which command on the Fill options dialog box is the default option if you enter a month or day?
A
Fill Formatting Only
B
Fill without Formatting
C
Copy Cells
D
Fill Series
4) John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?
A
Split
B
Unhide
C
Freeze Panes
D
Hide
5) Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands?
A
Formula Bar
B
Status bar
C
Quick Access Toolbar
D
Title bar
6) Which term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group?
A
Set
B
Segment
C
Cluster
D
Range
7) When entering data into a cell, which keyboard key is used to remove characters to the left of the insertion point?
A
Left arrow key
B
Delete key
C
Backspace key
D
Enter key
8) Which ribbon option opens a related dialog box?
A
Slider
B
Launcher
C
Drop-down Arrow
D
Ellipse
9) Joan wants to add a new entry at the bottom of her spreadsheet. What is the shortcut that will take her to the last record on her spreadsheet?
A
Ctrl + End
B
Ctrl + 1
C
Ctrl + Up Arrow
D
Ctrl + Home
10) Which view is the default view used in Microsoft Excel?
A
Page Layout
B
Normal
C
Web
D
Print
11) Which command do you use to close an open file and completely exit the Microsoft Excel program?
A
Quit
B
Exit
C
Close
D
Save As
12) What feature was created for users who prefer to use the keyboard rather than the mouse, and provides keyboard code icons that may be used in conjunction with the ALT key?
A
Mini Toolbar
B
Key Tips
C
Quick Access Toolbar
D
Hot Keys
13) David wants to key the numbers 1 to 1,000 in Column A of his spreadsheet. What command should he use to complete this task?
A
Sort
B
Filter
C
AutoFill
D
Find and Replace
14) What is the name of the list of frequently used Excel commands available when a user right-clicks an item in the worksheet?
A
Mini Toolbar
B
Quick Access Toolbar
C
Shortcut Toolbar
D
Shortcut Menu
15) Joan is creating a table that will include demographic information about her employees. What is each header in her table considered?
A
Value
B
Formula
C
Function
D
Label
16) Which tab do you use to display the area that contains the print command?
A
Page Layout
B
File
C
View
D
Home
17) Alicia needs to move the data in cell B5 to cell E5. Which command would she select?
A
Copy
B
Clear
C
Cut
D
Format Painter
18) Alicia needs to delete the data in cell B5. Which command would she select?
A
Format Painter
B
Clear
C
Copy
D
Cut
19) Which view enables a user to create or modify a worksheet while seeing how it will look in printed format?
A
Normal
B
Print
C
Web
D
Page Layout
20) To help organize and identify Microsoft Excel files by providing details about the files, which of the following would you use?
A
File details
B
Document properties
C
Document options
D
File facts
*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?