Back to lesson
1. If B5 contains the formula =$A$1+B1, what would the formula read if copied to B6?
2. Which of the following methods to copy formats will copy just the formulas?
Using the fill handle to extend formulas.
Copying the formulas, then choosing PasteSpecial -> Formulas.
Using Command Enter to commit formulas to multiple cells.
3. If you were to select B4:C5, enter =B$3+20 and press Command Enter, what would C5 contain?
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement