1 / 20

Spreadsheets

Spreadsheets. Prepared by : Mahmoud A. Abu Hashish 120090276. 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

finn-ayala
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 Prepared by : Mahmoud A. Abu Hashish 120090276

  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. 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

  7. 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.

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

  9. 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

  10. 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)

  11. 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

  12. Data Selected: B5-C6 Charts

  13. 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

  14. Axis Values: created from the worksheet data Category Names: column or row headings Series Names (legend): column or row headings Data Markers: Each data series shares a pattern Chart Parts, Part One

  15. Chart Parts, Part Two • Each part can be formatted for font, style, or color • Can choose to display or not display legend • Chart Wizard previews your selections • Can make a column chart in one step by using default chart option

  16. Data Series • A group of related data points that are plotted in a chart • Originate from rows or columns on a datasheet • Each data series in a chart has a unique color or pattern • You can plot one or more data series in a chart

  17. Data Series Examples This spreadsheet has one data series in a column: Number of candies This spreadsheet has three data series in columns: Bag #1, Bag #2, and Bag #3 OR This spreadsheet has four data series in rows: Blue, Green, Red, Orange.

  18. Data Series to Pie Chart The title comes from this cell. Each of the numbers become a slice of the pie. The legend and labels come from the first column.

  19. Data Series to Bar Chart #1 The same set of data can yield two different bar charts if the data series are in rows or columns.

  20. Conclusion Microsoft Excel is very important for managers and every successful person.

More Related