[go: up one dir, main page]
Scribd
Upload
148 views18 pages

Notes

The document discusses the history and components of electronic spreadsheets. It notes that the first electronic spreadsheet, VisiCalc, was created in 1979 and was the "killer app" that drove consumers to buy computers. It summarizes key parts of a spreadsheet including worksheets, cells, ranges, functions, and describes advantages like instant calculations and formatting options and disadvantages like lack of control and difficulties with collaboration.

Uploaded by

Leah Pernala de Leon
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
148 views18 pages

Notes

The document discusses the history and components of electronic spreadsheets. It notes that the first electronic spreadsheet, VisiCalc, was created in 1979 and was the "killer app" that drove consumers to buy computers. It summarizes key parts of a spreadsheet including worksheets, cells, ranges, functions, and describes advantages like instant calculations and formatting options and disadvantages like lack of control and difficulties with collaboration.

Uploaded by

Leah Pernala de Leon
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/ 18

 An application you use to perform numeric calculations

and to analyze and present numeric data.



We will be working with Excel, but there are other
programs such as Quatro-Pro.
History of Spreadsheet
1979
The first electronic spreadsheet called VisiCalc was
released on Apple II computers. It was called a
killer application (commonly shortened to killer
app). The killer app is the application that is so
necessary or desirable that consumers would buy
the hardware just to run that application. VisiCalc is
often considered the application that turned the
microcomputer from a hobby for computer
enthusiasts into a serious business tool.
It was limited to 255 rows and 63 columns.
Inventor / Developer of First Electronic Spreadsheet
Spreadsheets have been used by
accountants for hundreds of years.
Computerized or electronic
spreadsheets are of much more recent
origin. Information Systems oral history
and some published newspaper and
magazine stories celebrate Dan Bricklin
as the "father" of the electronic
spreadsheet. In 1978, Harvard Business
School student, Daniel Bricklin, came
up with the idea for an interactive
visible calculator). Bricklin and Bob
Frankston then co-invented or co-
created the software program VisiCalc.
We can look back and recognize that
VisiCalc was the first "killer" application
for personal computers
 The electronic spreadsheet you work in , A worksheet,
in the word's original meaning, is a sheet of paper on
which one performs work..
 This is the file that the worksheet is contained in.
 Displays the active cell address.

Name
Box
 Allows you to enter or edit data in the worksheet.

Formula
Bar
 Are labeled alphabetically and can contain a total
of 16,384 columns

Columns
 Labeled numerically and can contain a total of
1,048, 576rows

Row
 The intersection of a column and a row; can
contain text, numbers, formulas, or a combination
of all three

Cell
 The cell in which you are working. The cell is
outlined.

Active
Cell
 Are locatedbelow the worksheet grid and let you switch from sheet
to sheet in a workbook. By default, workbook file contains three
worksheets, but you can have as many as 255.

Sheet
Tab
 use these to move around in a document that is
too large to fit on the screen at once.

Scroll
Bars
 selection of two or more cells such as B5:B14; you select a range
when you want to perform an action on a group of cells at once,
such as moving them or formatting them

Range
 A built-in formula; includes the arguments as well
as cell references and other unique information

Function
Advantages of Electronic Spreadsheet
• Instant Calculations
• Improved Data Presentation
• Compatibility
• Editing
• Formulas
• Preset Functions/Formulas
Disadvantages of Electronic Spreadsheet
• LACK OF CONTROL OR PERFORMANCE ISSUE
• EXCEL IS VULNERABLE TO FRAUD/CORRUPTION
• EXCEL IS DIFFICULT TO TROUBLESHOOT OR TEST
• EXCEL IS UNFIT FOR AGILE BUSINESS PRACTICES
• EXCEL IS NOT DESIGNED FOR COLLABORATIVE
WORK

You might also like