1 / 6

E Q: What formatting options are used in spreadsheets and why?

E Q: What formatting options are used in spreadsheets and why?. Do This: 1) Log In 2) Pull Out SS Note Sheet Table. 1 – What is a SPREADSHEET? 2 – Do you or your family use spreadsheets at work or at home? If so, For what purpose? 3 – Why do businesses use spreadsheets?

nau
Download Presentation

E Q: What formatting options are used in spreadsheets and why?

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. EQ: What formatting options are used in spreadsheets and why? Do This: 1) Log In 2) Pull Out SS Note Sheet Table 1 – What is a SPREADSHEET? 2 – Do you or your family use spreadsheets at work or at home? If so, For what purpose? 3 – Why do businesses use spreadsheets? 4 – What does a spreadsheet look like? 5 – How do spreadsheets work?

  2. Spreadsheet BasicsObjective 4.01 What is a Spreadsheet? A spreadsheet (or worksheet) is an arrangement of cells in columnsandrowsused to organize, analyze, calculate, and report information, usually in numerical form. A workbook is a file which contains one or more spreadsheets. EQ: What formatting options are used in spreadsheets and why?

  3. 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 do businesses use spreadsheets? • Payroll • Financial statements for a business (profit/loss) EQ: What formatting options are used in spreadsheets and why?

  4. 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 verticalrange of cells in the first column of the spreadsheet. Row— identified by numbers (horizontal) • Row 3 refers to all of the contents in ahorizontalrange of cells on Row 3 COLUMNS (vertical) ROWS(horizontal) EQ: What formatting options are used in spreadsheets and why?

  5. Cell Specifics 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 Cell Range: • A1:D12 refers to a group of adjacent cells • ARangeisa group/block of cells. • example: C6:H18 refers to a range of cells in a specific spreadsheet. EQ: What formatting options are used in spreadsheets and why?

  6. Cell Specifics Cell Address A1 Active Cell A1 Cell Range A1:D12 EQ: What formatting options are used in spreadsheets and why?

More Related