Home › Learn Excel › Test
No tips this time. Answer the questions and see your score: 70% or more and you've passed.
SUM adds up a whole range of cells. B2:B6 means B2 up to and including B6. Add up the monthly costs in B7COUNT only counts cells with numbers. Text like n/a and empty cells are skipped. Count how many cells in B2:B7 contain a number, in D2COUNTIF counts the cells that meet a condition. It has two parts: where to look and what to count. Count how many invoices are "Paid", in D2AVERAGE adds up the numbers in a range and divides by how many there are. Work out the average customer rating in B7ROUND 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 C2$E$2), so the formula still points to E2 when you copy it down. Work out Emma's commission in C2, with the rate in E2 lockedMAX returns the highest number in a range, and MIN the lowest. Find the highest temperature of the week, in B9