Advanced Functions Spreadsheets

Match it! Select the correct answer from the pull down...Good luck!

What formula will divide the value in Cell E5 by the value in Cell E6?

Which function can be used that will result in the current data?

Mrs. Jay uses a spreadsheet to keep track of student scores. Which function should she use to calculate a final grade?

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?

In a spreadsheet, which function will result in the total number of entries in a cell range?

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?

In the formula, =F10*$J$4, F10 is an example of a/an:

In a spreadsheet, to view the data for a specific department, use the _________ funciton.