1 / 4

Spreadsheet Basics Objective 4.01

Spreadsheet Basics Objective 4.01. 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.

bono
Download Presentation

Spreadsheet Basics Objective 4.01

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. SpreadsheetBasicsObjective 4.01 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)

  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)

  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

More Related