1 / 32

Mastering Spreadsheets with Formulas & Functions: A Comprehensive Guide

Learn to identify labels, values, formulas, and functions in spreadsheets. Understand how to perform simple calculations, format numbers, and use relative vs. absolute cell referencing efficiently. Explore the essential parts of a spreadsheet formula and function for effective data manipulation.

shellie-morton
Download Presentation

Mastering Spreadsheets with Formulas & Functions: A Comprehensive Guide

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 A How To!

  2. Identifying Labels and Values labels values

  3. Identifying Formulas and Functions formula The result of the formula function The result of the function

  4. Formula or Function? • =C2+D2+E2 • =AVERAGE(C2:M2) • =E2/B2 • =IF(3A>2A, ‘True’, ‘False’) • =SUM(E4:G4) • =(A2+B2+C2)/3

  5. Identifying Parts of a Spreadsheet Formula mathematical operators =B2+C2+D2 equal sign—first part of any spreadsheet formula cell reference/address—made up of the column heading and the row number

  6. Identifying Parts of a Spreadsheet Function =SUM(B2:B6) name of function range equal sign

  7. What is the active cell?

  8. Simple Calculations - Formula

  9. Simple Calculations - Formula

  10. Simple Calculations - Formula

  11. Simple Calculations - Formula

  12. Simple Calculations - Formula

  13. Simple Calculations - Formula

  14. Simple Calculations - Formula

  15. Simple Calculations - Formula

  16. Simple Calculations – Format Number

  17. Simple Calculations – Format Number

  18. Simple Calculations - Function

  19. Simple Calculations - Function

  20. Simple Calculations - Function

  21. Simple Calculations - Function

  22. Simple Calculations - Function

  23. Simple Calculations - Function

  24. Simple Calculations - Function

  25. How do you calculate this?

  26. How do you calculate this?

  27. Drag and Drop

  28. Drag and Drop

  29. Drag and Drop

  30. Relative and Absolute Referencing • Relative • cells that change when they are copied into other cells • Absolute • cells that do not change regardless of where it is copied

  31. Absolute Cell Reference – F4

  32. Drag and Drop

More Related