Advanced Functions Spreadsheets

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

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?

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

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?

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

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

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

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 ________

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?