Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Access Final Review Pt 1-20
Test Description: Excel access final review pt 1-20
Instructions: Answer all questions to get your test result.
1) John's workbooks includes 3 worksheets. Which option should he choose to print them?
A
Print Selection
B
Print Entire Workbook
2) What area contains the command used to print a worksheet in Microsoft Excel?
A
file tab
B
Quick Access Toolbar
3) Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?
A
open
B
save
4) Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands?
A
title bar
B
Quick Access Toolbar
5) Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings?
A
show
B
zoom
6) Which ribbon option opens a related dialog box?
A
slider
B
launcher
7) John has highlighted the data he would like to print. Which print option should he choose?
A
print selection
B
fit one page
8) 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
margin
B
header footer
9) Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?
A
note pad
B
worksheet
10) 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 home
11) To help organize and identify Microsoft Excel files by providing details about the files, which of the following would you use?
A
Document properties
B
file details
12) Sharon's spreadsheet contains information about the number of music downloads in F25. 25 identifies the:
A
column
B
row
13) Which of the following notebook- like features organizes the sheets for use in Excel?
A
workbook
B
worksheet
14) Which command enables a user to save an existing worksheet with a new name or save the worksheet in a new location?
A
close
B
save as
15) How is a cell reference in a formula and its corresponding location in a worksheet identified?
A
Cell reference and cell location are outlined in matching colors
B
Lines connect from the formula to the location
16) Which command on the Fill options dialog box is the default option
A
cells
B
fill series
17) 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
label
B
value
18) Alicia needs to move the data in cell B5 to cell E5. Which command would she select?
A
clear
B
cut
19) 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
autofill
B
find and replace
20) Jennifer needs to identify the values in column B for a sales report. Which type of entry should she use in the column header?
A
function
B
label
*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?