Excel for Marketing Managers

Calculation Basics

Calculation

Basics

Calculating an Average

In the next problem, you need to figure out the average of a column of numbers.

Take a look at the AutoSum button in Figure 33. To the right of the button is a
dropdown arrow. This dropdown arrow will allow you to quickly enter formulas
that will let you Average, Count, and find the smallest or largest value.

Put the cellpointer in B12. Select the dropdown arrow next to the AutoSum
button and choose Average.

The result: Excel will enter a formula using the AVERAGE function to calculate
the average.

Figure 32

Taking the average of a

column of numbers

Figure 33

Selecting Average from the AutoSum

dropdown menu