Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Basics
Test Description: Excel Test Review
Instructions: Answer all questions to get your test result.
1) When keying a formulas in a spreadsheet, what must you key to inform the program that you are entering a formula instead of entering text?
A
=
B
+
C
-
D
/
2) A sales manager has requested the total sales of the first quarter. Which function will be used?
A
MAX
B
SUM
C
MIN
D
AVERAGE
3) 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
Entry
C
Column
D
Row
4) Urla needs to total the cells A1:A10, what is the quickest method to find the answer?
A
Function
B
Label
C
Formula
D
Value
5) Paul has to enter unit price for an product, who will this data be classified?
A
Label
B
Formula
C
Function
D
Value
6) Paul has to enter the zip code for a client. How will this data be classified?
A
Value
B
Formula
C
Label
D
Function
7) ABC Corporation has listed all it’s produced in the cell range A1 to A45, where are the products displayed?
A
Cell Address
B
Entry
C
Row
D
Column
8) After entering the number of sales for the first quarter, where will they align?
A
Right
B
Justified
C
Left
D
Centered
9) Urla needs to total the cells A1:A10, what is the quickest method to find the answer?
A
Label
B
Formula
C
Function
D
Value
10) After entering the number of sales for the first quarter, where will they align?
A
Left
B
Justified
C
Right
D
Centered
11) A sales manager has requested the total sales for the first quarter. Which function will be used?
A
MIN
B
Average
C
SUM
D
MAX
12) A sales manager has requested the highest sale for the first quarter. Which function will be used?
A
SUM
B
MAX
C
MIN
D
AVERAGE
13) A sales manager has requested the lowest sale for the first quarter. Which function will be used?
A
AVERAGE
B
SUM
C
MAX
D
MIN
*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?