introduction to excel please use speaker notes for additional information!
TRANSCRIPT
Introduction to Excel
Please use speaker notes for additional information!
=AVERAGE(B6:B11)
AVERAGE is a function that will take an average of range of cells indicate. In this example B6: B11 means B6 through B11.
=ROUND(AVERAGE(B6:B11),0)
When I add ROUND, I put the average formula inside parenthesis because when I use a function like either AVERAGE or ROUND, the thing I act on is in parenthesis. After the close of the average parenthesis, I added a comma and a zero to round to zero decimal places. Then I closed the ROUND parenthesis
=ROUND((B6+C6+D6+E6+F6)/5,0)
The formula is shown in green.
Round has the syntax of ROUND(thing to round,decimal places).
In this example I am rounding the formula to 0 decimal places.