Question

Explain data consolidation, subtotals and scenario tools in spreadsheet. class 10th

bhai log mereko subtoltals aur scenario tool kabhi explaination chaheye​

Answer 1

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