Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
ELECTRONIC
SPREADSHEET
Prepared by: Ms. Abegail Peseral Calixtro
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
LEARNING OUTCOMES
At the end of this chapter, you will be able to:
• Familiarize the structure and features of an
electronic spreadsheet application
• Utilize formulas, functions, and charts for
analyzing and presenting data
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
HOW SPREADSHEET WORKS ---------------------- SLIDE 4
WHAT IS SPREADSHEET----------------------------- SLIDE 5
SPREADSHEET AT PRESENT ----------------------- SLIDE 10
WHERE CAN SPREADSHEET BE USED ---------- SLIDE 11
HOW SPREADSHEET IS ORGANIZED ------------ SLIDE 13
PARTS OF A WORKSHEET -------------------------- SLIDE 14
PARTS OF MICROSOFT EXCEL --------------------- SLIDE 18
CELLS ------------------------------------------------------ SLIDE 23
RANGES --------------------------------------------------- SLIDE 25
CELL POINTER ------------------------------------------ SLIDE 28
MERGE CELLS ------------------------------------------- SLIDE 29
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
HOW
THE BASICS:
4.1
SPREADSHEET WORKS
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
WHAT IS A
spreadsheet?
The spreadsheet allows users
to create tables and financial
schedules by entering data and
formulas into rows
and columns arranged as a grid
on a display screen.
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
WHAT IS A
spreadsheet?
Traditionally, it was simply a
grid of rows and columns,
printed on special light-green
paper, that was used to
produce financial
projections and reports.
TRADITIONAL SPREADSHEET
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
Daniel Bricklin
● created the first electronic
spreadsheet in 1978, now
called simply a
spreadsheet
● was a student at the
Harvard Business School
● Spreadsheet version called
VisiCalc
VISICALC
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
SPREADSHEETS AT PRESENT
MICROSOFT EXCEL Corel Quattro Pro LOTUS 1-2-3
Developed by Developed by Developed by Lotus
Microsoft Borland and now sold Software
Corporation by Corel
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
Where can
spreadsheets be
used?
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
SPREADSHEETS are used IN
EDUCATION
Maintaining student FINANCE
grade books
Calculating loan
BUSIness payments, creating
other types of
Tracking investments financial report
and budgets, and
estimating project costs
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
HOW A
SPREADSHEET IS
ORGANIZED
A spreadsheet is arranged by columns(letters),
rows(numbers), and labels, and is called a worksheet.
WORKSHEET
Column
Headings
Labels
Row
Headings
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
PARTS OF Worksheet
Column headings
01 In the worksheet’s frame
area (work area), lettered
column headings appear
across the top (“A” is the
name of the first
column, “B” the second,
and so on).
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
PARTS OF Worksheet
ROW headings
02 Numbered row
headings appear
down the left side
(“1”
is the name of the
first row, “2” the
second, and so forth).
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
PARTS OF Worksheet
LABELS
03 Labels are any
descriptive text that
identifies categories,
such as Title, First
Name, Last Name,
etc.
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
PARTS OF microsoft excel
WORKSHEET
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
PARTS OF microsoft excel TITLE BAR
TABS
FORMULA BAR / input bar
ADDRESS BAR /
ACTIVE CELL LOCATION
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
PARTS OF microsoft excel
Active cell / Cell Pointer Fill Handle
a cell which is currently a small dot present on the
selected lower right corner of the
active cell.
Cell – the intersection of a row and a column, where row and column meet.
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
PARTS OF microsoft excel
SHEET TABS:
Let you select a worksheet.
(A spreadsheet file can contain several
worksheets)
STATUS BAR
MENU ANALYSIS
MENU ANALYSIS CONTACT
Each microsoft office worksheet has:
● Microsoft excel consists of workbooks.
● Within each workbook, there is an infinite number of
worksheets.
● Each worksheet contains Columns and Rows.
● Each MS Office worksheet has
● 16,384 columns and 1,048,576 rows
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
Cells: Where
Columns & Rows
Meet
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
Cells & cell
addresses
A cell is the place where a
row and a column
intersect; its position is
called a cell address.
For example, “A1” is the cell address for the top left cell,
where column A and row 1 intersect
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
Ranges
A cell range in an Excel file is
a collection of selected cells.
– for example, A1 to C6.
The notation for this range is (A1:C6)
from upper left cell A1 to bottom right cell C6.
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
IRREGULAR CELL RANGE
Ranges
A cell range in an Excel file is
a collection of selected cells.
– for example, A1 to C6.
The notation for this range is (A1:C6;E2;E6;C7;C9)
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
VALUES
A text, number or date entered
in a cell is called a value.
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
CELL pointer
A cell pointer/active cell, or
spreadsheet cursor, indicates
Active cell / Cell Pointer where data is to be entered. The
a cell which is currently cell pointer can be moved around
selected
like a cursor in a word processing
program.
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
MERGE CELLS
Multiple adjacent cells can be
merged to have one cell
span multiple rows, or multiple
columns. The contents of only
one cell (the upper-left cell)
appear in the merged cell.
Data ANALYSIS
MENU ANALYSIS
MENU ANALYSIS CONTACT
THANK YOU AND
GOD BLESS!
Prepared by: Abegail Peseral Calixtro
