GoSkills
Back to lesson
Question
1
of
3
1. Suppose cell B5 contains the formula =$A$1+B1. If this formula is copied to B6, what does the new formula read?
=$A$1+B2
=$A$2+B1
=$A$1+C2
Don’t know
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.
Don’t know
3. Suppose you select cells B4:C5, and then enter =B$3+20 and press CTRL + Enter. What will C5 contain?
=C$3+20
=B$3+20
=B$4+20
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement