Spreadsheet Package

An Introduction to Electronic Spreadsheets which consist of multiples of rows and columns based on this model of square ruled books.

1. ELECTRONIC SPREADSHEET
Sanjaya Dharmadasa
B.Tech(Multimedia and Web Technology)

2. We usually use a square ruled book to perform systematic
calculations. Every page in this book consists of pages with
rows and columns. Electronic Spreadsheets which consist of
multiples of rows and columns based on this model of square
ruled books.
Introduction
Electronic Spreadsheet

3. Using
Electronic
Spreadsheets
Simple and
complex
calculations
Presentation
of data in
charts
Show data in
ascending
and descending
order
Segregate
only the
required data
Check the va
lidity of data
Protection of
data using
passwords

4. Electronic Spreadsheet Application Software
Software Company
Excel Microsoft Corporation
Numbers Apple Inc
LibreofficeCalc The Document Foundation
OpenofficeCalc Apache Foundation

5. Microsoft Excel 2010

6. LibreOfficeCalc

7. Worksheet
A worksheet is made up of a multitude of cells made by
columns and Rows on a two dimensional plane.
Worksheet
Application
Number of
rows
Number of
columns
Microsoft Excel 2003 65536 (2
16
) 256 (2
8
)
Microsoft Excel 2007 / 20101048576 (2
20
) 16384 (2
14
)
LibreOfficeCalc4.1 1048576 (2
20
) 1024 (2
10
)

8. Key/combination of
keys
Result
Arrow keys Move a single cell in any direction (left, right, up, down)
Ctrl + Arrow Keys
Moves the cell to the end of the data range in a particular
direction
Home
Moves to column A along the row where the active
cell is
Ctrl + Home Moves the cell to A1 position
Ctrl + End Moves to bottom right cell of the data range
Page Up Moves the worksheet one screen up
Page Down Moves the worksheet one screen down
Shortcut Keys

9. Positions of rowsand columnsin a worksheet

10. Active Cell
•B3 is the active cell in the
worksheet below.
•An active cell always has a
thick border.
Cell Address
•The address of the active cell
is displayed in the name box.
•A cell at D column and 3
rd
row would be named D3.

11. EnteringData
1. Label
A combination of letters, numbers, special symbols or the text entered using a keyboard
are called labels. By default the labels are left aligned.

12. EnteringData
2. Values
The data with numerical figure are called values. By default value is right aligned.

13. EnteringData
3. Formula
Theexpressionsbeginningwithanequals‘=’markusingvalues,celladdressand
functionsarecalledaformula.Whenaformulaisenteredinacellinaworksheetthe
valueoftheequationisdisplayedinthecellandtheformulaisshownintheformulabar.

14. Mathematicaloperatorsused in formulae
Operator
+ addition
- subtraction
* multiplication
/ division
^ exponentiation (power)

15. Mathematicaloperatorsused in formulae
Operator
precedence
First ()
Second ^
Third * , /
Fourth + , - reduce top to bottom.

16. Simple calculationsusing values and operators

17. Formulas with cell addresses and operators
The perimeter and area of a rectangle
The incorrect way of writing
the formula
The correct way of writing the
formula

18. Use of functions to do calculations

19. Formatting Tools in Microsoft Excel 2010
Formatting tool bar in LibreOfficeCalc
Formatting the worksheet

20. Relative and absolute cell reference
Aclassteachertocalculatesthetotalandaverageofeachstudent
aftertheexaminationsofaterm.However,usinganelectronic
spreadsheetwouldmakethistaskefficient.Thisisbecauseonecan
copytheformulaeonceapplyittomanyotherinstances.
Copying
a
formula

21. Creation ofcharts using spreadsheets
It is not easy to comprehend, compare, analyze or present data
when they are represented as numbers. But when data are
presented in the form of charts they become an effective tool to
communicate.

23. Thank you