Back to lesson
1. The $ sign has a special meaning in an Excel formula. What is its primary purpose?
It converts numbers to currency format.
It denotes a text string follows
It anchors the row and / or column specified.
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. Which is the correct keyboard shortcut to test whether there are any inconsistent formulae across a row?
CTRL + *
CTRL + \
: CTRL + SHIFT + \
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement