Spreadsheet Basics What is a Spreadsheet A spreadsheet
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.
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) BA 10 1. 03 2
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) A ROWS (horizontal) B C D 1 2 CELL 3 BA 10 1. 03 3
Cell Specifics Cell Range: • A 4: A 16 refers to a group of adjacent cells • A Range is a group/block of cells. • example: A 6: E 16 refers to a range of cells in a specific spreadsheet. Cell Address: a specific location • Cell A 4 = 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 BA 10 1. 03 4
Cell Data -- is classified according to its intended purpose. BA 10 1. 03 5
Cell Data Classifications • 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) BA 10 1. 03 6
Cell Data Classifications 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 BA 10 1. 03 7
Basic Spreadsheet Formulas instruct 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. BA 10 1. 03 8
Data Type Examples Formula Bar Value Label s Formula BA 10 1. 03 9
- Slides: 9