Project 1 - Simulating a BTMS

A formula is an equation that performs a calculation. Like a calculator, Excel can execute formulas that add, subtract, multiply, and divide.

One of Excel's most useful features is its ability to calculate using a cell address to represent the value in a cell. This is called using a cell reference.

To maximize the capabilities of Excel, it is important to understand how to create simple formulas and use cell references.

Excel uses standard operators for equations, such as a plus sign for addition (+), minus sign for subtraction (-), asterisk for multiplication (*), forward slash for division (/), and caret (^) for exponents.

The key thing to remember when writing formulas for Excel is that all formulas must begin with an equals sign (=). This is because the cell contains—or is equal to—the formula and its value.

When a formula contains a cell address, it is called a cell reference. Creating a formula with cell references is useful because you can update data in your worksheet without having to rewrite the values in the formula.