Skip to main content

Business Calculus with Excel

Section A.1 From Section 1-3 - Entering and Copying Formulas

Spreadsheet skills introduced in Section 1.3 Introduction to Excel Spreadsheets 1.3
  • Basic Arithmetic in a cell - Addition, subtraction, multiplication, and exponentiation are done with +, 1 , *, /, and ^. The variable is replaced by a cell reference. Multiplication needs to be explicit. (We need x*y) rather than xy.) Raising to a power of e is done with the EXP() function.
    One feture to remember is that Excel uses a slightly different order of operations compared to what is used in all math classes. Excel interprets -5^2 as (-5)^2 rather than -(5^2).
    The Basic Arithmetic video 1.3.1 demonstrates basic arithmetic.
  • Arithmetic with commands - Excel has commands for normal aritmetic operations, SUM(), PRODUCT(), QUOTIENT(), and POWER(). In practice, we will only use SUM(), which cam be used on a list.
  • Showing all the formulas on a page Under the Formulas tab, the show formulas item from the show button shows all the formulas on the page. An image of the button 1.3.2 is in the section.
  • Quick fill Is used when we want to repeat a cell or collection of cells many times. You select a group of cells, then position the cursor over the dot in the lower right corner of the selection. The shape of the curve will change. Click and drage to fill. Formulas are modified according to the rules of relative and absolute references. A screencast is in the Basic Arithmetic video 1.3.1
  • Relative and absolute references - When Copying formulae from one cell to another, either with copy and paste, or with quickfil, it is important to understand relative and absolute cell references. Suppose we are moving a formula from cell A1 to cell B3. (We are going one column over and two rows down.) A relative reference changes with the formula location. =F5 becomes =G7. An absolute reference stays the same and has dollar signs, $, to fix an index. For the same move, =$F$5 stays =$F$5.
    We can also fix either the rows or columns by using dollar signs, $. Moving from cell A1 to cell B3, the formula =F$5 becomes =G$5 and =$F5 becomes =$F7
You have attempted of activities on this page.