1 / 11

Understanding Spreadsheets

Understanding Spreadsheets. Cell Data Formulas Operations. Cell Data -- is classified according to its intended purpose. Labels — the classification used for cells that contain text or for numbers that will not be used in calculations

edna
Download Presentation

Understanding 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. Understanding Spreadsheets Cell Data Formulas Operations

  2. Cell Data --is classified according to its intended purpose.

  3. Labels— the classification used for cells that contain text or for numbers that will not be used in calculations Examples: John Jones (text) Dates, such as 1/03/2009 (considered as text) Social Security # Phone # ZIP Code (a number, but will not be calculated) Using an apostrophe ‘ Type an apostrophe (‘) before a number to make that entry recognized as a label (the ‘ does not show when you press enter). Example: ‘27613 (Put ‘ so the ZIP Code is recognized as a label or text, not a value, by the computer) Cell Data Classifications

  4. Values— the classification indicating that the data has the potential to be used in calculations Example: 150 Cell Alignment for these classifications: Labels align at the leftside of the cell Values align at the rightside of the cell Cell Data Classifications

  5. Data Types Examples Formula Bar Value Formula Label

  6. Basic Spreadsheet Formulas Formulasinstruct the software to perform a calculation. All Formulas begin with an equal sign = When the equal sign is keyed in a cell, the software “knows” that the data will be used in a calculation.

  7. Basic Spreadsheet Formulas Formulas use the following: • Addition • Division • Multiplication • Subtraction These MathOperatorsare used in formulas (performing Math Operations): + for Addition- for Subtraction *for Multiplication/for Division

  8. Basic Spreadsheet Formulas Examples of basic formulas: if using Cells B7 and C7: Addition =B7+C7 Subtraction=B7-C7 Multiplication=B7*C7 Division=B7/C7

  9. Order of Operations Calculationsare performed according to the Order of Operations. (which means, they calculate in a specific order) To remember the Order Of Operations: remember PEMDAS—Please Excuse My Dear Aunt Sally Pparenthesesperforms operations on the items enclosed in (parentheses) first Eexponentiation ^ Mmultiplication * (from left to right) Ddivision / Aaddition + (from left to right) Ssubtraction -

  10. Order of Operation Example =(A8+C9)/(H8-L9) The parentheses around the first part of the formula force Excel to calculate (A8+C9) first. then calculate (H8-L9), then divide the 2 results. A8 = 10 C9 = 2 H8 = 7 L9 = 1 =(10+2)/(7-1) =12/6 =2 SOLVE!!

  11. You can see this screen containing formulas by holding the Ctrl key and tapping the ` (tilde/accent) key. Repeat Ctrl + `to return to the normal Excel screen view.

More Related