1 / 9

Spreadsheet Basics

Spreadsheet Basics. What is a Spreadsheet ? A spreadsheet (or worksheet) is an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form. A workbook is a file which contains one or more spreadsheets.

kclemens
Télécharger la présentation

Spreadsheet Basics

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. SpreadsheetBasics What is a Spreadsheet? A spreadsheet (or worksheet) is an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form. A workbook is a file which contains one or more spreadsheets.

  2. Spreadsheets Perform Mathematical Calculations Do you or your family use spreadsheets? Daily Uses of Spreadsheets: • Balancing a checkbook • Calculating car loans • Calculating student grades (helping students keep up with their grades) • Household budgets Why would a business use spreadsheets? • Payroll • Financial statements for a business (profit/loss) BA10 1.03

  3. Designing a Spreadsheet Cell – individual locations on a spreadsheet (intersection of a row and column) • Column— identified by letters of the alphabet (vertical) • Column A refers to all of the contents in a vertical range of cells in the first column of the spreadsheet. • Row— identified by numbers (horizontal) • Row 3 refers to all of the contents in a horizontal range of cells on Row 3 COLUMNS (vertical) ROWS (horizontal) BA10 1.03

  4. Cell Specifics Cell Range: • A4:A16 refers to a group of adjacent cells • A Range isa group/block of cells. • example: A6:E16 refers to a range of cells in a specific spreadsheet. Cell Address: a specific location • Cell A4 = Cell address • It is the Column letter and Row number. • The cell address is also called the cell reference. Active cell: • The cell that is selected • It is the cell that is ready to receive information BA10 1.03

  5. Cell Data -- is classified according to its intended purpose. BA10 1.03

  6. 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 BA10 1.03

  7. 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 left side of the cell Values align at the right side of the cell Cell Data Classifications BA10 1.03

  8. 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. BA10 1.03

  9. Data Type Examples Formula Bar Value Formula Labels BA10 1.03

More Related