faisal cute

Question 1

In Excel, what symbol is used before a number or text to make it an absolute reference?

Accepted Answer

2

Question 2

A cell reference like 'A1' is an example of a relative reference.

Accepted Answer

o

Question 3

What does the '$' symbol do to a cell reference in Excel?

Accepted Answer

Locks it

Question 4

Which of the following is an example of a mixed reference in Excel?

Accepted Answer

1

Question 5

When you copy a formula with a relative reference, the reference stays exactly the same.

Accepted Answer

x

Question 6

What is the term for a cell reference that does not change when copied?

Accepted Answer

Absolute

Question 7

If you have a formula in cell B2 that says =A2+C2, and you copy it to cell B3, what will the new formula be?

Accepted Answer

1

Question 8

A cell reference like '$B$5' is a relative reference.

Accepted Answer

x

Question 9

What is the main benefit of using absolute references?

Accepted Answer

Stays fixed

Question 10

Which reference type is useful when you want to multiply a column of numbers by a single constant value?

Accepted Answer

1

Question 11

In Excel, 'A$1' is a mixed reference because only the row is locked.

Accepted Answer

o

Question 12

What type of reference is 'B$2'?

Accepted Answer

Mixed

Question 13

If a formula in cell C3 is =SUM($A$1:$B$2), and you copy it to cell D4, what will the formula become?

Accepted Answer

0

Question 14

A formula with a relative reference will always refer to the same cells when copied.

Accepted Answer

x

Question 15

What is the term for a cell reference that locks either the column OR the row, but not both?

Accepted Answer

Mixed

# 1