Advanced Functions Spreadsheets Question Preview (ID: 37674)


This Is To Test Your Understanding Of Advanced Functions. TEACHERS: click here for quick copy question ID numbers.

In a spreadsheet, which function will result in the total number of entries in a cell range?
a) Count
b) Max
c) Min
d) Sum

In a spreadsheet, to view the data for a specific department, use the _________ funciton.
a) count
b) if
c) list
d) sum

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) fill series
b) freeze panes
c) link
d) sort

Mrs. Jay uses a spreadsheet to keep track of student scores. Which function should she use to calculate a final grade?
a) Average
b) Count
c) If
d) Sum

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) Ascending
b) Descending
c) Primary
d) Secondary

In the formula, =F10*$J$4, F10 is an example of a/an:
a) absolute reference
b) mixed reference
c) range
d) relative reference

Which function can be used that will result in the current data?
a) Count
b) CountA
c) Days360
d) Now

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) LookUp
c) Max
d) Min

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) Embed
b) Fill series
c) Freeze
d) Link

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

What formula will divide the value in Cell E5 by the value in Cell E6?
a) =E5/E6
b) =E5:E6
c) =E6/E5
d) =E6:E5

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 37674 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links