8. Using consolidating data Prepare worksheet as given below and do as directed: A B D E 1 S.No 2 3 4 5 Name 1 Aman 2 Abhishek 3 Akshit 4 Bhavik 5 Atul 6 Ayush 7 Ketan 8 Raj 9 Harsh 10 Mahesh Quarter 1 535 635 856 652 745 963 854 758 745 852 Quarter 2 635 968 789 568 698 635 458 754 632 965 6 Quarter 3 598 867 354 321 348 657 473 429 457 432 7 10 11 1. Add two worksheets in the file and modify the data for all 4 quarters. 2. Rename all worksheets like sheet1 2018. sheet2 -- 2019 and sheet3 - 2020. 3. Now add one more worksheet at the end and rename as consolidated sheet. 4. Now type the serial no and names as displayed, use sum function to add data for 2018, 2019 and 2020 in respective cells using consolidation.
Answers
Answered by
0
Explanation:
sorry I don't know the answer
Answered by
0
Explanation:
Data Consolidation allows one 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 summarises it into a single worksheet that one can update easily.
The trouble is, working with Data Consolidation can be tricky!
Data Consolidation is an incredibly useful tool that helps one understand and present the data quickly and easily.
The screen may look daunting but like all great things, good planning is the key.
Similar questions