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
Sum
B
Min
C
Max
D
Count
2) In a spreadsheet, to view the data for a specific department, use the _________ funciton.
A
list
B
count
C
if
D
sum
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
link
B
sort
C
freeze panes
D
fill series
4) Mrs. Jay uses a spreadsheet to keep track of student scores. Which function should she use to calculate a final grade?
A
Sum
B
Count
C
Average
D
If
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
Descending
B
Ascending
C
Primary
D
Secondary
6) In the formula, =F10*$J$4, F10 is an example of a/an:
A
relative reference
B
absolute reference
C
range
D
mixed reference
7) Which function can be used that will result in the current data?
A
Now
B
Days360
C
Count
D
CountA
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
IF
B
Min
C
Max
D
LookUp
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
Link
B
Freeze
C
Embed
D
Fill series
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
List
B
Count
C
Days360
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?