Lab › Excel Basics
Excel Basics: Excel Lab
Totals, averages, percentages and simple maths on a sheet. Pick a lab. Watch how, then do it yourself.
LAB 01Beginner
Monthly Sales Totals
A shop sold 6 products for 4 months. Find the total and the average for each product.
SUM, AVERAGE, Fill HandleOpen lab →
LAB 02Beginner
Highest, Lowest and Average Marks
Find the highest mark, the lowest mark and the class average.
MAX, MIN, AVERAGEOpen lab →
LAB 03Beginner
Sales Growth %
Compare this year's sales with last year's for each branch, as an amount and as a percentage.
Subtraction, Division, Percent formatOpen lab →
LAB 04Beginner
Discount and Final Price
Each item has a price and a discount %. Find the discount amount and the price the customer pays.
Multiplication, SubtractionOpen lab →
