GoSkills
Back to lesson
Question
1
of
3
1. If B5 contains the formula =$A$1+B1, what would the formula read if copied to B6?
$A$1+C2
$A$1+B2
$A$2+B1
Don’t know
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.
Don’t know
3. If you were to select B4:C5, enter =B$3+20 and press Command Enter, what would 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