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. Microsoft Excel is required for this course.

Learning Outcome

Use spreadsheets to solve engineering problems

Chapter Learning Outcomes

1. Create and format spreadsheets for personal budgeting, data tracking, and business reporting.
2. Identify data and variables from complex word problems.
3. Construct logical statements and conditions that accurately represent the problem scenario from a given word problem.
4. Understand and apply Excel’s conditional functions (e.g., IF, COUNTIF, SUMIF) in different contexts.

Extra Resources

If you would like to learn more about Excel, NC State offers a free account with LinkedIn Learning, which hosts a variety of tutorial videos. Once you have set up your LinkedIn Learning account, you can walk through Excel Training such as this one linked and earn a certificate.

Examples of Modern Spreadsheet Programs

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

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