Traducir el blog

Excel keyboard shortcuts Test

Posted on marzo 15, 2023 by Excel Pedro Wave

With this Excel keyboard shortcuts Test on Windows you'll be able to remember more key combinations than with any other keyboard shortcut method.

To get good results in this test, I recommend you to study the shortcuts keyboard by reading my previous article:

Keyboard shortcuts in Excel | #ExcelPedroWave

This new test is designed in 4 sheets, 2 visible and 2 hidden.

I'm only going to explain how to do the test in the 'Test' sheet and how see the test results on the 'Results' sheet.


'Test' sheet

Tests are performed on the 'Test' sheet.

Each test consists of 20 questions, and you have to answer them in less than 5 minutes.

The question header indicates what type of shortcut is being asked. In the image example: Formatting cells.

Each correct answer adds 5 points, so you can get from 0 to 100 points in each test.

4 possible answers are shown and only one of them is the correct answer.

Type the answer number in cell B14, from 1 to 4, that you think is the right answer.

Whether the answer is correct or incorrect is indicated in cell C14.

The times of the question, of the answer and the total time of the question are recorded.

To continue with the test, press the Delete key or the number 0 and the Return key.


'Results' sheet

On the 'Results' sheet are the 20 questions of a test with their answers.

Only wrong answers are shown and correct answers are hidden, so as not to give clues.

The result of the test is indicated, with the points obtained, the number of answers, the time of each answer and the total time of all answers.


Take the cloud keyboard shortcuts test

Try the Excel keyboard shortcuts Test without leaving this page!

To adjust the zoom of this test:

  • On the mobile or cell phone, use two fingers on the screen, as you do to expand or reduce a photo.
  • On the PC, place the cursor inside the browser and press the Control key, turning the mouse's wheel.

All sheets are protected without password and the workbook doesn't contain macros, because it is designed only with formulas, so the iterative calculation performs the test.

There are 2 hidden sheets, one with the test settings and the other with all the questions and answers, so I encourage you to analyze each of the 4 sheets and gut their formulas, with which you will learn new techniques of calculus and improve your Excel skills.

Ask me if you have questions about how I have done this interactive test in the cloud from Microsoft OneDrive.

No Response to "Excel keyboard shortcuts Test"

Leave A Reply

Dime si te gusta lo que lees y, si no te gusta, dime por qué. Tengo habilitada la moderación de comentarios. Tu comentario se publicará pronto.

Mi lista de blogs