WorksheetsExcel Lessons 1-5
Total questions: 30
Worksheet time: 14mins
Name
Class
Date
1.
a)
tab
b)
worksheet tab
c)
new worksheet
2.
a)
Pages
b)
Page break preview
c)
Normal
d)
Page layout
3.
a)
Zumba
b)
Zoom
c)
Zoom level
d)
Zoomer
4.
a)
namer
b)
name box
c)
box
d)
text display
5.
a)
row
b)
column
c)
active cell
d)
cell
6.
Which of the following correctly describes the default selection for AutoSum?
a)
You must make the selection before clicking AutoSum
b)
By default, AUTOSUM totals all entries above the cell in which the formula is located, even if the cells contain text and numbers
c)
By default, AutoSum calculates the total from the adjacent cell through the first non numeric cell
d)
AutoSum doesn't have a default selection
7.
You want to SUM multiple noncontinuous (not together) cell ranges that are named. Which of the following is best to use?
a)
AutoSum
b)
SUBTOTAL
c)
MAX
d)
MIN
8.
The COUNT and MIN functions are examples of which category of functions?
a)
text
b)
statistical
c)
financial
d)
logical
9.
You want to calculate the number of non-blank cells in your worksheet. Which function do you use?
a)
SUM
b)
COUNT
c)
COUNTA
d)
MAX
10.
You want to create a formula that calculates the number of years you have lived. You were born in 1991
a)
=YEAR(TODAY())-1991
b)
=YEAR(TODAY())+1991
c)
=YEAR(COUNT())-1991
d)
=YEAR(COUNT())+1991
11.
Which of the following is not an arithmetic operator?
a)
+
b)
-
c)
*
d)
]
12.
Per the order of operations, which of the following is calculated first?
a)
addition and subtraction left to right
b)
exponents
c)
percent
d)
negative numbers
13.
Which of the following shows a formula for a reference to another worksheet in the same workbook?
a)
=SUM(C12:E12)
b)
=Q3Expenses!A19
c)
=[Media.xlsx]MasterList!$D$10
d)
=SUM(budget.summary)
14.
Which of the following is an example of an absolute cell reference?
a)
A9
b)
A$9
c)
$A$9
d)
A9:E9
15.
Which of the following is an acceptable name for a named range?
a)
C7
b)
subtotal_west
c)
subtotal west
d)
subtotal/west
16.
Which of the following can you NOT do using the Name Manager?
a)
Enter values into a range
b)
Change a range name
c)
Delete a named range
d)
Verify the scope of a range
17.
A function that returns today's date and the current time
a)
NOW
b)
TODAY
c)
SUM
d)
SUBTOTAL
18.
A function that requires a series of inputs regarding interest rates, loan amount, and loan duration, and then calculates the resulting loan payment
a)
PMT
b)
NOW
c)
SUBTOTAL
d)
SUM
19.
A function that returns the current date in a worksheet
a)
TODAY
b)
NOW
c)
COUNT
d)
COUNTA
20.
An Excel feature that enables you to specify how cells that meet one or more given conditions should be displayed
a)
Attribute
b)
Conditional formatting
c)
Hyperlink
d)
Align
21.
Which ribbon tab contains the Clear Print Area option?
a)
Home
b)
Page Layout
c)
Formulas
d)
Data
22.
What command is used to insert information into a worksheet that will display at the top and bottom edges of the printed page?
a)
Margins
b)
Print titles
c)
Header & Footer
d)
Page Setup
23.
=(A1+A2=A3) is an example of what type of entry?
a)
value
b)
formula
c)
label
24.
Which cell reference keeps the cell reference the same if formula is copied?
a)
absolute
b)
relative
c)
mixed
25.
Which cell reference automatically changes when formula is copied?
a)
absolute
b)
relative
c)
mixed
26.
What method is the most efficient way to copy five separate formulas to adjacent cells at same time?
a)
copy method from shotrcut menu
b)
copy using the fill handle
c)
copy from home ribbon
d)
copy using QAT
27.
What term is used when referencing cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?
a)
calling the sheet
b)
name reference
c)
sheet name
d)
worksheet reference
28.
A predefined set of colors, fonts, and effects that can be applied to an entire workbook or to specific items in a workbook.
a)
document theme
b)
effects
c)
gridlines
d)
orientation
29.
The position of the content in a worksheet, so that it prints either vertically or horizontally on a page.
a)
boundary
b)
document theme
c)
effects
d)
orientation
30.
The lines that display around worksheet cells.
a)
boundary
b)
effects
c)
gridlines
d)
column width
100 %
