Appendix B Spreadsheet Skills Introduced in Chapter 2
The only new spreadsheet skill introduced in Chapter 2 is the use of nonlinear functions.
Spreadsheets let you use Algebraic functions that you have encountered in previous courses 2.3.1. There are a few details to keep in mind:
- Multiplication need to be explicit with
*rather then implicit putting terms and numbers next to each other.
- Exponentiation uses
- Square root uses
- \(e^x\) is
xneeds to be replaced by a cell reference
- In reading
-A1^2, Excel interprets the minus sign as a negation symbol which is evaluated as eponentiation. The normal meaning of \(-x^2\) required parentheses, so
We also introduce Discontinuous functions that are common in business settings 2.3.2. There are a few details to keep in mind:
- Business transactions are generally in whole dollars or cents, so rounding is common.
ROUNDand its variants round to a specified number of digits before or after he decimal place.
- Transactions are often in terms of multiples of a unit size. (Eggs are usually sold in dozens.)
FLOORround up or down to multiples of a given quatity.
- Transactions often have different rules for different sizes. (Overtime hours pay at a different rate than regualr hours.)
IFlets you have a formula with cases..
For all these functions Excel and Sheets operate the same.