SIMULATION

Google Sheets simulation

In a virtual spreadsheet, practice moving, entering data, pasting, number formats, row operations, comments and menu search with the keyboard only. The task is an office supply order sheet.

Tutorial

When on, each mission starts by showing which keys to press, in order, one step at a time. Turn it off once you're used to it.

PROLOGUEPrologue: are spreadsheets about clicking toolbar buttons?Mauchu says "just click the buttons", and Keycat builds the order sheet.See →Meet Keycat and MauchuA cat who helps you practise keyboard skills, and a mouse who suggests a handy click.

CHAPTER 1

Chapter 1 Navigation and selection

Practice jumping to the edges of a table, selecting whole rows, and selecting a column of data at once.

  1. 1Jump to the last row of the tableMove to the last product name at the bottom of the order sheet (A10).Loading
  2. 2Go back to the top of the table (A1)You are at the bottom-right of the table. Go back to A1 at the top of the sheet.Loading
  3. 3Make the header row boldMake all of row 1 (Product name, Unit price, Quantity, Amount) bold.Loading
  4. 4Select only the product names and make them boldSelect only the product names (A2 to A10) and make them bold.Loading

CHAPTER 2

Chapter 2 Entering and editing

Practice editing with F2, filling down, copying to a range, and entering today's date.

  1. 5Add a digit with F2The quantity of ballpoint pens should be 100, not 10. Add a 0 to the end of C2.Loading
  2. 6Fill the amount formula downCopy the amount formula in D2 down to D6.Loading
  3. 7Copy the same value to a rangePut the "Pending" in E2 into every row down to E6.Loading
  4. 8Insert today’s dateEnter today's date in the order date cell (B8) and confirm it.Loading

CHAPTER 3

Chapter 3 Pasting and number formats

Practice pasting values only, pasting format only, clearing formatting, currency and percent formats, and outer borders.

  1. 9Paste the amounts as values onlyCopy the amounts (D2 to D6) and paste them into F2 as values only.Loading
  2. 10Paste only the header's formattingMake "Check" in F1 bold, just like A1. Don't change the text in F1.Loading
  3. 11Clear unwanted formatting at onceThe product names (A2 to A6) ended up bold with borders. Remove just the formatting, all at once.Loading
  4. 12Show the unit prices as currencyApply the currency format to the unit prices (B2 to B6).Loading
  5. 13Show achievement as a percentageApply the percent format to the achievement values (B2 to B4).Loading
  6. 14Draw an outer border around the tableAdd an outer border around the table (A1 to D6).Loading

CHAPTER 4

Chapter 4 Inserting, deleting and hiding rows

Practice inserting and deleting rows, hiding rows, and grouping rows.

  1. 15Insert a row aboveInsert one empty row above the sticky notes (row 4).Loading
  2. 16Delete a rowThe paper clips (row 5) were cancelled. Delete that row.Loading
  3. 17Hide rows you don't needHide the notebook and sticky note rows (rows 3 and 4).Loading
  4. 18Group the detail rowsGroup the detail rows (rows 2 to 6).Loading

CHAPTER 5

Chapter 5 Notes, comments and links

Practice adding a note to a cell, posting a comment, and adding a link.

  1. 19Add a note to a cellAdd a note saying "TODO" to the sticky note quantity (C4), then close it.Loading
  2. 20Post a commentPost the comment "check" on the unit price of File (B6).Loading
  3. 21Add a link to a cellAdd a link to example.com on "Stationery shop" in the supplier cell (B8).Loading

CHAPTER 6

Chapter 6 Final chapter: Search the menus

Actions without a shortcut are called up with Alt+/ (search the menus). Practice creating a filter and sorting.

  1. 22Create a filter with menu searchCreate a filter on the order sheet. Filters have no shortcut.Loading
  2. 23Sort by unit price, highest firstRow 1 is frozen. Sort the sheet by unit price (column B), highest first.Loading
  3. 24Case study: finish the order sheetShow the unit prices (B2 to B6) as currency, then create a filter on the table.Loading

* This simulates the behavior of Google Sheets (Chrome on Windows) and may differ in part from the real thing.

* Some actions may not work depending on your browser environment (for example, shortcuts used by extensions).

* Google Sheets is a trademark of Google LLC. This site is not affiliated with Google.

More simulation practice

← Back to the Google Sheets shortcut list