Topics Covered

Formulas and functions

Creating a chart

Trendlines

Solver and least squares fits

Error and statistics

5.1 If-else branches (general)
5.2 If-else
5.3 More if-else
5.4 Equality and relational operators
5.5 Detecting ranges (general)
5.6 Detecting ranges with if-else statements
5.7 Logical operators
5.8 Order of evaluation
5.9 Example: A SimpleCar class
5.10 Example: Toll calculation
5.11 Switch statements
5.12 Boolean data type
5.13 String comparisons
5.14 String access operations
5.15 Character operations
5.16 More string operations
5.17 Conditional expressions
5.18 Floating-point comparison
5.19 Short circuit evaluation
5.20 Java example: Salary calculation with branches
5.21 Java example: Search for name using branches

Interpolation

Integration and numerical integration

Matrices and solving problems of linear equations

What You’ll Find In This zyBook:

More action with less text.

  • A breakthrough primer on using spreadsheets in any discipline
  • More than 40 animations demonstrate simple to advanced functions
  • Over 120 auto-graded questions provide students practice with spreadsheets

Instructors: Interested in evaluating this zyBook for your class? Sign up for a Free Trial and check out the first chapter of any zyBook today!

The zyBooks Approach

Less text doesn’t mean less learning.

This zyBook provides an exceptionally-interactive introduction to Spreadsheets, with numerous embedded learning questions, animations, and auto-graded exercises. Unlike many books on the topic, this material emphasizes high-level skills, like applying concepts and analyzing systems, that are crucial for students to succeed in science, engineering, and related disciplines. This material does so through matching and multiple choice questions that apply definitions and demonstrate the utility of a spreadsheet. Spreadsheets are common across platforms, devices, operating systems, etc., so this material was created to provide a general overview of skills that translate across Microsoft Excel, Google Sheets, Apple Numbers, and other spreadsheet programs.

As with other zyBooks, a key benefit of such interactivity is that students learn more, and come to class more engaged when points are given for completing the interactive activities beforehand. Instructors can quickly see which activities have been completed by students.

Authors

Matthew Liberatore
Professor of Chemical Engineering, University of Toledo

Combine Spreadsheets Essentials With These Other zyBooks

Spreadsheets Essentials is often combined with other zyBooks to give students experience with a diverse set of programming languages. Some popular titles to pair with Spreadsheets Essentials include: