Home › Learn Excel › Lesson 3
Find the average, the lowest and highest value, round results and pick the top scores.
AVERAGE adds up the numbers in a range and divides by how many there are. Work out the average customer rating in B7MAX returns the highest number in a range, and MIN the lowest. Find the highest temperature of the week, in B9ROUND rounds a number to the number of decimals you choose. It changes the value itself, not just how it looks. Round the price in B2 to two decimals, in C2LARGE returns the largest value but one, two or more down the list: 1 is the highest, 2 the second highest. Find the second-highest sales figure, in D2AVERAGE adds up the scores and divides by how many there are, in one go. Work out the average test score in D2