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
Division operator
B
Subtraction sign
C
Equal sign
D
Addition 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
Cell Address
B
Column
C
Entry
D
Row
3) A sales manager has requested the total sales for the first quarter. Which function will be used?
A
MAX
B
SUM
C
MIN
D
AVG
4) ABC Corporation has listed all of its products in the cell range A1 to A45. Where are the products displayed?
A
Column
B
Entry
C
Cell Address
D
Row
5) Paul has to enter the zip code for a client. How will this data be classifed?
A
Label
B
Function
C
Formula
D
Value
6) Paul has to enter a unit price for a product. How will this data be classifed?
A
Value
B
Formula
C
Label
D
Function
7) Samantha needs to total the cell range A1 to A10. What is the MOST efficient method to find the answer?
A
Function
B
Formula
C
Value
D
Label
8) A sales manager has requested the highest sale for the first quarter. Which function will be used?
A
MIN
B
SUM
C
MAX
D
AVG
9) A sales manager has requested the lowest sale for the first quarter. Which function will be used?
A
MAX
B
AVG
C
MIN
D
SUM
10) After entering the number of sales for the first quarter, where will they align?
A
Right
B
Centered
C
Left
D
Justified
11) The column letter and row number make up what?
A
Chart
B
Formula bar title
C
Cell content
D
Cell address
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
=MAX(A1:A6)
B
=SUM(A1:A6)
C
=AVERAGE(A1:A6)
D
=MIN(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?