Excel Advanced Functions

Which of the following is a mixed cell reference with a fixed column address?

• G$9
• $K356
• $F$8

The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____

• A1-J15
• A1;J15
• A1:J15

What symbol prepares a cell for the entry of a formula?

• +
• -
• /
• =

The 4 arguments used in the VLookUp function are: look up value, _________, column number, range lookup

• table array containing data
• Price of the item being looked for

The LookUp function has 3 arguments. First ___________ then table array and finally, results column

• Value to Look Up
• Value to Calculate

What is the name of this cell?

• B10
• 5B
• B5
• you cannot know the name from this picture

What value will be in the blue shaded cell?

• 23
• 17
• 19
• 34

What tab would you find a list of functions and formulas on in Excel?

• Home
• Insert
• Page Layout
• Formulas

Is the information below in the right order for an IF statement?
Cell to look for, True, False

• Yes
• No

Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the cells in that range that contain 100. What function should he use?

• SUMIF
• AVERAGEIF
• TOTALIF
• COUNTIF