Class 9th Unit-4 Electronic Spreadsheet

 

Unit-4 Electronic Spreadsheet

Spreadsheet

1. .    .  Spreadsheet application is tool which is used to perform all kinds of calculations easily and accurately.
2.     Spreadsheet is a long sheet of rows and columns on the computer screen to do data analysis and calculation.
3.      It is used for managing financial and accounting documents, creating data reports, generating invoices.

Features of Spreadsheet

1. •         Simple mathematical calculations
2. •         Complex calculations using formula and functions
3. •         Arranging data in ascending and descending order (sorting)
4. •         Filtering the required data
5. •         Check the validity of data
6. •         Protection of data using passwords
7. •         Saving for future use

Worksheet:

 The worksheet in Calc is also referred to as spreadsheet. The spreadsheet can have many sheets. Each sheet can have many individual cells arranged in rows and columns. The sheet tab shows its default 3 sheet in workbook,  name as Sheet1, Sheet2, Sheet3, …

Rows and columns:

The sheet is divided into vertical columns and horizontal rows. Each sheet can have a maximum of 1,048,576 (2²⁰) rows and 1024 (2¹⁰) columns. The rows are numbered as 1,2,3,4,… and columns are numbered as A, B, C, D, …., Z, AA, AB, AC, …., AZ, BA to BZ, CA,…., AMJ.

Cell:-

The intersection of a row and column is called a cell. It is the basic element of a spreadsheet. It holds data, such as text, numbers, formulas and so on.

Cell address:

A cell address is denoted by its column (letter) and row number. For example, D4, E9, Z89 are the valid example of cell address.

Active cell:

This selected or activated cell is called as active cell. It is always highlighted, with a thick border. The address of the active cell is displayed in the name box.

Interface of spreadsheet:-

Formula in Excel

1.     Sum:-                   =sum(a1:d1)

2.     Subtraction:-       =a1-b1

3.     Multiplication:-   =a2*b1

4.     Division:-             =a1/b1

5.     Maximum:          =max(a1:g1)

6.     Minimu:-             =min(a1:e3)

7.     Average:-             =average(a1:d1)

Referencing

Referencing is the way to refer the formula or function from one cell to the next cell along the row or column. There are three types of referencing.

1.     Relative referencing

2.     Mixed referencing

3.     Absolute referencing

Relative Referencing

 When you drag any formula in any row or column in any direction, the formula gets copied in the new cell with the relative reference.

Mixed referencing:

When we drag the formula, row number or column name get change in relative reference.

Absolute referencing:

In Absolute referencing, a $ symbol is used before the column name as well as row number to make it constant in any formula. For example, $C$12, $D$5, etc. In this case, even if you drag your formula in any direction, the cell name remains constant.

                                                     

 

Chart

A chart is a graphical representation of worksheet data. Charts can make data interesting, attractive and easy to read and evaluate. They can also help you to analyze and compare data.

1.     Column Chart :-

    Data that’s arranged in columns or rows on a worksheet can be plotted in              a column chart.

 

 

2.     Bar Chart :-    

  Data that's arranged in columns or rows on a worksheet can be plotted in a bar chart.

 

3.     Line Chart :-    

 Data that's arranged in columns or rows on a worksheet can be plotted in a line chart.

 

4.     Pie Chart:-      

  Pie charts show the size of items in one data series, proportional to the sum of the items. 

 

5.     XY Scatter:-     

Chart Comparing data in pairs It combines x and y values into single data points and shows them in irregular intervals, or clusters. Scatter charts are typically used for showing and comparing numeric values, like scientific, statistical, and engineering data