Constructing a formula

In this topic, we will look at how to type formulas using various methods. Continue using the SSGRegions.xlsx workbook for the following examples:

1. Click on a cell in the worksheet into which you would like to place the answer to a calculation. For this example, we will select B12. Press the = key on the keyboard to start the formula.
2. Start typing the formula you wish to use. In this case, we are adding up, so we will use the SUM function. Type sum directly after the = sign. When entering an s for sum, Excel will offer all the formulas that start with the letter s. Just to the right of the formula, you will see a tooltip with information about the formula you have chosen. Continue to type the formula you require or select one from the list, as illustrated in the following screenshot:

3. Open a bracket to separate the formula from the range of cells you would...