To Add, select cell G3, type =D3+D4, and then press Enter. The answer will automatically be displayed in the cell G3. To Subtract , select cell G4, type =D3-D4 , and then press Enter .

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite ...

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

To try finding out the functions that Excel provides, click on the cell where you want to apply, then click 'Insert -> Function'. From the 'Select a category' dropdown option, select 'All'.

Before functions, to get an average, you would add a column of numbers; for example 10 numbers; then divide by that total (10). The AVERAGE function does that for you. So typing =AVERAGE(E2:E6 ...