Excel Test

Excel Testing: Free online Excel Tests perfect for Interview Prep

Welcome to Trainers Direct Sydney, we’ve recently undergone a new website restructure and our online testing page is being updated with more tests. Thanks for visiting.

Online Testing

Excel Interview Questions Test

excel testing

Excel Essentials Top Interview Questions

Our Excel test questions will test your knowledge to intermediate level in Excel, perfect for Interview prep!

1 / 13

Which Excel feature lets you limit what can be entered in a cell?

2 / 13

How can you freeze the top row of your worksheet?

3 / 13

What does a PivotTable allow you to do?

4 / 13

What does the IF function do?

5 / 13

What does the VLOOKUP function do?

6 / 13

Which of the following formats a number as currency?

7 / 13

What does Conditional Formatting do in Excel?

8 / 13

Which of the following locks a cell reference in Excel?

9 / 13

What is a relative cell reference?

10 / 13

What does the function =SUM(A1:A5) do?

11 / 13

Which Excel feature allows you to quickly fill cells with a pattern or series?

12 / 13

Which function is used to calculate the average of a range of numbers?

13 / 13

Which symbol is used to start a formula in Excel?

Your score is

The average score is 72%

0%

Online Testing

Excel Shortcuts Test

excel testing

Excel Keyboard Shortcuts Quiz

Are you using shortcuts to work efficiently in Excel? Find out by taking our test....

1 / 13

What is the shortcut key to paste special?

2 / 13

What is the shortcut key to paste a range name into a formula?

3 / 13

What is the shortcut key to Save As?

4 / 13

What is the shortcut key to copy the cell immediately above the active cell?

5 / 13

What is the shortcut key to edit a cell?

6 / 13

What is the shortcut key to jump to a cell?

7 / 13

What is the shortcut key to insert the current time?

8 / 13

What is the shortcut key to insert the current date?

9 / 13

What is the shortcut key to select to the end of the current cell range?

10 / 13

What is the shortcut key to make a cell absolute in a formula?

11 / 13

What is the shortcut key to insert a chart sheet?

12 / 13

What is the shortcut key to wrap text in a cell?

13 / 13

What is the shortcut key to total a column?

Your score is

The average score is 52%

0%

Online Testing

Excel Hands on Practical Live Exam

excel testing

Download this live Excel test, work through each sheet which contains hands on practical exercises that test the following Excel skills and score as you go:

  • Basic formulas, add subtract, multiply, divide, AutoSum
  • BODMAS (brackets)
  • Absolute references
  • Average, Min and Max Functions

Try the Excel Test 

Globally, Microsoft Office skills are recognised by employers around the world, which can enhance your resume and make you more competitive in the job market. These skills validate your proficiency in various Office applications like Word, Excel, PowerPoint, and Outlook. This is particularly useful in roles that require strong Microsoft Office skills, such as administrative positions, project management and more. 

Additionally, mastering these tools can be part of your professional development plan, helping you stay current with the latest features and best practices in Microsoft Office. By mastering these tools, you can work more efficiently and effectively, which can lead to better performance and productivity in your role. These skills are essential because they simplify a wide variety of tasks, such as document creation, data analysis, presentation, and communication. Moreover, maintaining your proficiency ensures that your skills remain current, which is crucial in a rapidly evolving technological landscape.
 
Trainers Direct helps individuals and teams become proficient in all areas of Microsoft 365. Contact us today to see how we can help you get up to speed quickly with the latest Microsoft IT Training programs.

No of Years Experience

No of 5* Google Reviews

No of Expert Trainers

Get in Touch

Get A Free Quote

Contact Us
Live Chat

We're Here To Help!

Office

1235 Divi St. #1000 San Francisco, CA 94143

Hours

M-F: 8am – 10pm S-S: Closed

Call Us

(235) 396-0987