Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Spreadsheets - Formulas And Functions
Test Description: Formulas and Functions
Instructions: Answer all questions to get your test result.
1) What is a formula?
A
Alphabetical data
B
a group of cells
C
Numerical data
D
Statement that performs a calculation
2) What is a function?
A
Shortcut formula for common calculations
B
Numerical data
C
The automatic recalculation of cells
D
Alphabetical data
3) When keying a formula, what must you key to inform the program that you are entering a formula instead of text?
A
divison operator
B
Equal sign
C
Addition operator
D
subtraction operator
4) A spreadsheet function that indicates the lowest value in a range is called?
A
MIN
B
AVERAGE
C
MAX
D
COUNT
5) A spreadsheet function that indicates the highest value in a range is called?
A
MAX
B
SUM
C
COUNT
D
MIN
6) A spreadsheet function used to add numbers in a range is called?
A
MIN
B
MAX
C
SUM
D
AVERAGE
7) A spreadsheet function that indicates the average of a group of numbers in a range is called?
A
SUM
B
MAX
C
MIN
D
AVERAGE
8) A spreadsheet function that counts the number of cells in a range that contains data is called?
A
AVERAGE
B
MAX
C
COUNT
D
SUM
9) What is the symbol that represents multiplication in a spreadsheet?
A
+
B
/
C
*
D
-
10) What is the symbol that represents addition in a spreadsheet?
A
*
B
-
C
/
D
+
11) What is the symbol that represents division in a spreadsheet?
A
+
B
-
C
*
D
/
12) What is the symbol that represents subtraction in a spreadsheet?
A
+
B
/
C
*
D
-
*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?