Question

Statement I: The data from the consolidation ranges and target range are saved when you save the worksheet. Statement II : If you later open a worksheet in which consolidation has been defined, this data will not be available again. Consider above two statements, identify the correct one. (a) Statement I is wrong b) Statement II is wrong (c) Both the Statements I and II are wrong (d) Both the Statements I and II are correct​

Answer 1

Answer:

answer is options b is correct

Answer 2

Answer:

(b) Statement II is wrong

Explanation:

• Statement 1 says When you save the spreadsheet, the data from the consolidation ranges and target range is stored.
• This is true. Statement 1 is true
• According to statement 2 This data will not be available if you later visit a worksheet in which consolidation has been defined.
• This is false because, the data will still be available even when opened worksheet later.
• Hence Statement II is wrong