what do you mean by data …
CBSE, JEE, NEET, CUET
Question Bank, Mock Tests, Exam Papers
NCERT Solutions, Sample Papers, Notes, Videos
Posted by Bobby Dubey 3 years, 10 months ago
- 1 answers
Related Questions
Posted by Pavi S 2 months, 1 week ago
- 0 answers
Posted by Hardika . 2 months, 2 weeks ago
- 0 answers
Posted by Sudharshini Kanthasamy 2 months ago
- 1 answers
Posted by Ayushi Singh 2 months, 1 week ago
- 0 answers
Posted by Manyata Mishra 2 months, 2 weeks ago
- 0 answers
Posted by Account Deleted 2 months, 1 week ago
- 0 answers
Posted by Jatin Jaat 2 months, 1 week ago
- 0 answers
Posted by Ritik Sirohi 2 months, 2 weeks ago
- 0 answers
Posted by Chandan Kedia 2 months, 2 weeks ago
- 0 answers
myCBSEguide
Trusted by 1 Crore+ Students
Test Generator
Create papers online. It's FREE.
CUET Mock Tests
75,000+ questions to practice only on myCBSEguide app
Gaurav Seth 3 years, 10 months ago
Step 1: Open all files (workbooks) that contain the data you want to consolidate.
Step 2: Ensure the data is organized in the same way (see example below).
Step 3: On the Data ribbons, select Data Tools and then Consolidate.
Step 4: Select the method of consolidation (in our example, it’s Sum).
Step 5: Select the data, including the labels, and click Add
Step 6: Repeat step 5 for each worksheet or workbook that contains the data you need included
Step 7: Check boxes “top row”, “left column”, and “create links to data source” (note you don’t have to tick these boxes if you don’t want labels or don’t want live links) and click the OK button.
1Thank You