Back to lesson
1. Suppose cell B5 contains the formula =$A$1+B1. If this formula is copied to B6, what does the new formula read?
2. Which method for copying cells results in just the formulas being copied?
Copying formulas, then choosing PasteSpecial and clicking Formulas.
Using the fill handle to extend formulas.
Using CTRL + Enter to commit formulas to multiple cells.
3. Suppose you select cells B4:C5, and then enter =B$3+20 and press CTRL + Enter. What will C5 contain?
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement