Scribd
Upload
12 views

Grade9 Excel EM

The document discusses electronic spreadsheets and the Ms Excel software. It describes the interface of Ms Excel including columns, rows, cells, and cell ranges. It also covers common tools, text formatting, alignment and positioning tools, number formatting, data types, formulas and functions like SUM, AVERAGE, MAX, MIN, and COUNT in Ms Excel. The document explains how to input charts in spreadsheets.

Uploaded by

Rashmi Ranaweera
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
12 views

Grade9 Excel EM

The document discusses electronic spreadsheets and the Ms Excel software. It describes the interface of Ms Excel including columns, rows, cells, and cell ranges. It also covers common tools, text formatting, alignment and positioning tools, number formatting, data types, formulas and functions like SUM, AVERAGE, MAX, MIN, and COUNT in Ms Excel. The document explains how to input charts in spreadsheets.

Uploaded by

Rashmi Ranaweera
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 8

Ms Excel Grade 09

2nd Unit

Electronic Spreadsheets
A spreadsheet
 A spreadsheet (or spreadsheet program) is software that permits numerical
data to be used and to perform automatic calculations on numbers
contained in a table.
 It is an application software.

Examples for Spreadsheets Softwares

 Let's open the Ms Excel Software.


Click on start menu Point to all programs Point to Microsoft Excel Click on
Microsoft Excel
or

1|Page
Ms Excel Grade 09

Special Features of Ms Excel Software-:


 Coloumns-There are columns that started from letter A
 Rows- The rows are started at the number one.
 Cell- The active square can be identified as the cell.
 Cell Range- A cell range in Ms Excel is a collection of chosen cells.
 Name Bar- The Name Box refers to an input box directly to the left of the
formula bar.

Interface of Ms Excel

2|Page
Ms Excel Grade 09

Common Tools in Excel

Text formatting Tools in Excel

3|Page
Ms Excel Grade 09

Alighnment and Positioning tools

Number Formatting Tools

Data Types

4|Page
Ms Excel Grade 09

Symbols for formulas


Formulars and Symbols

5|Page
Ms Excel Grade 09

Functions
When there is a large quantity of data it becomes a difficult and complex task to
write formulae using only the cell addresses. In this kind of situation functions are
used. The spreadsheet applications contain different functions to meet the
requirements of different fields.

SUM MAX

AVERAGE MIN

6|Page
Ms Excel Grade 09

COUNT

COUNTA

Data Sorting

7|Page
Ms Excel Grade 09

Charts
When data are presented in the
form of charts they become an
effective tool to communicate.
Because it is an easiest way to
comprehend, compare, analyze and
present data.

Let's input charts to the spreadsheets

8|Page

You might also like