Font size
S
M
L
XL
WorksheetsExcel Vocats Exam Review 1
Total questions: 100
Worksheet time: 50mins
Name
Class
Date
1.
Which command do you use to close an open file and completely exit the Microsoft Excel program?
a)
save as
b)
exit
c)
quit
d)
close
2.
Which group on the View ribbon enables you a user to show or hide the ruler, gridlines, Formula bar, or headings?
a)
show
b)
workbook views
c)
zoom
d)
window
3.
Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?
a)
workbook
b)
folder
c)
worksheet
d)
notepad
4.
Joan has a table that includes demographic information about her employees. What does all the information about one employee represent?
a)
workbook
b)
row
c)
entry
d)
column
5.
Which Microsoft Office object would you use for quick, convenient, one click access to frequently used Excel commands?
a)
status bar
b)
quick access toolbar
c)
title bar
d)
formula bar
6.
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)
column
b)
workbook
c)
row
d)
entry
7.
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)
zoom to selection
b)
magnify area
c)
enlarge selected area
d)
amplify range
8.
Which view is the default view used in Microsoft Excel?
a)
web
b)
print
c)
normal
d)
page layout
9.
Which of the software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?
a)
Publisher
b)
Excel
c)
PowerPoint
d)
Word
10.
Sharon's spreadsheet contains information about the number of music downloads in F25. "25" identifies the:
a)
column
b)
cell
c)
row
d)
range
11.
John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?
a)
hide
b)
unhide
c)
freeze panes
d)
split
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)
quick access toolbar
b)
key tips
c)
hot keys
d)
mini toolbar
13.
What command will arrange Microsoft Excel windows so that they appear side by side on the screen?
a)
new window
b)
arrange all
c)
freeze panes
d)
zoom to selection
14.
Joan whats 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
c)
Ctrl + 1
d)
Ctrl + Up Arrow
15.
What occurs when the cursor is moved over a cell and the user clicks?
a)
the row is selected
b)
the column is selected
c)
the worksheet is selected
d)
the cell is selected
16.
Which ribbon option opens a related dialog box?
a)
slider
b)
ellipse
c)
drop down arrow
d)
launcher
17.
Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?
a)
Save
b)
Exit
c)
Save as
d)
Open
18.
Which of the following notebook-like features organizes the sheets for use in Excel?
a)
Notepad
b)
Workbook
c)
Worksheet
d)
Folder
19.
Which tab do you use to display the area that contains the print commands?
a)
file
b)
page layout
c)
home
d)
view
20.
Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell?
a)
formula box
b)
address box
c)
name box
d)
cell ox
21.
Which view enables a use to create or modify a worksheet while seeing how it will look in printed format?
a)
print
b)
normal
c)
page layout
d)
web
22.
John wants to print only the Inventory worksheet that he is currently working on in his workbook. Which option should he choose?
a)
print active sheet
b)
print selection
c)
fit sheet one page
d)
print entire workbook
23.
Joyce has updated the data in an existing spreadsheet. Which command would she select to preserve the data for future use?
a)
exit
b)
save as
c)
save
d)
open
24.
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)
fill series
d)
copy cells
25.
Which command on the "Home Ribbon" allows data to be moved from one worksheet location to another?
a)
duplicate
b)
copy
c)
cut
d)
move
26.
Sharon's spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a:
a)
cell
b)
range
c)
column
d)
row
27.
When entering data into a cell, which keyboard key is used to remove characters to the left of the insertion point?
a)
backspace key
b)
left arrow key
c)
enter key
d)
delete key
28.
What is the name of the small black square in the lower right corner of the heavy board on an active cell that repeats a cell's value in adjacent cells/
a)
copy box
b)
fill handle
c)
filler
d)
copy handle
29.
Which term refers to a group of selected cells that may be formatted, moved, copied, or deleted as a group?
a)
segment
b)
cluster
c)
set
d)
range
30.
What is the name of the list of frequently use Excel commands available when a user right clicks an item in the worksheet?
a)
shortcut toolbar
b)
shortcut menu
c)
mini toolbar
d)
quick access toolbar
31.
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)
functions
b)
values
c)
labels
d)
formulas
32.
Alicia needs to move the data n cell B5 to cell E5. Which command would she select/
a)
format painter
b)
copy
c)
cut
d)
clear
33.
What is the process of using the mouse to move or copy cells called?
a)
drag and drop
b)
dragging
c)
drag and move
d)
click and paste
34.
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)
formulaa
b)
functions
c)
values
d)
labels
35.
Joan is creating a table that will include demographic information about her employees. What is each header in her table considered?
a)
function
b)
formula
c)
label
d)
value
36.
In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact?
a)
paste
b)
cut
c)
copy
d)
move
37.
To help organize and identify Microsoft Excel files by providing details about the files, which of the following would you use?
a)
document options
b)
file details
c)
file facts
d)
document properties
38.
Alicia needs to delete the data in cell B5. Which command would she select?
a)
clear
b)
format painter
c)
cut
d)
copy
39.
Which Microsoft Excel feature automatically inserts data into a cell that begins with the same characters as a previous entry?
a)
AutoComplete
b)
AutoSpell
c)
AutoCorrect
d)
AutoFill
40.
David wants to key the numbers 1 to 1000 in Column A of his spreadsheet. What command should he use to complete this task?
a)
find and replace
b)
sort
c)
AutoFill
d)
filter
41.
In a Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit?
a)
best fit
b)
true fit
c)
smart fit
d)
AutoFit
42.
John's workbooks include 3 worksheets. Which option should he choose to print them?
a)
print selection
b)
print active sheet
c)
fit to one page
d)
print entire workbook
43.
Which command enables a user to save an existing worksheet with a new name or save the worksheet in a new location/
a)
exit
b)
save
c)
close
d)
save as
44.
What area contains the command used to customize the print options in Microsoft Excel?
a)
quick access toolbar
b)
home ribbon
c)
page layout ribbon
d)
file tab
45.
Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets?
a)
smart sheet
b)
template
c)
boilerplate
d)
form
46.
Jim would like to print only the cell range A1:F20. What page setup option should he change?
a)
print titles
b)
print area
c)
page break
d)
orientation
47.
Steve would like to print only the worksheet he is currently working on. What print option should he choose?
a)
active sheets
b)
print area
c)
entire workbook
d)
quick print
48.
Tyler created a monthly sales workbook that contains the formula =SUM(Sales). "Sales" is an example of a(n):
a)
scope
b)
external reference
c)
name manager
d)
named range
49.
What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it to the destination area?
a)
relative
b)
absolute
c)
mixed
d)
unconditional
50.
What do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?
a)
sheet name
b)
worksheet reference
c)
name reference
d)
calling the sheet
51.
When copying values in Microsoft Excel, which feature automatically adjusts cells references for the new copy location?
a)
certain reference
b)
absolute reference
c)
relative reference
d)
variable reference
52.
Jennifer is calculating her GPA. If she uses "=A1+A2+A3+A4)/4", this is an example of which type of entry?
a)
values
b)
functions
c)
labels
d)
formulas
53.
What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously?
a)
copy using the Quick Access toolbar
b)
copy form the Home Ribbon
c)
copy using the fill handle
d)
copy method from shortcut menu
54.
Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
a)
=B4 - C4
b)
=B4/C4
c)
=B4*C4
d)
=B4 + C4
55.
Tyler created a monthly sales worksheet that contains the formula =(January!B3). "January" is an example of a(n):
a)
named range
b)
name manager
c)
scope
d)
external reference
56.
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)
cell reference and cell location are circled
c)
lines connect from the formula to the location
d)
arrows pointing from the formula to the location
57.
Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?
a)
=B1:B3
b)
=1$B$ + 25
c)
=$B$1 + 25
d)
=B1 + 25
58.
Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use?
a)
=B4 =C4
b)
=B4 x C4
c)
=B4 - C4
d)
=B4 * C4
59.
Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?
a)
formula auditing
b)
defined names
c)
calculations
d)
function libary
60.
Which group on the Formulas ribbon contains the command that checks for common errors found in a formula?
a)
defined names
b)
function library
c)
function auditing
d)
calculation
61.
What is prewritten formula that is built into Microsoft Excel called?
a)
procedure
b)
statement
c)
function
d)
utility
62.
Which command on the Home Tab displays the total selected cells directly after the selected cells?
a)
calculate
b)
AutoSum
c)
total
d)
add
63.
Which group on the Formulas ribbon enables a user to specify when a formula is computed?
a)
formula auditing
b)
calcuation
c)
defined names
d)
function library
64.
Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to find the highest test grade?
a)
MIN
b)
AVERAGE
c)
MAX
d)
SUM
65.
Keysha has created a spreadsheet containing student grades. Which function would she use to return the current date and time in cell A1?
a)
TODAY
b)
IF
c)
NOW
d)
COUNT
66.
Which function do you use to insert today's date in a worksheet so that it automatically updates each time the worksheet opened?
a)
Date
b)
CurrentDate
c)
Weekday
d)
Today
67.
Angie is calculating here average sales for the past four months. If she uses "=AVERAGE(B1:B4)", this is an example of which type of entry?
a)
labels
b)
functions
c)
formulas
d)
values
68.
What function adds all of the numbers in a range of cells?
a)
add
b)
sum
c)
calculate
d)
compute
69.
Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to estimate the grade on here next test.
a)
SUM
b)
AVERAGE
c)
MIN
d)
MAX
70.
Where can you find the Insert Function button in Microsoft Excel?
a)
formula bar
b)
status bar
c)
shortcut bar
d)
quick access toolbar
71.
Gabriel needs to crate a shortcut formula in cell B40 to calculate total sales located in cell B1 through B39. Which function should he create?
a)
=$B1 + 25
b)
=B1:B39
c)
=Sum(B1:B39)
d)
=B1 + 25
72.
Which of the following are valid Microsoft Excel functions?
a)
MAX, MIN, WEEK
b)
AVERAGE, MAX, NUM
c)
AVERAGE, MAX, MIN
d)
WEEKDAY, MAX, CLOSE
73.
What command do you use to apply a background color to cells in a worksheet?
a)
fill color
b)
borders and shading
c)
highlight
d)
drawing
74.
Carl noticed that the data in cell E4 reads ######. What command could Carl use to correct this problem?
a)
special formatting
b)
subscript formatting
c)
AutoFit
d)
wrap text
75.
Kathryn needs the title in cell A1 to align horizontally across cell A1 through D1. Which alignment option should she select?
a)
wrap text
b)
merge and center
c)
orientation
d)
center
76.
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)
number
c)
date
d)
text
77.
Which quick number style button formats numbers to display as currency in the worksheet?
a)
accounting
b)
comma
c)
dollar
d)
percent
78.
Which command on the Home ribbon joins selected cells into one and centers the content into a larger single cell?
a)
group cells
b)
cell styles
c)
wrap text
d)
merge and center
79.
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)
paragraph
d)
font
80.
Kenyon would like to apply the Title format to the data in row 1 of a spreadsheet. Which formatting style should he select?
a)
fill color
b)
conditional formatting
c)
format as table
d)
cell style
81.
Trey would like to outline the cell range A1:F20. Which formatting style should he select?
a)
conditional formatting
b)
format as table
c)
borders
d)
cell style
82.
Where can you find the command to apply a fill color to a cell or range of cells in a worksheet?
a)
home ribbon
b)
view ribbon
c)
insert ribbon
d)
page layout ribbon
83.
On the Home ribbon, what do you use to change the text color of characters in a cell?
a)
cell styles drop down box
b)
font size drop down box
c)
fill color drop down box
d)
font color drow down box
84.
Column D in a spreadsheet contains employee ID Number. Which formatting would be most appropriate for the data in Column D?
a)
Number
b)
Date
c)
Text
d)
Currency
85.
What type of formatting appears only when the value in a cell meets conditions specified by a user?
a)
conditional
b)
restrictive
c)
logical
d)
criterion
86.
Which dialog box in Microsoft Excel do you use to set the rotation of text in a cell to a specific degree?
a)
formatting cells
b)
format text
c)
alignment
d)
orientation
87.
Carl notices the last two lines of text in cell B4 are not showing up in his spreadsheet. How could Carl format the cell to correct this problem?
a)
merge
b)
subscript formatting
c)
AutoFiit
d)
Special formatting
88.
Which defines the appearance and shape of teh letters, numbers, and special characters in Microsoft Excel?
a)
size
b)
alignment
c)
effects
d)
font
89.
Which command do you use to reduce the margin between the border and the text in an indented cell?
a)
decrease indent
b)
alignment
c)
column width
d)
orientation
90.
Which command on the Insert ribbon creates a link to a web page, picture, email address, or program in a worksheet?
a)
text link
b)
linkup
c)
hyperlink
d)
web link
91.
Which command on the Home ribbon do you use to rotate text to a vertical or diagonal angle in a worksheet?
a)
merge and center
b)
font
c)
wrap text
d)
orientation
92.
Which command do you use to format a cell or selected cells quickly by choosing from a defined list of styles?
a)
form
b)
format as table
c)
conditional formatting
d)
cell style
93.
Trey would like to apply a rule to the data in cell range A1:F20 that will highlight numbers greater than 50,000 with a yellow fill color and dark yellow text. Which formatting style should he select?
a)
format as table
b)
conditional formatting
c)
borders
d)
cell style
94.
Which command on the home ribbon do you use to remove cells, rows, or columns from a worksheet or table?
a)
format
b)
format as table
c)
remove
d)
delete
95.
What command do you use to insert information into a worksheet that will display at the top and bottom of the printed page?
a)
header and footer
b)
page setup
c)
print titles
d)
margins
96.
Which term describes the blank portions of a page that fall outside the main body of the printed document?
a)
edges
b)
borders
c)
frames
d)
margins
97.
Jack would like the data in row 10 not to display on his spreadsheet. Which option should he select?
a)
scale
b)
header
c)
hide
d)
freeze
98.
John notices that column D is not showing on his spreadsheet. What action does he need to take?
a)
unhide
b)
split
c)
hide
d)
freeze panes
99.
Which command on the Page Layout ribbon enables a user to make where a new page will begin on the printed copy?
a)
breaks
b)
print area
c)
effects
d)
background
100.
Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to worksheet to enhance its appearance?
a)
templates
b)
layout
c)
design
d)
theme
Reset
