Excel Topics Used in SM222

Short Description
quiz using Excel formulas and relative and absolute. references. …. In an excel spreadsheet, the formula in column C, row 2 is: = B$3/C1. …

Website: people.bu.edu | Filesize: 24kb

Content
BOSTON UNIVERSITY SCHOOL OF MANAGEMENT
Excel Topics Used in SM222
BU Note # 222-2
Professor Shulamit
Kahn prepared this
note.
Task
1. Write formulas
2. Edit formulas,
copy formulas
For SM222, you should know how to do the following
tasks in Excel. The Help Section of Excel (choose
contents) has explanations of all of these tasks.
There will be at least one question on the first-week
quiz using Excel formulas and relative and absolute
references. Brief explanations are included below.
All formulas must begin with an “=”. They use the
standard mathematical hierarchical order: PEMDAS
(parentheses, exponents, multiplication/division,
addition/subtraction.) Exponents are denoted by a
“^”. Formulas can include numbers and/or cell
locations. Example: “=10+((c2^2)*4)” where C2
denotes the number in cell C2. This formula could
also be written as “=10+c2^2*4″ because of
PEMDAS. A range of cells is denoted by a “:” such as
C2:C10.
When a cell contains a formula, you see the number
computed by the formula rather than the formula
itself. When the cursor is on a cell, the underlying
formula can be seen right about the body of the
spreadsheet…