1. 1

    The $ sign has a special meaning in an Excel formula. What is its primary purpose?

  2. 2

    The formula in the following equation in cell C6 is not yet finished. Dollar signs ($) need to be added to the equation so that one consistent formula may be copied across and down. Which of the following formulae is correct?

  3. 3

    Which is the correct keyboard shortcut to test whether there are any inconsistent formulae across a row?