Question

Explain and mention the steps to using Formulas in spreadsheet? ​

Answer 1

Answer:

Create a formula that refers to values in other cells

Select a cell.

Type the equal sign =. Note: Formulas in Excel always begin with the equal sign.

Select a cell or type its address in the selected cell.

Enter an operator. ...

Select the next cell, or type its address in the selected cell.

Press Enter.

Answer 2

Answer:

Microsoft Excel formulas - the basics

Explanation:

1.All Excel formulas begin with an equal sign (=).

2.After the equal symbol, you enter either a calculation or function. For 3.example, to add up values in cells B1 through B5, you can either: Type the entire equation: =B1+B2+B3+B4+B5. ...

4.Press the Enter key to complete the formula. Done!