1 / 16

Spreadsheets

Spreadsheets. Spreadsheets. Excel for Educators Class Notes A Workshop by Karen Work Richardson karen@wmburgweb.com. Find more Resources for Educators on the Web: http://www.wmburgweb.com/Resources/index.html. Spreadsheet Basics.

zilya
Download Presentation

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. Spreadsheets Spreadsheets Excel for Educators Class Notes A Workshop byKaren Work Richardsonkaren@wmburgweb.com Find more Resources for Educators on the Web: http://www.wmburgweb.com/Resources/index.html

  2. Spreadsheet Basics Words to Know: •Spreadsheet •Column • Row • Cell • Cell Address • Used to organize and analyze information • Made up of columns and rows • Columns and rows intersect to form cells • Column letter plus row number makes cell address

  3. Spreadsheet Basics Words to Know: •Spreadsheet •Column • Row • Cell • Cell Address Column A Column B Column C Row 1 Row 2 Row 3 A7 B4 C10 D5 Cells with addresses

  4. Spreadsheet Basics Words to Know: •Entry Bar •Active Cell • Format • Alignment Entry Bar: Area where the text, number, or formula in the active cell is displayed. Also called the Formula Bar Active Cell: Cell in use, address shown beside formula bar Format: A change in the appearance of a value or label in a cell. In this example, cell A1 is bold. Cell D7 is formatted to display as a percentage. Alignment: The placement of information within a cell at the left edge, right edge, or centered. In this example, the cells in column A are centered. The cells in column B are right aligned.

  5. Spreadsheet Basics Words to Know: •Cell range •Column width Column Heading Cell Range: A continuous group of selected cells. This range includes cells A1 through D10. Row Heading Column Width: Column widths may be varied to display data correctly. Tip: To select an entire column or row, click on the column or row heading.

  6. Contents of a Cell A cell can contain: • A LABEL • A VALUE • A FORMULA

  7. Spreadsheet Formulas • A combination of values or cell references and mathematical operators • Mathematical Operators: + - * / • Formulas begin with an equal sign • The actual formula displays in the entry bar • The results of the formula display in the cell

  8. Spreadsheet Formulas Words to Know: •Formula •Mathematical Operators Formula: Combination of values or cell references and mathematical operators such as +, -, /, * The formula displays in the entry bar. This formula is used to add the values in the four cells. The sum is displayed in cell B7. The results of a formula display in the cell.

  9. Spreadsheet Formulas • Examples of formulas: • Add cells B4, C4, D4, and E4: =B4+C4+D4+E4 • Subtract cell F10 from cell F9: =F9-F10 • Multiply cells A3 and A4: =A3*A4 • Divide cell D5 by cell D6 =D5/D6 Always use cell references instead of values in your formulas! That way, when the values change the formulas gets updated.

  10. Spreadsheet Functions • Functions are built-in shortcuts for making calculations with a range of cells: • Most common is SUM (used to add cells) • AUTOSUM button  adds in one step • AVERAGE function finds the average by adding the numbers and dividing by the number of items • MIN function finds the minimum value in a range • MAX function finds the maximum value in a range

  11. Spreadsheet Functions • Some Sample Functions • Add together cells B3 through B7 • =SUM(B3:B7) • Find the average of cells D4 through D8 • =AVERAGE(D4:D8) • Find the minimum value in the cell range E43:E52 • =MIN(E43:E52) • Find the maximum value in the cell range E43:E52 • =MAX(E43:E52)

  12. AVERAGE Function • There are three ways to find the average of the cell range A1:A5: • =AVERAGE(A1:A5) • =(A1+A2+A3+A4+A5)/5 • =SUM(A1:A5)/5

  13. The MEDIAN Function =MEDIAN(A1:A5) • The MEDIAN average is the number found in the middle of a sorted list: • $40,000$63,000$74,000$85,000$98,000 The median is $74,000 because it is in the middle of the list. $100,000 $110,000 $120,000 $160,000 $220,000 $240,000 The median is $140,000: the mean average of the two center numbers. ($120,000+$160,000)/2=$140,000

  14. Functions In Action The SUM function is used to find the total of cells C3, C4, C5 and C6. The same calculation could be done using a mathematical operator: =C3+C4+C5+C6

  15. Data Selected: B5-C6 Charts

  16. Chart Wizard makes chart creation easy Select data to be displayed Use Ctrl key to select data that isn’t adjacent (ex. A2-A4 AND C3-C5) Chart is linked to worksheet data so it gets updated as data changes Charts

More Related