Spreadsheet #1

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

The sales manager wants to know if all the salespersons met their goal of $5000 this month. Which of the following spreadsheet functions would give him/her the answer?

Daryl uses a spreadsheet program to balance his checkbook and wants to see which month between June and December had the highest expenses. What type of mathematical operator should he use?

To make spreadsheet row and/or column titles remain stationary on the screen, which command should be used?

Which is NOT a valid mathematical operator?

Joe is going to use fill down to enter the formula =B1/$C$1 into the cells Al:A25. What does the "$" represent in the formula?

Ms. Mozingo, the data entry clerk for the school, needs to rank student athletes in descending order by GPA and last name. She is preparing a/an:

Felix wants to rotate a label in his spreadsheet. Which tab from the format cell dialogue box should he choose?

Pam is going to use fill down to enter the formula =B1/$C$1 into cells A1:A25. What does the "B1" represent in the formula?