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
Your assistant has set up a chart that they can just fill in the appropriate values after they occur. What do you need to do in order to suppress the future months from the chart?
Modify the month names in the source data to use an IF function that returns #N/A if the month hasn’t occurred yet
Hide the columns that hold the source data and unhide them as the months occur
Modify the month names in the source data to use an IF function that returns a blank (using “”) if the month hasn’t occurred yet
Don’t know
2
Advanced
One of the series was plotted using an NA() result to fill gaps, and the other used 0. Which method did each series use?
It is impossible to tell without seeing the source data
Actual used NA() and Budget used 0’s
Actual used 0’s and Budget used NA()
Don’t know
3
Advanced
Which formula will return #N/A if A5 is less than 10?
=IF(A5>10,NA(),A5)
=IF(A5<10,NA(),A5)
=IF(A5<10,””,A5)
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement