Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Core 1.01
Test Description: Core
Instructions: Answer all questions to get your test result.
1) Which command among the window control buttons is used to close an open file and completely exit the Microsoft Excel program?
A
Quit
B
Save As
C
Close
D
Exit
2) 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 + Home
B
Ctrl + 1
C
Ctrl + Up Arrow
D
Ctrl + End
3) Sharon’s spreadsheet contains information about the number of music downloads in F25. In this address, ‘25’ identifies the:
A
range.
B
cell.
C
row.
D
column.
4) Which notebook-like feature organizes the sheets for use in Excel?
A
Workbook
B
Folder
C
Notepad
D
Worksheet
5) What occurs when the cursor is moved over a cell and a user clicks?
A
The cell is selected
B
The row is selected
C
The column is selected
D
The worksheet is selected
6) What command do you use to increase or decrease the view of a selected cell or range of cells to fill the Excel Window area for better visibility?
A
Amplify Range
B
Magnify Area
C
Enlarge Selected Area
D
Zoom to Selection
7) Which view is the default view used in Microsoft Excel?
A
Page Layout
B
Print
C
Web
D
Normal
8) Which Microsoft Office object would you use for quick, convenient, oneclick access to frequently used Excel commands?
A
Formula Bar
B
Status bar
C
Title bar
D
Quick Access Toolbar
9) Joan has a table that includes demographic information about her employees. If the demographic information is listed across the top and employee names down the left side of the table, what does all the information about one employee represent?
A
Column
B
Entry
C
Workbook
D
Row
10) Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings?
A
Zoom
B
Window
C
Workbook views
D
Show
11) John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?
A
Freeze Panes
B
Hide
C
Unhide
D
Split
12) Which tab is used to display the area that contains the print command?
A
View
B
Page Layout
C
Home
D
File
13) Which view enables a user to create or modify a worksheet while seeing how it will look in printed format?
A
Page Layout
B
Web
C
Print
D
Normal
14) Which area on the left side of the formula bar indicates the cell address of a selected cell?
A
Formula box
B
Name box
C
Cell box
D
Address box
15) Which software program is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?
A
Microsoft Publisher
B
Microsoft Excel
C
Microsoft Word
D
Microsoft PowerPoint
16) Which ribbon option opens a related dialog box?
A
Ellipse
B
Launcher
C
Slider
D
Drop-down Arrow
17) Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?
A
Save As
B
Exit
C
Open
D
Save
18) Joan has entered her name in the First Name field in cell B2 of her table. What does her First Name represent in the table?
A
Workbook
B
Entry
C
Row
D
Column
19) Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?
A
Worksheet
B
Folder
C
Workbook
D
Notepad
*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?