Class 10 IT | Chapter - Spreadsheet | Topic - Consolidate and Subtotal Open Office Calc

 Class 10 IT (402) Complete Solution

What is consolidating data in spreadsheet?

Consolidating data means combining data from multiple tables or multiple sheets in a workbook. In consolidating data inbuilt functions are used example: Sum, Count, Average, Max, Min and Product.

 

These are the steps for consolidating data in open office calc

 1) Create tables in a worksheet.

 2) Click Data tab and select consolidate option.

--------------------------------------------------

 Other Topic of this Chapter

• Consolidating & Subtotal
• What if Scenarios & What if tools
• Goal Seek and Solver
  
• Insert Sheet & Create Reference
• Hyperlinks & Types of Hyperlinks
• Sharing Document
• Track Changes in Spreadsheet 
• Macro in Open Office Calc  

-------------------------------------------------

3) A consolidate dialogue box opens up. Select any function example: sum, average, count, max, min or product.

Consolidate Function

 4) Select two tables from worksheet.

5) Now press more buttons and select ‘row labels’, ‘column labels’ and ‘link to source data’. After selection, press OK button and consolidate data is ready.

--------------------------------------------------

 Other Chapters of  IT (402) 

Part - A

Chapter 1 – Communication Skills

Chapter 2 –Self - Management Skills

Chapter 3– ICT Skills

Chapter 4 - Entrepreneurship

Chapter 5 –Green Skills

 Part - B 

Chapter 1 – Digital Documentation
Chapter 2– Electronic Spreadsheet
Chapter 3 –  Database Management System
Chapter 4 –Web Application

--------------------------------------------------

What is Subtotal in OpenOffice Calc?

The Subtotal option is used to automatically create groups and apply inbuilt functions like Sum, Average, Count to summaries data in a sheet.

 

These are the steps to use Subtotal in a sheet

1) Create a table in a sheet. 

2) Go to the data tab for subtotal.
3) Select Subtotal option.

4) In Subtotals dialog box, select ‘Item’ in group by option.

--------------------------------------------------

Sample Paper of Class 10

• English Sample Paper 2022-23
  
• Hindi A Sample Paper 2022-23
• Maths (Standard) Sample Paper 2022-23
• Maths (Basic) Sample Paper 2022-23
• Science Sample Paper 2022-23  
• Social Science Sample Paper 2022-23

-------------------------------------------------

5) In calculate subtotal for box select ‘Quantity’.

Subtotal Dialog Box

6) In use function select “Sum’.
7) Now press 'OK' button.

 Note: In same way we can make three groups in subtotal.

 

--------------------------------------------------

MCQs of All Chapters Class 10 IT (402) 

Part - A

Chapter 1 – Communication Skills

Chapter 2 –Self - Management Skills

Chapter 3– ICT Skills

Chapter 4 - Entrepreneurship

Chapter 5 –Green Skills

 

Part - B 

Chapter 1 – Digital Documentation
Chapter 2– Electronic Spreadsheet
Chapter 3 –  Database Management System
Chapter 4 –Web Application

--------------------------------------------------

--------------------------------------------------

Sample Paper of Class 10 IT 402

• Sample Paper 2020 - 21
  
• Sample Paper 2021 - 22
• Sample Paper 2021 - 22
• Sample Paper 2022 - 23
• Sample Paper 2022 - 23  
• Sample Paper 2022 - 23

-------------------------------------------------