Search for courses or lessons
Redeem a coupon
Start free trial
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
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
Hide the columns that hold the source data and unhide them as the months occur
One of the series was plotted using an NA() result to fill gaps, and the other used 0. Which method did each series use?
Actual used NA() and Budget used 0’s
It is impossible to tell without seeing the source data
Actual used 0’s and Budget used NA()
Which formula will return #N/A if A5 is less than 10?
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement