Question

How do formula work in a spreadsheet

Answer 1

Explanation:

Get the example data and create a copy.

To start, move to the first row.

Each formula in a spreadsheet starts with =

Enter = and select the first cell you want to add. Notice how the cell reference appears in the formula? image

now type + and select the second cell you want to add image

Press Enter or tab .

The formula disappears and is replaced by the value. image

Try changing the number in one of the original cells (apples or plums) you should see the value in total update automatically.

You can type each formula individually, but it also possible to cut and paste or drag formulas across a range of cells.

Copy the formula you have just written (using ctrl + c ) and paste it into the cell below (using ctrl + v ), you will get the sum of the two numbers on the row below.

Alternatively click on the lower right corner of the cell (the blue square), and drag the formula down to the bottom of the column. Watch the ‘total’ column update. Feels like magic

Answer 2

Answer:

Excel allows users to perform simple calculations such.

• Formulas. In Excel, a formula is an expression that operates on values in a range of cells or a cell. For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3.
• Functions. Functions are predefined formulas in Excel.