SIMULATION
Excel simulation practice
You can solve the problems presented in virtual Excel using only the keyboard, without using the mouse.
Tutorial
When enabled, each mission begins with a step-by-step preview of the cells and commands to use. Turn it off when you are ready to practise on your own.
CHAPTER 1
Chapter 1 Copy, cut and undo
Practise copying and pasting cells and ranges, moving cells with Cut, undoing actions and making headers bold.
- 1Copy and paste cellsLet's copy "Meeting Room A" in A1 to C1 (leaving the time in B1 as is).Loading
- 2Cut and move cellsMove the “Check” note from A1 to A2, one cell below. Leave A1 empty and keep “Replied” in A3 unchanged.Loading
- 3Restore deleted valuesThe amount 120,000 in B2 was accidentally deleted. Restore it.Loading
- 4Make all headings boldMake the headings (A1-C1) of the expense table all bold.Loading
- 5Copy multiple cells at onceCopy all branch names from A1 to A3 to C1 to C3.Loading
CHAPTER 2
Chapter 2 Cell navigation and range selection
Jump to the first, last and bottom-right cells of a table. Select entire rows or a continuous block of data within a column.
- 6Jump to the last rowThe sales table has 30 rows. Jump straight to the last invoice in A30.Loading
- 7Return to A1You are working in C18. Return straight to the start of the sheet, A1.Loading
- 8Jump to the last used cellLet's move to the bottom right cell (C30) in the range that contains data.Loading
- 9Select and bold an entire rowThe entertainment expense in row 5 needs attention. Make the entire row bold.Loading
- 10Copy the amount column in bulkLet's copy the amounts from C2 to C12 all together from E2 down.Loading
CHAPTER 3
Chapter 3 Edit cells, fill ranges and copy formulas
Use F2 to edit cells, copy formulas down or right, fill multiple cells at once, and insert today’s date.
- 11Edit part of a cellThe product number "A-10" is a typo of "A-100". Let's fix it by adding 0 to the end.Loading
- 12Fill a formula downLet's copy the tax-included calculation formula in B2 to B3-B5.Loading
- 13Fill a formula rightLet's copy the profit formula (sales - expenses) in B4 to the May and June columns (C4 to D4).Loading
- 14Enter the same value in multiple cellsThe number of returned items (B2 to B5) is 0 for all stores.Let's enter 0 in all four cells at once.Loading
- 15Insert today’s dateEnter today's date in the submission date (B1). No need to look at the calendar.Loading
CHAPTER 4
Chapter 4 Edit rows and columns; calculate totals
Insert rows, delete columns, apply currency formatting, add filters and calculate totals with AutoSum.
- 16Insert a rowInsert one empty row above row 4.Loading
- 17Remove unnecessary columnsI no longer use "Memo" in column C. Let's delete column C entirely.Loading
- 18Apply currency formattingLet's display the amount (B2-B5) in currency like "¥1,280".Loading
- 19Add a filterAdd a filter (▼ button) to the expense table heading.Loading
- 20Get the total instantlyIn B6, calculate the total sales of the four branches.Loading
CHAPTER 5
Chapter 5 Combined practice: add, organise and summarise data
Combine the skills you have learned to add expenses, create total rows, remove unwanted rows or columns, and reuse formulas.
- 21Add one item to expense listAdd a row below the expense table: today’s date, Transportation expenses (copied from above), and an amount of 500.Loading
- 22Create a total row to make it stand outCalculate the total in B7, then make all of row 7 bold.Loading
- 23Organize and filter your rosterDelete "Old Memo" in column C of the list and add a filter to the table.Loading
- 24Delete all canceled rows at onceThe requests in rows 4 and 5 were cancelled. Delete both rows together. The total in C8 updates automatically.Loading
- 25Apply last month's formula to this month's columnLet's copy the formula for April's amount (D2-D4) to May's amount (G2-G4).Loading
CHAPTER 6
Chapter 6 Filter data, use absolute references and paste values
Search with filters, lock formula references, copy only visible cells and paste formula results as values.
- 26Narrow down stores with filtersLet's narrow down the sales table to only the rows with store code "T01". The filter is already attached.Loading
- 27Enter a formula with a fixed unit price all at onceAmount (C2-C5) = Quantity x Unit Price (F1). Enter the formula in C2 to C5 at once. F1 must be fixed.Loading
- 28Copy visible rows onlyRows 4 and 5 are hidden. Copy only the visible rows and paste them into D1.Loading
- 29Paste formula results as valuesCopy the next-period target formulas in column C and paste only their values into column E.Loading
- 30Month-end close: add, total and reportEnter the additional expense of 3000 in B6, change the total (B7) to the total of B2 to B6, and paste only that value in report column D7.Loading
CHAPTER 7
Chapter 7 Use Alt for column widths, borders and view settings
Use Alt to navigate the ribbon, fit column widths, apply borders, freeze panes, change gridlines and group rows.
This is a trick for the Windows version of Excel. You can also practice using the Option key on your Mac.
- 31Adjust column width to fit contentThe product name is cut off and cannot be read. Adjust the width of column A to match the longest product name.Loading
- 32Draw borders across the tableDraw grid borders for all cells in the table (A1-C5).Loading
- 33Add a top border and a thick bottom border to the total rowApply a top border and a thick bottom border to the total in row 6.Loading
- 34Freeze heading and left columnFreeze panes so that the header in row 1 and invoice numbers in column A stay visible when you scroll.Loading
- 35Hide worksheet gridlinesBefore sharing the sheet with a client, hide its grey worksheet gridlines.Loading
- 36Group and collapse detailsGroup and collapse the detail rows, 2 through 6, leaving the subtotal visible.Loading
- 37Finish for client submission (final mission)Make the headers bold, calculate the total in B7, apply all borders to the table, fit column widths, freeze the top row and hide gridlines. Use only the keyboard.Loading