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
Why aren’t spaces allowed in a range name?
Space is the intersect operator in Excel: the software would assume one name is being intersected with another.
It is difficult for end users to determine how many spaces there are between characters.
They are allowed.
Don’t know
2
Beginner
Which feature / function allows you to replace cell reference(s) with range names in Excel for all occurrences on a worksheet?
SUBSTITUTE Excel function
‘Use in Formula’ from the ‘Defined Names’ section of the ‘Formulas’ tab of the Ribbon.
‘Apply Names…’ from the ‘Defined Names’ section of the ‘Formulas’ tab of the Ribbon.
Don’t know
3
Beginner
In the illustration, cells E2:I2 have been given the range name Varying_Tax_Rate. If the formula in cell J7 is =-J6*Varying_Tax_Rate, what will the result be in the highlighted (red) cell, J7?
#REF!
300
#VALUE!
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement