1 / 26

Spreadsheets

Spreadsheets. Objective 6.01 Demonstrate basic spreadsheet concepts and functions. Designing a Spreadsheet. WHAT IS A SPREADSHEET? Rows and columns of data and formulas Cell - Intersection of a row and column. COLUMNS (vertical). ROWS (horizontal). * CELL ADDRESS = B2.

saniya
Download Presentation

Spreadsheets

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. Spreadsheets Objective 6.01 Demonstrate basic spreadsheet concepts and functions

  2. Designing a Spreadsheet • WHAT IS A SPREADSHEET? • Rows and columns of data and formulas • Cell - Intersection of a row and column COLUMNS (vertical) ROWS (horizontal) * CELL ADDRESS = B2

  3. Spreadsheets Perform Mathematical Calculations Spreadsheet Applications • Budgets • Checkbook • Product prices • Payroll • Financial statements • Profit/loss statements • Company bids

  4. Daily Uses of Spreadsheets Business • Personal/Home • Budget • Checkbook • Car loans • Household Expenses • Payrolls • Budgeting • Investments • Inventory costs • Loan Payments • School • School Budgets • Student Grades • Payrolls

  5. Spreadsheet Input Operations • Keyboard or Menu Commands • Mouse • Arrow keys • Enter • Alternate Input Devices • PDA • Speech Recognition • Tablet PC • Virtual Keyboard

  6. Data Types Labels (left default alignment) Data expressed in words, symbols, dates, or numbers not used in calculations Thomas Jones January 3 Zip code, SS#, telephone number Values (right default alignment) Data expressed in numbers 150 Formulas Algebraic format of formulas =A1+B1, =(C4*D10)+A3 Creating a Spreadsheet

  7. Data Types Value Formula Label

  8. Basic Spreadsheet Formulas • Addition =B7+C7 • Subtraction =B7-C7 • Multiplication =B7*C7 • Division =B7/C7 Formulas are used for simple mathematical calculations

  9. Saving • Using Menu • File, save as • Choose location to save • Name file • Save

  10. Saving • Keyboard Commands • Ctrl S (When using for the first time, computer will prompt location and file name • Speech Commands • Same procedure as using the menu

  11. Printing • Printing Options – (File, Page Setup) • Portrait – paper taller than wide • Landscape – paper wider than tall • With/without gridlines • With/without row and column headings

  12. Printing Options Portrait – page longer than wide Landscape – page wider than long

  13. Printing Options (Continued) With/without gridlines With/without row & column headings

  14. Retrieving/Editing Retrieve spreadsheet file to edit through menu Retrieve using icon

  15. Editing/Insert Row To insert a row between row 2 and 3, active cell must be in row 3 (row below)

  16. Editing/Insert Column To insert a column between column A and B, active cell must be in column B (inserts left of column)

  17. Editing/Deleting Row or Column From menu, select edit, delete or right click mouse and choose delete

  18. Editing/Deleting Row Select entire row to delete row

  19. Editing/Deleting Column Select entire column to delete column

  20. Formatting Cell Features Types of Cell Formatting • General • Number • Currency • Percentage • Text • Comma • Date

  21. Formatting Cell Features Formatfrom the formatting toolbar. OR … Format from the Format Menu Format from Format Menu

  22. Formatting Cell Features

  23. Aligning Data Align Data from the Formatting Toolbar OR …

  24. Aligning Data From the Format Menu

  25. Aligning Data

  26. Aligning Data

More Related