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
^. 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
eis 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).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
B3. (We are going one column over and two rows down.) A relative reference changes with the formula location.
=G7. An absolute reference stays the same and has dollar signs,
$, to fix an index. For the same move,
=$F$5.We can also fix either the rows or columns by using dollar signs,
$. Moving from cell
B3, the formula
- We can name a cell with a name that describes its contents. 1.3.3 The name is put in the box in the upper right corned of the worksheet 1.3.4. This makes The formulas in the cells easier to read and understand 1.3.5.
You have attempted of activities on this page.