Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Spreadsheets
Test Description: Module 7
Instructions: Answer all questions to get your test result.
1) 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
Equal sign
C
Subtraction sign
D
Division operator
2) ABC Corporation has listed all of its sales information for one product in the cell range A1 to K1. Where is this sales information displayed?
A
Row
B
Column
C
Cell Address
D
Entry
3) A sales manager has requested the total sales for the first quarter. Which function will be used?
A
MAX
B
MIN
C
SUM
D
AVG
4) ABC Corporation has listed all of its products in the cell range A1 to A45. Where are the products displayed?
A
Entry
B
Row
C
Cell Address
D
Column
5) Paul has to enter the zip code for a client. How will this data be classifed?
A
Formula
B
Label
C
Value
D
Function
6) Paul has to enter a unit price for a product. How will this data be classifed?
A
Formula
B
Label
C
Value
D
Function
7) Samantha needs to total the cell range A1 to A10. What is the MOST efficient method to find the answer?
A
Formula
B
Label
C
Function
D
Value
8) A sales manager has requested the highest sale for the first quarter. Which function will be used?
A
AVG
B
MAX
C
SUM
D
MIN
9) A sales manager has requested the lowest sale for the first quarter. Which function will be used?
A
MAX
B
SUM
C
AVG
D
MIN
10) After entering the number of sales for the first quarter, where will they align?
A
Right
B
Left
C
Justified
D
Centered
11) The column letter and row number make up what?
A
Cell content
B
Cell address
C
Chart
D
Formula bar title
12) When entering the client's names, what is the default alignment?
A
Left
B
Justified
C
Centered
D
Right
13) Which if the following is the correct way to write a function in a spreadsheet?
A
SUM(A1:A5)=
B
=SUM(A1+A5)
C
=SUM(A1-A5)
D
=SUM(A1:A5)
14) The contents in cells A1 through A6 are 6, 3, 4, 7, 9, and 7. What function would return the answer 6?
A
=AVERAGE(A1:A6)
B
=MAX(A1:A6)
C
=MIN(A1:A6)
D
=SUM(A1:A6)
*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?