1 / 29

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Chapter 13

• List several applications for spreadsheets

• Explain the underlying principles of electronic spreadsheet use

• Describe how to set up and modify a spreadsheet

• Differentiate between analytical and presentation graphics

• Name the elements of standard charts and graphs

• Analytical Graphics

• Presentation Graphics

• Make the computer do the work

• See the results of change

• Use numbers to track performance

• Manual

• Tedious

• Time-consuming

• Error-prone

• Automate

• Increase ability to track performance

VisiCalc

• 1979

• Apple II microcomputer

• Computer becomes an indispensable tool for financial analysis

Automatic recalculation

• Change one value

• All dependent values are recalculated

• A single change can affect many calculations

“What If” Analysis

The process of changing one or more spreadsheet values and observing the resulting calculated effect

What if we reduce the price by 5%?

What if we buy a home and the mortgage rate increases by .5%?

• Plan

• Create

• Format

• Print

• Provide data security – password, protect

The plan…

…The result

• Enter data and calculations

• Electronic spreadsheet automatically performs the calculations

• Error-free results are displayed on the spreadsheet

• Print

• Store to be used again

• Screen

• Scroll using mouse or cursor-movement keys

• Rows and columns

• Row – number

• Column – letters

• Cell

• Junction of a row and column

• Cell address (cell reference) – letter and number

• Active cell (current cell)

• Highlighted with border or reverse video

• Can enter or edit data in active cell only

• Label

• Not used for calculations

• Value

• Number

• May be used in calculations

Cell ContentsFormula

• Calculation instruction

• Contains

• One or more arithmetic operators

• Functions

• Result appears in the cell containing the formula

• Calculation appears in the formula bar

Cell ContentsFunctions

• Pre-programmed formulas

• Used in formulas in place of operators

• Common

• SUM

• AVERAGE

• COUNT

• MIN

• MAX

• Group of one or more adjacent cells occurring in a rectangular shape

• Treated as a unit during an operation

• Indicate the upper-left and lower-right cells of the block

• May be referenced in a formula or function

• Column width

• Row height

• Number styles – commas, number of decimals, dollar and percent signs

• Appearance of data

• Justification

• Text font and style

• Decoration

• Borders

• Color

• Clip art

• Shows words and numbers in visual form

• Quickly and easily understood

• Generate and sustain the interest of an audience

• Make a lesson, report, or business document more attractive

• Help get a point across

• Can reveal a trend that is lost in a column of numbers

• Presenter appears more prepared and organized

Analytical graphics

View and analyze data

Presentation graphics

Make a positive impression during a presentation

Analytical GraphicsAnalysis-oriented Graphics

Help users analyze and understand data

Line

Bar

Pie

Shows trends or cycles over time

• Axis

• Plot area

• Data point

• Labels

• Titles

• Comparisons

• Rectangular area up to the height of the point being plotted

• Easy to absorb

• Proportions

Relationship between parts and whole

• One time period

• Exploded pie chart

One wedge pulled slightly away from the pie

• Look like preparation by professional graphic artist

• Charts

• Graphs

• Visual aids

• Control the appearance when you create it

• Produce graphics faster

• Make last-minute changes

• Edit and enhance charts created by other programs

• Create charts, diagrams, drawing, and text slides

• Use clip art

• Support animated effects