When using Excel XP functions play an important role in finding values for a range of cells. Learn all about using functions in Excel XP.
- Type the following information:
In cell A1, type 7842.
In cell A2, type 5681.
In cell A3, type 3947.
In cell B1, type 2594.
In cell B2, type 9024.
In cell B3, type 6505.
- Create a formula in cell A4 that uses the AutoSum function to add the values in cell A1, cell A2, and cell A3.
- Create a formula in cell B4 that uses the Average function to find the averages of values in cell B1, cell B2, and cell B3.