Excel practice exercises

Real situations from working spreadsheets — sales targets, commission tiers, messy exports, aged invoices. Numbered in recommended order: start at 1 and work down, or filter to what you need.

2 exercises — Keyboard Shortcuts · for Business Analyst

Sort:Recommended Difficulty Newest

IntermediateKeyboard Shortcuts
Add the dollar signs without typing them
Cycle a reference through its absolute and relative forms while editing.
4 min20 points
IntermediateKeyboard Shortcuts
Select to the bottom of the data
Extend a selection to the last filled row in one press.
4 min20 points

Excel practice exercises, numbered in recommended learning order.
#	Exercise	Functions	Difficulty	Time	Status
35	Add the dollar signs without typing themNo dataset — this one is about your hands	—	Intermediate	4 min	20 pts
39	Select to the bottom of the dataNo dataset — this one is about your hands	—	Intermediate	4 min	20 pts

Clear all filters

Excel practice exercises

Add the dollar signs without typing them

Select to the bottom of the data

Add the dollar signs without typing them

Select to the bottom of the data