Toggle navigation
GoSkills
Search for courses or lessons
Courses
For Teams
For Teams
Teach
Blog
Redeem a coupon
Start free trial
Search
Login
Quiz
1
Beginner
If B5 contains the formula =$A$1+B1, what would the formula read if copied to B6?
$A$1+C2
$A$2+B1
$A$1+B2
Don’t know
2
Beginner
Which of the following methods to copy formats will copy just the formulas?
Using the fill handle to extend formulas.
Using Command Enter to commit formulas to multiple cells.
Copying the formulas, then choosing PasteSpecial -> Formulas.
Don’t know
3
Beginner
If you were to select B4:C5, enter =B$3+20 and press Command Enter, what would C5 contain?
=B$4+20
=B$3+20
=C$3+20
Don’t know
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement