Keyboard shortcuts are used in many programs - they make our work easier and significantly faster. But only if we know and use them on a daily basis.

Often there are so many shortcuts in a given tool that it is difficult to remember them all. This is certainly the case of MS Excel, where you can find a wide variety of shortcuts and hotkeys.

If you want to test your knowledge of keyboard shortcuts in MS Excel and learn new, useful combinations at the same time, this is a great way to do it! Whether you are a beginner or an experienced user of this spreadsheet, you will find something to suit you.

The tests contain 50 questions, covering dozens of different keyboard shortcuts and function keys available in MS Excel on Windows. These range from the well-known, most commonly used ones to the much less popular, but equally useful in everyday work.

The questions are divided into 5 groups - from A to E:

A - the most common keyboard shortcuts, which you should already be familiar with, but are you sure.......,

B - shortcuts that speed up entering formulas or specific content into worksheet cells,

C - key combinations that make it easier to move quickly within a worksheet or between MS Excel worksheets,

D - shortcuts enabling instant formatting of individual cells or selected ranges of data,

E - a final set of useful, but less familiar MS Excel keyboard shortcuts.

After passing each test, you will be given the opportunity to review all the answers and explanations for each question. To get the most out of the prepared material, when reviewing the summaries you can open MS Excel and check, how the newly learnt shortcuts operate in practice - this is the best way to remember the new combinations!

Then try to remember or write down the ones you might find useful in your daily use of MS Excel. You can use the tests over and over again, so even if you are just starting out with the worksheets, you can gradually learn and start using the shortcuts that appear in the test.

Or do you have your own favourite combinations that have not appeared? Let us know in the comments! We would be happy to extend the tests with more tasks :)

You are welcome!