Q1. _________ allows you to gather data from different worksheets into a master worksheet.

• a. Data Consolidation

• b. Goal Seek

• c. Solver

• d. Total data

Q2. Consolidate option is available under _________ menu.

• a. View

• b. Tool

• c. Insert

• d. Data

Q3. Data can be consolidated from two sheets only.(T/F)

• a. True

• b. False

Q4. We can consolidate data by ________

• a. Row Label

• b. Column Label

• c. Both of the above

• d. None of the above

Q5. Which of the following functions are available in consolidate window?

• a. Max

• b. Min

• c. Count

• d. All of the above

Q6. In which option we have to specify the target range(Where we want the result to be displayed)

• a. Source data range

• b. Copy results to

• c. Need result at

• d. target range

Q7. If you select ________ then any values modified in the source range are automatically updated in the target range.

• a. Link to source data

• b. Link to sheet data

• c. Link to original data

• d. Link to source range

Q8. Which option is used to name a range of cells?

• a. Range name

• b. Cell Range

• c. Define Range

• d. Select Range

Q9. Define range option is available under ________ menu.

• a. Insert

• b. View

• c. Developer

• d. Data

Q10. The text in the row label or column label must be identical while consolidate, otherwise, new row or column will be inserted.(T/F)

• a. True

• b. False