IT03 IT03

Calculations and ChartsCalculations and Charts

4 4 Introducing SpreadsheetsIntroducing Spreadsheets

In this chapter, let’s get familiar with:

I. Spreadsheet Basics

II. Using an Electronic Spreadsheet Program

3

I.I. Spreadsheet BasicsSpreadsheet BasicsSpreadsheets can present numerical data Spreadsheets can present numerical data systematicallysystematically

4

Organizes numerical data

Contains row and columns

Has cells to store data

Organizing data in a spreadsheetOrganizing data in a spreadsheet

Column

Row Cell

I.I. Spreadsheet BasicsSpreadsheet Basics

5

Spreadsheet Vs Electronic SpreadsheetSpreadsheet Vs Electronic SpreadsheetSpreadsheet Vs Electronic SpreadsheetSpreadsheet Vs Electronic Spreadsheet

An electronic spreadsheet can organize and calculate the numerical data more effectively!

An electronic spreadsheet can organize and calculate the numerical data more effectively!

6

Getting to know the ExcelExcel worksheet

Status Status barbar

Formula barFormula bar

Row headingRow headingColumColum

n n headinheadin

gg

CellCell

active active cellcell

II.Using an Electronic Spreadsheet ProgramII.Using an Electronic Spreadsheet Program

7

Electronic Spreadsheet

Row are identified by numberColumns are identified by lettersEach cell is identified by the column and

row in which it is located

8

Electronic Spreadsheet

Useful tool for organizing and calculating numerical data

We can just amend the wrong data. All the relevant values will be automatically updated.

We can add charts automatically

EndEnd

2000 Digital Vision Educational Publishing