Back to lesson
1. 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 a blank (using “”) if the month hasn’t occurred yet
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
2. 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 0’s and Budget used NA()
Actual used NA() and Budget used 0’s
It is impossible to tell without seeing the source data
3. Which formula will return #N/A if A5 is less than 10?
Back to the top
© 2018 GoSkills Ltd.
Skills for career advancement