Spreadsheets and Business Graphics: Facts and Figures - PowerPoint PPT Presentation

Spreadsheets and business graphics facts and figures l.jpg
Download
1 / 29

Spreadsheets and Business Graphics: Facts and Figures Chapter 13 Objectives Describe the advantages of spreadsheets List several applications for spreadsheets Explain the underlying principles of electronic spreadsheet use Describe how to set up and modify a spreadsheet

Related searches for Spreadsheets and Business Graphics: Facts and Figures

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

Download Presentation

Spreadsheets and Business Graphics: Facts and Figures

An Image/Link below is provided (as is) to download presentation

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


Spreadsheets and business graphics facts and figures l.jpg

SpreadsheetsandBusiness Graphics:Facts and Figures

Chapter 13


Objectives l.jpg

Objectives

  • Describe the advantages of spreadsheets

  • List several applications for spreadsheets

  • Explain the underlying principles of electronic spreadsheet use

  • Describe how to set up and modify a spreadsheet

  • Describe the advantages of business graphics

  • Differentiate between analytical and presentation graphics

  • Name the elements of standard charts and graphs


Contents l.jpg

Contents

  • Why Use Spreadsheets?

  • Working with Spreadsheets

  • Business Graphics

  • Analytical Graphics

  • Presentation Graphics


Why use spreadsheets l.jpg

Why Use Spreadsheets?

  • Plan ahead (What if)

  • Make the computer do the work

  • See the results of change


The nature of spreadsheets l.jpg

The Nature of Spreadsheets

  • Use numbers to track performance

  • Manual

    • Tedious

    • Time-consuming

    • Error-prone

  • Electronic spreadsheets

    • Automate

    • Increase ability to track performance


Electronic spreadsheets l.jpg

Electronic Spreadsheets

VisiCalc

  • First electronic spreadsheet program

  • 1979

  • Apple II microcomputer

  • Computer becomes an indispensable tool for financial analysis


Electronic spreadsheets labor saving l.jpg

Electronic SpreadsheetsLabor Saving

Automatic recalculation

  • Change one value

  • All dependent values are recalculated

  • A single change can affect many calculations


Electronic spreadsheets labor saving8 l.jpg

Electronic SpreadsheetsLabor Saving

“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%?


Working with spreadsheets l.jpg

Working with Spreadsheets

  • Plan

  • Create

  • Edit and proofread

  • Format

  • Print

  • Add graphics

  • Provide data security – password, protect


Working with spreadsheets10 l.jpg

Working with Spreadsheets

The plan…

…The result


Electronic spreadsheets how it works l.jpg

Electronic SpreadsheetsHow it Works

  • Enter data and calculations

  • Electronic spreadsheet automatically performs the calculations

  • Error-free results are displayed on the spreadsheet

  • Print

  • Store to be used again


Electronic spreadsheets fundamentals l.jpg

Electronic SpreadsheetsFundamentals

  • Screen

    • Window into the spreadsheet

    • Scroll using mouse or cursor-movement keys

  • Rows and columns

    • Row – number

    • Column – letters


Electronic spreadsheets fundamentals13 l.jpg

Electronic SpreadsheetsFundamentals

  • 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


Cell contents l.jpg

Cell Contents

  • Label

    • Descriptive text about entries

    • Not used for calculations

  • Value

    • Number

    • May be used in calculations


Cell contents formula l.jpg

Cell ContentsFormula

  • Calculation instruction

  • Contains

    • Cell address

    • One or more arithmetic operators

    • Functions

  • Result appears in the cell containing the formula

  • Calculation appears in the formula bar


Cell contents functions l.jpg

Cell ContentsFunctions

  • Pre-programmed formulas

  • Used in formulas in place of operators

  • Common

    • SUM

    • AVERAGE

    • COUNT

    • MIN

    • MAX


Cell ranges l.jpg

Cell Ranges

  • 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


Formatting features l.jpg

Formatting Features

  • Column width

  • Row height

  • Headings

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

  • Appearance of data

    • Justification

    • Text font and style


Formatting features19 l.jpg

Formatting Features

  • Decoration

    • Borders

    • Color

    • Clip art

  • Business graphics

    • Shows words and numbers in visual form

    • Quickly and easily understood


Business graphics l.jpg

Business Graphics

  • 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


Business graphics21 l.jpg

Business Graphics

Analytical graphics

View and analyze data

Presentation graphics

Make a positive impression during a presentation


Analytical graphics analysis oriented graphics l.jpg

Analytical GraphicsAnalysis-oriented Graphics

Help users analyze and understand data

Line

Bar

Pie


Line graphs l.jpg

Line Graphs

Shows trends or cycles over time

  • Axis

  • Plot area

  • Data point

  • Labels

  • Titles


Bar graphs l.jpg

Bar Graphs

  • Comparisons

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

  • Easy to absorb


Pie charts l.jpg

Pie Charts

  • Proportions

    Relationship between parts and whole

  • One time period

  • Exploded pie chart

    One wedge pulled slightly away from the pie


Presentation graphics business quality graphics l.jpg

Presentation Graphics Business-quality Graphics

  • 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


Presentation graphics business quality graphics27 l.jpg

Presentation Graphics Business-quality Graphics

  • Edit and enhance charts created by other programs

  • Create charts, diagrams, drawing, and text slides

  • Use clip art

  • Support animated effects

  • Add sounds


Presentation graphics business quality graphics28 l.jpg

Presentation Graphics Business-quality Graphics

Hardware

  • High-resolution color monitor

  • Color printer

  • Ability to project computer slides on a screen


  • Login