The consolidate option is available under __________ menu.
a) File
b) Insert
c) Tools
d) Data
Answers
Answer:
Data
Explanation:
Data Consolidation allows you to gather together your data from separate worksheets into a master worksheet. In other words, the Data Consolidation function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily.
The trouble is, working with Data Consolidation can be tricky! Don’t be put off. Data Consolidation is an incredibly useful tool that help you understand and present your data quickly and easily. The screen may look daunting but like all great things, good planning is the key.
This example contains some tips from Edmund, one of our Excel experts, and will help you decide how to organise your data before you start summarising it to get easily
The consolidate options is available under data menu