class X (Electronics Spreadsheet(Advanced Using LibreOffice CALC)

-

 Session -1 

What is Subtotal?

Subtotal is a feature in LibreOffice Calc used to automatically calculate partial totals(such as Sum, Average, Count, etc.). for a group of data. It works best when the data is sorted.

Why Subtotal is used?

  • To summarize large data easily
  • To calculate group wise totals
  • To avoid manual calculations
  • To generate reports quickly
Steps to Calculate Subtotals
  1. Select the entire data range
  2. Go to Data- Subtotals
  3. In the Subtotals dialog box, specify: Group by- Column where data changes(eg.TYPE)
          Calculate subtotals for- Numeric column (e.g. QUANTITY)
          Use function(Sum, Count, Average, Max, Min, Product) Default function is SUM.
4. Click Ok

Advantages of Subtotal:
1. Saves Time: Subtotal automatically calculates totals, averages, counts, etc. for each group of data. This reduces the need for manual calculations and saves a lot of time.
2. Easy Data Analysis: Subtotal helps in analyzing data group-wise, such as class-wise marks, products-wise sales, or month-wise expenses.  
3. Automatic Grouping: Subtotal automatically inserts subtotal rows whenever the value in the selected group by column changes.

Data Consolidation: Data Consolidation is the process of combining data from multiple worksheets, ranges, or sources into a single worksheet to create a summary or several report.
Example: 
If months sales data is stored in :
  • January Sheet
  • February sheet
  • March Sheet
Using Data Consolidation, all months' data can be combined into one summary sheet showing total sales.
Advantages of Data Consolidation 
1. Saves time: Data from different worksheets or files can be combined automatically.
2. Easy Data Analysis : By consolidating data into one worksheet, it becomes easier to analyze and compare information from different sources.
3. Reduce errors: Manual data entry can cause mistakes. Data consolidation reduces human errors by performing automatic calculations.
4. Provides a Single Summary Report: All related data is shown in one place, creating a clear and organized summary report.

Steps of Data Consolidation in LibreOffice Calc:
Step1: Prepare the data
(Ensure all data ranges have a similar structure same headings).
(Data can be in the same sheet or different sheets.

Step 2: Select the Destination cell 
(Open a new worksheet where you want to consolidate result.)
Step 3: Go to Data Menu (Click on the Data menu and Select Consolidate)
Step 4: Consolidate Dialog box



Comments

Post a Comment

Popular posts from this blog

Class IX th :IT(INFORMATION TECHNOLOGY)-402

-
 Class IX PART A: Employability Skills Unit 1: Communication Skills SESSION 1: Communication Cycle Exercise 1 1. List the main components of communication process. The main components or elements of communication process are sender, message, encoding, communication channel, receiver, decoding and feedback. 2. Who is responsible for the encoding of the message? Encoding of the message is done by the sender before sending it to the receivers. 3. Who is responsible for decoding the message? Decoding of the message is done by the receiver after receiving the message. 4. List 3 scenarios of technology based communication? Three scenarios of technology communication are conversation over telephone, online chat and video conferencing. 5. What do you mean by the channel of communication? Give some examples. The medium of communication is called communication channel such as oral, written, technology based. Exercise 2 1. Describe a scenario where all the major factors of effective commun...
Read more

ICT-SKILLS Notes for Class 9

-
Ch-3 (ICT-SKILLS)    What is Computer System? A Computer is an electronic machine that takes input from user, process the data and gives the desired result (output). It performs both mathematical and non-mathematical operations. Computer can be classified into two categories. 1. Hardware: Any physically components that we can touch, feel,& view are called hardware. Ex- Monitor, Printer, Motherboard, RAM, SSD, Pen drive, Mouse,etc. 2. Software : A Software is a set of programs or instructions that tells the computer what to do. Ex: MS-Word, Excel, PowerPoint, Scratch, etc. Software are two types: System Software: It is a type of program that is designed and managed to all hardware devices'- Operating System(Windows, 7,10,11) Application Software: It is a type of software designed to help users perform specific task. Ex: MS-Word, MS-Excel, Photoshop, CorelDRAW. Hardware categories four types   1. Input Device: Input devices are the devices that are used to enter dat...
Read more

Entrepreneur Skills Notes for Class 9 Students

-
  Business: Business is an organized effort to provide goods and services to consumers in exchange for profit, while managing risks and contributing to economic growth.  Business ownership : It is the legal right and responsibility of an individual or group to operate a business, make decisions, and bear its profit or losses.  Types of Business Ownership  Sole Proprietorship: A Sole Proprietorship is a business owned and managed by a single person, who bears all profits, losses, and risks.   Ex: A local grocery shop, Freelance tutor or private teacher Partnership: A partnership is a type of business owned and managed by two or more person, who share the profits, losses , and responsibilities according to a mutual agreement.  Ex- Law Firms, Accounting firms, Small restaurants or retail shops run by multiple people Corporation: A Corporation is a type of business that is a separate legal entity from its owners(shareholder), with limited liability, and ...
Read more