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
Advanced
Assume you have the function shown below. Where could you call this function from?
The VBA Immediate window by typing: =sCompany()
Excel's Macro dialog
A worksheet cell by typing =sCompany()
Don’t know
2
Advanced
You call the function below from a worksheet cell and it correctly returns the name of the worksheet. What will happen when the worksheet is renamed?
Nothing, but the function will recalculate when the workbook is reopened
Nothing (the function will not recalculate)
The function will update to show the new worksheet name
Don’t know
3
Advanced
If your UDF does not recalculate when the inputs change, what code do you need to add to it?
Function.Volatile
Application.Calculate
Application.Volatile
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement