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 CTRL + Enter to commit formulas to multiple cells.
Using the fill handle to extend formulas.
Don’t know
3. Suppose you select cells B4:C5, and then enter =B$3+20 and press CTRL + Enter. What will C5 contain?
=B$3+20
=B$4+20
=C$3+20
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement