Form 3 Excel Referencing Quiz

What does a cell reference like B3 mean in Excel?

• Column B, Row 3

• Row B, Column 3

• Cell number 3 in the list

• A formula

What is an absolute reference in Excel?

• A cell reference that can change when copied

• A reference that includes only the row

• A reference that stays the same when copied

• A reference that shows an error

Which of the following is an example of an absolute reference?

• A1

• B2

• $A$1

• C$3

If you copy the formula =A1 + B1 from cell C1 to cell C2, what will the new formula be?

• =A1 + B1

• =A2 + B2

• =A1 + B2

• =C1 + D1

What is the difference between relative and absolute referencing?

What happens when you copy the formula =$A1 + B$1 to another cell?

• Both references stay the same

• Row and column always change

• Only the fixed parts ($A and $1) stay the same

• The whole formula becomes an error

Which symbol is used to make a reference absolute in Excel?

• *

• #

• $

• &

Which of the following is a mixed reference?

• $C$5

• C5

• $C5

• =SUM(A1:A5)

If cell D5 contains =B1 + $A$1 and you copy it to E6, what will it be in E6?

• =B1 + $A$1

• =C2 + $A$1

• =C1 + A1

• =B1 + A1

What is the main advantage of using absolute references in formulas?

• It makes the spreadsheet faster

• It keeps certain values constant when copying formulas

• It deletes unnecessary cells

• It changes values automatically