NEW
Font size
S
M
L
XL
WorksheetsSpreadsheet Basics & Formula
Total questions: 14
Worksheet time: 7mins
Name
Class
Date
1.
After entering the number of sales for the first quarter, where will they align?
a)
Right
b)
Left
c)
Centered
d)
Justified
2.
A sales manager has requested the highest sale for the first quarter. Which function will be used?
a)
SUM
b)
MIN
c)
MAX
d)
AVG
3.
A sales manager has requested the lowest sale for the first quarter. Which function will be used?
a)
SUM
b)
MIN
c)
MAX
d)
AVG
4.
Samantha needs to total the cell range A1 to A10. What is the MOST efficient method to find the answer?
a)
Label
b)
Value
c)
Formula
d)
Function
5.
Paul has to enter a unit price for a product. How will this data be classified?
a)
Label
b)
Value
c)
Formula
d)
Function
6.
ABC Corporation has listed all of its products in the cell range A1 to A45. Where are the products displayed?
a)
A. Row
b)
B. Column
c)
C. Entry
d)
D. Cell address
7.
Paul has to enter the zip code for a client. How will this data be classified?
a)
A. Label
b)
B. Value
c)
C. Formula
d)
D. Function
8.
A sales manager has requested the total sale for the first quarter. Which function will be used?
a)
SUM
b)
MIN
c)
MAX
d)
AVG
9.
ABC Corporation has listed all of its products in the cell range A1 to K1. Where is this sales information displayed?
a)
Row
b)
Column
c)
Entry
d)
Cell address
10.
When keying a formula in a spreadsheet, what must you key to inform the program that you are entering a formula instead of entering text?
a)
Addition Operator
b)
Division Operator
c)
Equal Sign
d)
Subtraction Sign
11.
The column letter and row number make up what?
a)
Cell address
b)
Cell content
c)
Formula bar title
d)
Chart
12.
When entering the client’s names, what is the default alignment?
a)
Right
b)
Left
c)
Centered
d)
Justified
13.
John needs to total the cell range A1 to A3. What is the MOST efficient method to find the answer?
a)
A. Labels
b)
B. Values
c)
C. Formula
d)
D. MAX
14.
The contents in cells A1 through A6 are 6, 3, 4, 7, 9, and 7. What function would return the answer 6?
a)
=MAX(A1:A6) )
b)
=MIN(A1:A6
c)
. =AVG(A1:A6) )
d)
=SUM(A1:A6
Reset
