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
Which of the following is the correct syntax for the OFFSET function?
=OFFSET(Reference, Columns, Rows, [Width], [Height])
=OFFSET(Reference, Rows, Columns, [Height], [Width])
=OFFSET(Reference, Rows, Columns)
Don’t know
2
Beginner
In the example, what would =SUM(OFFSET(B4,C4,D4,C4,C4)) return?
74
78
#VALUE!
Don’t know
3
Beginner
To transpose using the OFFSET function, which other Excel function would you use in conjunction to show horizontal data vertically?
COLUMNS
ROWS
INDEX
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement