Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Home › Learn Excel › Test

Excel basics test

No tips this time. Answer the questions and see your score: 70% or more and you've passed.

  1. Add up a column. SUM adds up a whole range of cells. B2:B6 means B2 up to and including B6. Add up the monthly costs in B7
  2. Count numbers. COUNT 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 D2
  3. Count with a condition. COUNTIF 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 D2
  4. An average. AVERAGE adds up the numbers in a range and divides by how many there are. Work out the average customer rating in B7
  5. Round. ROUND 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
  6. Lock a cell. Every rep gets the same rate from E2. Lock it with dollar signs ($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 locked
  7. Percentage change. Percentage change = (new − old) / old. The brackets make Excel subtract first. Work out in D2 by what percentage bike sales went up
  8. Which function?.
  9. Copying formulas.
  10. Lowest and highest. MAX returns the highest number in a range, and MIN the lowest. Find the highest temperature of the week, in B9

← All lessons