Formulas - Word Drop

A main use of a spreadsheet is to carry out mathematical ______. Spreadsheets do this by using a ______, which is a rule for working with numbers. Every formula must begin with an ______, typed before the calculation. The plus sign adds and the minus sign subtracts. Multiplication uses the ______ symbol because a keyboard has no times sign, while divide uses the forward slash. After typing the formula, press ______ to finish, and the cell then shows the answer.

Brackets control the ______ of a calculation, so the part inside them is worked out ______. In =100+55*45 the multiplication happens before the addition, but adding brackets changes which part is done first.

To use data stored in other cells, a formula includes their ______. For example, =A4+C2 links two cells. After typing the equals sign, ______ on a cell to add its reference. If the number in a referenced cell ______, the formula recalculates and the answer updates automatically.

A formula can be ______ down a column so the same calculation is worked out on every row. Each copy has references that match its own row, so =B2*C2 in row 2 becomes =B3*C3 in row 3.