Spreadsheet Skills Introduced in Chapter 2

Skip to main content

\(\newcommand{\Volume}{\mathrm{Volume}} \newcommand{\xLow}{\mathrm{xLow}} \newcommand{\xHigh}{\mathrm{xHigh}} \newcommand{\Mcost}{\operatorname{Marginal Cost}} \newcommand{\cost}{\operatorname{Cost}} \newcommand{\Mrev}{\operatorname{Marginal Revenue}} \newcommand{\revenue}{\operatorname{Revenue}} \newcommand{\profit}{\operatorname{Profit}} \newcommand{\Mprofit}{\operatorname{Marginal Profit}} \newcommand{\Pprofit}{\operatorname{Predicted Profit}} \newcommand{\price}{\operatorname{Price}} \newcommand{\Dprice}{\operatorname{Demand Price}} \newcommand{\Pprice}{\operatorname{Purchase Price}} \newcommand{\Sprice}{\operatorname{Supply Price}} \newcommand{\marginal}{\operatorname{Marginal}\,} \newcommand{\linear}{\operatorname{Linear}\,} \newcommand{\abs}[1]{\left\lvert #1\right\rvert} \newcommand{\quantity}{\mathrm{Quantity}} \newcommand{\AnnualCost}{\operatorname{Annual Cost}} \newcommand{\AnnualExpense}{\operatorname{Annual Expense}} \newcommand{\RepairFactor}{\mathrm{Repair Factor}} \newcommand{\Sales}{\operatorname{Sales}} \newcommand{\prediction}{\operatorname{prediction}} \newcommand{\FutureValue}{\operatorname{Future Value}} \newcommand{\demand}{\operatorname{Demand}} \newcommand{\val}{\operatorname{Value}} \newcommand{\raw}{\mathrm{raw}} \newcommand{\gizmos}{\operatorname{gizmos}} \newcommand{\intermediate}{\mathrm{intermediate}} \newcommand{\tax}{\operatorname{tax}} \newcommand{\FaceValue}{\operatorname{Face Value}} \newcommand{\rate}{\mathrm{rate}} \newcommand{\years}{\mathrm{years}} \newcommand{\expense}{\operatorname{expense}} \newcommand{\FutureAmount}{\operatorname{FutureAmount}} \newcommand{\InitialDeposit}{\mathrm{InitialDeposit}} \newcommand{\ppy}{\mathrm{ppy}} \newcommand{\PresentAmount}{\operatorname{PresentAmount}} \newcommand{\PriceGizmo}{\mathrm{PriceGizmos}} \newcommand{\QuantityGizmo}{\mathrm{QuantityGizmos}} \newcommand{\QuantityGadget}{\mathrm{QuantityGadgets}} \newcommand{\QuantityWidget}{\mathrm{QuantityWidgets}} \newcommand{\PriceWidget}{\mathrm{PriceWidgets}} \newcommand{\PriceGadget}{\mathrm{PriceGadgets}} \newcommand{\QW}{\mathrm{QW}} \newcommand{\QG}{\mathrm{QG}} \newcommand{\PW}{\mathrm{PW}} \newcommand{\PG}{\mathrm{PG}} \newcommand{\Production}{\operatorname{Production}} \newcommand{\Labor}{\mathrm{Labor}} \newcommand{\Capital}{\mathrm{Capital}} \newcommand{\Linear}{\operatorname{Linear}\,} \newcommand{\PriceX}{\mathrm{PriceX}} \newcommand{\PriceY}{\mathrm{PriceY}} \newcommand{\predicted}{\operatorname{predicted}} \newcommand{\Time}{\mathrm{time}} \newcommand{\TotalAmount}{\operatorname{TotalAmount}} \newcommand{\TotalValue}{\operatorname{TotalValue}} \newcommand{\CashAmount}{\mathrm{CashAmount}} \newcommand{\DepositAmount}{\mathrm{DepositAmount}} \newcommand{\AvailableTrees}{\operatorname{AvailableTrees}} \newcommand{\Capacity}{\mathrm{Capacity}} \newcommand{\Amount}{\operatorname{Amount}} \newcommand{\InitialAmount}{\mathrm{InitialAmount}} \newcommand{\InvestmentAmount}{\mathrm{InvestmentAmount}} \newcommand{\Return}{\operatorname{Return}} \newcommand{\SD}{\mathrm{SD}} \newcommand{\Antideriv}{\operatorname{Antideriv}} \newcommand{\MC}{\operatorname{MC}} \newcommand{\MP}{\operatorname{MP}} \newcommand{\MR}{\operatorname{MR}} \newcommand{\CDFf}{\operatorname{CDFf}} \newcommand{\Principal}{\operatorname{Principal}} \newcommand{\ProducerSurplus}{\mathrm{ProducerSurplus}} \newcommand{\ConsumerSurplus}{\mathrm{ConsumerSurplus}} \newcommand{\TotalSocialGain}{\mathrm{TotalSocialGain}} \newcommand{\Elasticity}{\operatorname{Elasticity}} \newcommand{\lt}{<} \newcommand{\gt}{>} \newcommand{\amp}{&} \definecolor{fillinmathshade}{gray}{0.9} \newcommand{\fillinmath}[1]{\mathchoice{\colorbox{fillinmathshade}{$\displaystyle \phantom{\,#1\,}$}}{\colorbox{fillinmathshade}{$\textstyle \phantom{\,#1\,}$}}{\colorbox{fillinmathshade}{$\scriptstyle \phantom{\,#1\,}$}}{\colorbox{fillinmathshade}{$\scriptscriptstyle\phantom{\,#1\,}$}}} \)

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 sqrt
\(e^x\) is EXP(x)
x needs 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 -(A1^2)

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.ROUND and 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.) CEILING and FLOOR round 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.) IF lets you have a formula with cases..

For all these functions Excel and Sheets operate the same.