Microsoft Excel Formatting a worksheet and Calculating Average

Target knowledge: at the end of this post, reader is expected to acquire knowledge on how to format an excel worksheet and calculate average in a cell by typing the formula directly or by using the Auto Sum button.

Formatting a worksheet

In Microsoft excel, user has the option to change how the way the cell is being displayed by the use of “Border” button.

Let us do the Activity below:

Assuming you typed all the data on cells B1, B2, B3, C1, C2 and C3 with the sum on B4 and C4 respectively.

1.  Let us move to A4
2. The word “Sum” is typed
3. Highlight cells B4 and C4 by clicking B4 dragging to C4.
4. Click the border button found at the HOME Ribbon under the Font Group ----- >>
   
5. Choose Top and Double then click

 Calculating Cell Data Average

AVERAGE will calculate the average based on the series of numbers

1. Click A6 cell
2. Type he word “Average” then hit the right arrow to move on cell B6
3. Type “=AVERAGE(B1:B3)
4. After hitting enter the average on the argument will appear which is 21

Calculating Average using AutoSum Button

The other method in computing average is by using the AutoSum function ----- >>

1. Move to the C6 cell
2. Home tab ribbon is chosen
3. Click down arrow next to AutoSum
4. Choose the Average
   
5. Then Select the Cell by dragging from Cell C1 to cell C3
6. Press enter and you will get 100 as a result.