Excel Review #1

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 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

A graphical representation of data is a

• Chart
• column
• cell
• X-axis

James has created a spreadsheet containing student grades. Which function would he use to return the current date in cell A1?

• COUNT
• IF
• NOW
• TODAY