Business Calculus with Excel

The easist contruction is to build a table where the value of $q$ increases by 1 3.1.4 from one row to the next. Since $Mf(q+1)=f(q+1)-f(q)\text{,}$ we simply subtract values in successive rows 3.1.5. Screencast of eaxmaple using this approach. 3.1.3

The next easist contruction is to build a table computing $f(q+1)$ and $f(q)$ as separate columns with the cell reference replaced by the reference plus 1 3.1.13. Since $Mf(q+1)=f(q+1)-f(q)\text{,}$ we simply subtract values in successive columns. Screencast of eaxmaple using this approach. 3.1.3

In practice, students often make formula mistakes when using this approach.

The preferred construction builds a template that is easy to reuse. We set up successive colummes for , q, q+1, f(q) and f(q+1) 3.1.14. I then only have the enter the formula for the function one, under f(q). Quick fill then provides the correct formula for f(q+1). Screencast of eaxmaple using this approach. 3.1.12 The approach starts at the 3 minute markIn practice, students often make formula mistakes when using this approach.