Quiz | Cell Referencing | Microsoft Excel for Mac - Basic

LMS
Course builder
Courses
Courses
Resources
Pricing
- Organization pricing
- Individual pricing
Pricing
Search

Sign up Log in

Log in Signup

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?
- 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

Beginner

If you were to select B4:C5, enter =B$3+20 and press Command Enter, what would C5 contain?
- =B$3+20
- =B$4+20
- =C$3+20
- Don’t know

Previous question Previous Next question Next

Give feedback

How is your GoSkills experience?

I need help

Comment

Your feedback has been sent

Thank you

Back to the top

© 2023 GoSkills Ltd. Skills for career advancement