Question

How do formulae work in a spreadsheet?

Answer 1

Answer:

Select cell C2.

Type = (equal sign).

Select cell A2 in the worksheet by using the mouse or the keyboard. This action places the cell reference A2 in the formula in the cell. ...  

Type * (Shift+8 on the top row of the keyboard).

Select cell B2 in the worksheet by using the mouse or the keyboard. ...  

Press Enter.

Explanation:

Answer 2

Below is the method how formula work in spreadsheet.

Explanation:

Formula it is expression that work on value in a specific range of cell.

• We can explain it with an example where it finds the sum of cell value from A1 to A3.

• We need the sum of these three cells in B4 cell which we named as TOTAL( for A1 to A3).

• Now place your cursor on B4 cell and write the formula as  

=sum(A1+A2+A3) in your screen it will be seen as=SUM(A1:A3) then press enter, you will get the sum of all the three cells in B4.

Learn more:

brainly.in/question/77930