Spreadsheets

This chapter will cover the use of spreadsheets, a way of arranging the data into rows and columns that can be edited using specific functions and formulas for analysis. After the data has been entered, and the necessary functions and formulas have been performed, the data can be displayed graphically.

Examples of Modern Spreadsheet Programs

  • Microsoft Excel (required for this course)
  • Libre Office Calc
  • Google Sheets
  • Apple Numbers
  • Gnumeric

Learning Outcomes

  • Be confident, capable, and competent in your use of Microsoft Excel in everyday and business applications
  • Distill logical operations from word problems
  • Evaluate the results of various logical operations
  • Explain the difference and be able to utilize both formulas and functions
  • Demonstrate capability of determining the output of conditional logic functions

This is a blank Microsoft Excel 2013 spreadsheet with menu bars: