Excel 2016 Lesson 4

Would the formula (5*3)/4 give the same answer as 5*3/4?

• Yes

• No

• It depends

A/an ____________ cell reference is one that adjusts the cell identifier automatically if you insert or delete columns or rows or if you copy the formula to another cell.

• relative

• absolute

• neither

Where can you see formulas?

• The formula bar

• The cell that contains the answer to the formula if you double click on it.

• Both A and B

Which type of reference uses dollar signs?

• Relative

• Absolute

Which of the following would make the best name when naming a range?

• adv time

• adv?time

• adv_time

• None of these

You can name a cell or a cell range by

• Selecting the cell(s) to be named, click in the name box, type the name in and press enter

• Click on Define Name on the Formulas tab

• Select text to be named and click on Create from Selection

• All of the above

=(A1+A2+A3) is an example of a

• value

• label

• formula

Which cell reference will change if a formula is copied?

• Absolute

• Relative

Which cell reference keeps the cell reference the same if the formula is copied?

• Relative

• Absolute

=(January!B3) is a reference of

• a named range

• an external reference (a different worksheet)

• the name manager