Question: What will happen to the pivot table if , having loaded all three data sets for 2 0 1 8 - 2 0 into the

What will happen to the pivot table if, having loaded all three data sets for 2018-20 into the pivot table, you remove the 2019 file from the source folder and do nothing else?
Group of answer choices
Nothing
The numbers presented will now be calculated based on 2018 and 2020.
It will display an error because Excel will recognize that a number is missing from the sequence.
The pivot table data will become unreliable.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!