1 / 11

Spreadsheets

Spreadsheets. Spreadsheets. Software program capable of performing many calculations, functions, graphs Arranged in rows (by number) and columns (letters) Intersection of a row and column is the cell reference , e.g., B4. Basic Calculations. Sum a row or column of numbers

yuri-dean
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

  2. Spreadsheets • Software program capable of performing many calculations, functions, graphs • Arranged in rows (by number) and columns (letters) • Intersection of a row and column is the cell reference, e.g., B4

  3. Basic Calculations • Sum a row or column of numbers • Method 1: use the Auto sum • Method 2: key using formula bar: • Notice the “range” inside the brackets

  4. More Calculations • =E9-E8 Subtract the value in E8 from E9 • =G3*F2 Multiplies G3 by F2 • =K3/C4 Divides K3 by C4 • =AVERAGE(E1:E8) Finds the average value in this range • =MIN(E1:E8) Finds the lowest value in this range • =MAX(E1:E8) Finds the largest value in this range • =COUNT(E1:E8) Reports the quantity of entries in this range

  5. Growth Formulas • Useful to show increase in value • Example 1: =B4+B4*0.05 (fair) • Example 2: =B4*1.05 (better) • Example 3: =B4*$K$1 (best) • Where $K$1 contains % you can change!

  6. Useful Tips

  7. Fill Feature • Create a formula and “drag” lower right corner to apply across or down (click the pic!)

  8. IF Formula • =IF(B9>-1,"Profit","Loss") • Show the word "profit" if the value is zero or higher, otherwise shows the word "Loss"

  9. Absolute Cell Referencing • By default copied or filled formulas reflect related cells • What if we need % of one total? • $ signs in cells signify the cell is constant

  10. Graphing • By default column A is the x-axis and B, C, D, etc. are for values (Y-axes) • Use the graph icon • Name the series to create proper legends • Excel graphs are drab … spice them up!

  11. Graphing • 3D Column Graph • Better!

More Related