Question 1 of 10
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||
| 2 | ||||||||
| 3 | 4 | |||||||
| 4 | ||||||||
| 5 | ||||||||
| 6 | ||||||||
| 7 | ||||||||
| 8 |
Press on your keyboard
Number Formatting Shortcuts - Free Excel Practice Online
This free, interactive exercise teaches you Number Formatting Shortcuts in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Intro to Shortcuts track and works right in your browser - no Excel install, no download, and no signup.
Practising Number Formatting Shortcuts this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.
What you'll practice in this Number Formatting Shortcuts lesson
- Format a number as currency by holding Control and Shift and hitting the dollar sign ($) key.
- Format a number as a percentage by holding Control and Shift, then hitting 5 (%).
- Format a number with two decimal places by holding Control and Shift and hitting the exclamation point (!).
- Format the numbers as currency using the keyboard.
- Format the numbers as percentages using the keyboard.
- Format the numbers as numbers with two decimal places using the keyboard.
- Format the numbers as numbers with two decimal places using the keyboard.
- Format the numbers as currency using the keyboard.
- Format the number as a percentage using the keyboard.
- Format the number as currency using the keyboard.
Number Formatting Shortcuts practice - FAQ
How do I practice Number Formatting Shortcuts in Excel?
Open this free LogicExcel exercise and work through 10 interactive steps. You type the real formula into a live spreadsheet grid and get instant feedback on whether it is correct, plus an explanation - no Excel install and no signup needed.
Is the Number Formatting Shortcuts exercise free?
Yes. Every LogicExcel exercise is 100% free with no account required. Your progress saves automatically in your browser.
What will I learn in this Number Formatting Shortcuts lesson?
This lesson covers Number Formatting Shortcuts as part of the Intro to Shortcuts track. You practice the syntax step by step until it becomes muscle memory you can use at work.