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+B2
$A$2+B1
$A$1+C2
Don’t know
2
Beginner
Which of the following methods to copy formats will copy just the formulas?
Copying the formulas, then choosing PasteSpecial -> Formulas.
Using Command Enter to commit formulas to multiple cells.
Using the fill handle to extend 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$3+20
=C$3+20
=B$4+20
Don’t know
Back to the top
© 2020 GoSkills Ltd.
Skills for career advancement