Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Beginner
The $ sign has a special meaning in an Excel formula. What is its primary purpose?
It anchors the row and / or column specified.
It converts numbers to currency format.
It denotes a text string follows
Don’t know
2
Beginner
The formula in the following equation in cell C6 is not yet finished. Dollar signs ($) need to be added to the equation so that one consistent formula may be copied across and down. Which of the following formulae is correct?
=$B6*C$5*C2
=B$6*$C5*$C$2
=$B6*C$5*$C$2
Don’t know
3
Beginner
Which is the correct keyboard shortcut to test whether there are any inconsistent formulae across a row?
CTRL + \
CTRL + *
: CTRL + SHIFT + \
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement