Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Advanced Functions Spreadsheets
Test Description: This is to test your understanding of Advanced Functions.
Instructions: Answer all questions to get your test result.
1) In a spreadsheet, which function will result in the total number of entries in a cell range?
A
Max
B
Count
C
Sum
D
Min
2) In a spreadsheet, to view the data for a specific department, use the _________ funciton.
A
sum
B
list
C
if
D
count
3) The format applied to a spreadsheet that keeps one or more rows or columns from moving when the user scrolls either down or to the side is ________
A
freeze panes
B
fill series
C
link
D
sort
4) Mrs. Jay uses a spreadsheet to keep track of student scores. Which function should she use to calculate a final grade?
A
Count
B
If
C
Average
D
Sum
5) Mr. Evans sorted the student athletes in order by GPA, last name, first name, and homeroom. GPA is an example of which part of the sort operation?
A
Secondary
B
Primary
C
Descending
D
Ascending
6) In the formula, =F10*$J$4, F10 is an example of a/an:
A
mixed reference
B
relative reference
C
range
D
absolute reference
7) Which function can be used that will result in the current data?
A
Now
B
Days360
C
CountA
D
Count
8) Sam uses a spreadsheet to maintain inventory at his store and wants to use a formula that will automatically reorder items when they reach a certain quantity. Which function should he use?
A
LookUp
B
Min
C
IF
D
Max
9) Ed arranged his spreadsheet so that he could view the cell range A1:A10 and Row 2 while he worked in cells on Row 179. This is an example of which operation?
A
Fill series
B
Embed
C
Link
D
Freeze
10) Purchase discounts are awarded as follows: 3% for $300, 5% for $500, and 9% for 900 or more. What function is used to determine which discount is allowed based on the purchase price?
A
Count
B
Days360
C
List
D
LookUp
11) What formula will divide the value in Cell E5 by the value in Cell E6?
A
=E6/E5
B
=E6:E5
C
=E5:E6
D
=E5/E6
*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?