1 / 35

PowerPoint Presentation to Accompany GO! with Microsoft ® Office 2007 Introductory Chapter 9

PowerPoint Presentation to Accompany GO! with Microsoft ® Office 2007 Introductory Chapter 9 Creating a Worksheet and Charting Data. Objectives. Create, Save, and Navigate in an Excel Workbook Enter and Edit Data in a Worksheet

calder
Download Presentation

PowerPoint Presentation to Accompany GO! with Microsoft ® Office 2007 Introductory Chapter 9

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. PowerPoint Presentation to Accompany GO! with Microsoft® Office 2007 Introductory Chapter 9 Creating a Worksheet and Charting Data

  2. Objectives • Create, Save, and Navigate in an Excel Workbook • Enter and Edit Data in a Worksheet • Construct and Copy Formulas, Use the Sum Function, and Edit Cells • Format Data, Cells, and Worksheets

  3. Objectives • Chart Data • Use Page Layout View, Prepare a Worksheet for Printing, and Close Excel • Design a Worksheet

  4. Objectives • Construct Formulas for Mathematical Operations • Format Percentages and Move Formulas • Create a Pie Chart and a Chart Sheet • Use the Excel Help System

  5. Create, Save, and Navigate an Excel Workbook • A workbook contains one or more pages called worksheets. • A worksheet is a grid of vertical columns and horizontal rows. • The intersection of a column and a row is called a cell. • A worksheet is always stored in a workbook.

  6. Create, Save, and Navigate an Excel Workbook

  7. Create, Save, and Navigate an Excel Workbook

  8. Enter and Edit Data in a Worksheet • Cell content can be one of two things: • A value, which can be numbers, text, dates, or times of day typed into a cell • A formula, which is an equation that performs mathematical calculations on values in the worksheet • Cell contents can be editedor cleared. • Changes will propagate to formulas that used those cells

  9. Enter and Edit Data in a Worksheet

  10. Enter and Edit Data in a Worksheet • AutoCompletespeeds typing by completing entries in a cell, if the first few characters match an existing entry in the column. • Auto Fill generates a series of values into adjacent cells, based on the value of the other cells—use lower right corner of cell • AutoCorrect automatically corrects and formats some text as it is typed.

  11. Enter and Edit Data in a Worksheet

  12. Construct and Copy Formulas, Use the Sum Function, and Edit Cells • Excel automatically recalculates formulas, when changes are made. • Excel provides prewritten formulas called functions, which perform calculations. • Example: • Maximum, Minimum, Average, Sum… • Categorized into: Math, Financial, Statistical …

  13. Construct and Copy Formulas, Use the Sum Function, and Edit Cells

  14. Format Data, Cells, and Worksheets

  15. Format Data, Cells, and Worksheets

  16. Format Data, Cells, and Worksheets

  17. Chart Data • A chart creates a visual representation of the data. • Common chart types include: • Column • Pie • Line

  18. Chart Data

  19. Chart Data

  20. Chart Data • Each cell is a data point. • Each data point is shown in the chart by a data marker: A data marker can be a column, bar, area, dot, pie slice, or other symbol. • Related data points form a data series. For example, a data series for January, February, and March.

  21. Chart Data

  22. Chart Data

  23. Use Page Layout View, Prepare a Worksheet for Printing, and Close Excel • Page Layout View prepares your data for printing. • Rulers measure data, set margins, hide or display row and column headings, and change the page orientation. • Headers or footersprint at the top (header) or bottom (footer) of every page of a worksheet. • Page Layout View shows you how the data and/or chart will appear when printed.

  24. Use Page Layout View, Prepare a Worksheet for Printing, and Close Excel

  25. Use Page Layout View, Prepare a Worksheet for Printing, and Close Excel

  26. Use Page Layout View, Prepare a Worksheet for Printing, and Close Excel

  27. Design a Worksheet • Good design techniques can be instrumental in making your worksheet useful. • To be most effective: • Use rows rather than columns for the most abundant data. • Consider how it will appear on flat paper. • Arrange the data so that it is easily charted.

  28. Construct Formulas for Mathematical Operations

  29. Construct Formulas for Mathematical Operations • Relative cell references: • refer to cells by their position in relation to the cell containing the formula • adjust when a formula is copied • Absolute cell references: • refer to cells by their fixed position in the worksheet • make no adjustments

  30. Format Percentages and Move Formulas

  31. Create a Pie Chart and a Chart Sheet

  32. Use the Excel Help System • The Help system provides information about Excel’s features. • The Help system displays step-by-step instructions for performing many tasks.

  33. Covered Objectives • Create, Save, and Navigate in an Excel Workbook • Enter and Edit Data in a Worksheet • Construct and Copy Formulas, Use the Sum Function, and Edit Cells • Format Data, Cells, and Worksheets

  34. Covered Objectives • Close and Reopen a Workbook • Chart Data • Use Page Layout View, Prepare a Worksheet for Printing, and Close Excel • Design a Worksheet

  35. Covered Objectives • Construct Formulas for Mathematical Operations • Format Percentages and Move Formulas • Create a Pie Chart and a Chart Sheet • Use the Excel Help System

More Related