Timedora
Free Practice Quiz Question List

2 Formulas and Cell References Online Quiz Questions

Use this free practice quiz with 20 questions to review 2 Formulas and Cell References, test your knowledge, and prepare for your next test or exam.

20 questions
01
Choose one
1 point

In the formula =(A2+B2)*C2, which operation is performed first?

  1. A

    Addition of A2 and B2

  2. B

    Multiplication of B2 and C2

  3. C

    Addition of A2 and C2

  4. D

    Multiplication of A2 and B2

02
Choose one
1 point

What does the formula =SUM(B2:B10) calculate?

  1. A

    It adds only the values in B2 and B10.

  2. B

    It adds the values in every cell from B2 through B10.

  3. C

    It multiplies the values in every cell from B2 through B10.

  4. D

    It adds the values in column B from row 2 onward without an endpoint.

03
True or false
1 point

True or false: A cell displaying ##### always contains a formula error.

  1. A

    True

  2. B

    False

04
True or false
1 point

True or false: In many spreadsheet apps, pressing F4 while editing a reference cycles through relative, absolute, and mixed forms.

  1. A

    True

  2. B

    False

05
Written response
1 point

A2 contains a unit price and B2 contains a quantity. What formula should you enter in C2 to calculate the subtotal?

06
Written response
1 point

What error code indicates an invalid cell reference?

07
Choose all
1 point

Select all accurate descriptions of these cell references.

  1. A

    A2 is relative and adjusts when copied.

  2. B

    $F$1 is absolute and locks both its column and row.

  3. C

    $A2 locks column A while allowing the row to change.

  4. D

    A$2 locks column A while allowing the row to change.

08
Choose all
1 point

Select all useful ways to check whether a spreadsheet formula and its result are correct.

  1. A

    Confirm that referenced cells contain the intended values and that numbers were not entered as text.

  2. B

    Inspect the formula bar for operators, parentheses, references, and function arguments.

  3. C

    Calculate a simple known example by hand and compare it with the result.

  4. D

    Check copied formulas to see whether row-specific references changed as expected.

  5. E

    Treat a plausible displayed number as proof that the formula answers the intended question.

  6. F

    Treat ##### as proof that the formula is incorrect.

09
Fill in the blank
1 point

When =A2*B2 is copied from C2 to C3, it becomes =*.

10
Fill in the blank
1 point

When =C2*(1+$F$1) is copied from D2 to D3, it becomes =*(1+).

11
Choose one
1 point

A2 contains a unit price of 12, B2 contains a quantity of 3, and F1 contains a tax rate of 8%. If D2 uses =C2*(1+$F$1) and C2 contains the subtotal, what value should D2 display?

  1. A

    36.00

  2. B

    38.08

  3. C

    38.88

  4. D

    48.00

12
Open ended
1 point

A sales worksheet should calculate a subtotal by multiplying unit price by quantity. A2 contains 12 and B2 contains 3, but C2 displays 15 using =A2+B2. Explain why the result is wrong, give the corrected formula, and describe two checks you could use to verify the correction.

13
True or false
1 point

True or false: If a referenced value was accidentally entered as text, checking the input type can help explain an unexpected formula result.

  1. A

    True

  2. B

    False

14
Choose one
1 point

Which formula adds the values in A2 and B2 first, then multiplies their sum by the value in C2?

  1. A

    =(A2+B2)*C2

  2. B

    =A2+B2*C2

  3. C

    =A2*(B2+C2)

  4. D

    =(A2*B2)+C2

15
Choose one
1 point

The formula =A2*B2 is in C2. If it is copied down one row to C3, what formula appears in C3?

  1. A

    =A2*B2

  2. B

    =A3*B3

  3. C

    =A3*B2

  4. D

    =A2*B3

16
Written response
1 point

A2 contains 18 and B2 contains 3. What result does the formula =A2/B2 calculate?

17
Choose one
1 point

The formula =C2*(1+$F$1) is in D2. Which formula results when it is copied down one row to D3?

  1. A

    =C3*(1+$F$1)

  2. B

    =C3*(1+F1)

  3. C

    =C2*(1+$F$1)

  4. D

    =C3*(1+$F$2)

18
Choose one
1 point

A formula will be filled across and down a grid. Which statement correctly describes how the reference $A2 behaves?

  1. A

    $A2 keeps column A fixed but allows the row to change.

  2. B

    $A2 keeps row 2 fixed but allows the column to change.

  3. C

    $A2 keeps both column A and row 2 fixed.

  4. D

    $A2 allows both the column and row to change.

19
Choose one
1 point

A result seems reasonable, but you suspect the formula may refer to the wrong cells. What is the best first step to inspect the formula?

  1. A

    Widen the column until the displayed result changes.

  2. B

    Replace every cell reference with a typed-in value.

  3. C

    Check only whether nearby cells show similar numbers.

  4. D

    Select the cell and inspect its formula bar for incorrect references or operators.

20
Written response
1 point

A formula contains a misspelled function name, and the spreadsheet reports an error for unrecognized text. What error code is most likely displayed?