The following 30 Excel questions will test your basic skills. The quiz is well-curated to touch on all the important Excel areas such as formulas, navigation, shortcuts, functions, charts, and VBA. If you score 30/30 then that means you are an advanced Excel user.
If you find this test too Easy try our advanced and most difficult quiz for pro users. Otherwise, this Excel Quiz for Beginners will help you become a proficient Excel user. Feel free to share this quiz with your friends and see whether they can beat your score.
Results
#1. What is the keyboard shortcut to save a file?
#2. Which function is used to sum a range of cells?
#3. What does the function VLOOKUP do?
#4. How do you freeze panes in Excel?
#5. Which Excel feature is used for data analysis?
#6. What is the default file format in Excel?
#7. How do you add a new worksheet in Excel?
#8. Which formula is used for conditional formatting?
#9. What is the purpose of the AutoFill handle?
#10. How can you add a comment to a cell?
#11. What does the function COUNTA do?
#12. What is the keyboard shortcut to undo the last action?
#13. Which function is used to find the highest value in a range?
#14. How do you create a chart in Excel?
#15. Which feature is used to format cells based on specific conditions?
#16. How can you remove a filter in Excel?
#17. What is the function of the CONCATENATE function?
#18. How do you insert a row in Excel?
#19. What is the purpose of the Fill handle in Excel?
#20. Which option is used to sort data in Excel?
#21. What does the function PMT() do in Excel?
#22. How do you add a border to a cell in Excel?
#23. What is the keyboard shortcut for opening the Format Cells dialog box?
#24. Which option allows you to view two Excel worksheets side by side?
#25. What function is used for finding the average of a range of values in Excel?
#26. How can you protect an Excel worksheet with a password?
#27. What does the function IFERROR() do?
#28. How do you add a drop-down list in Excel?
#29. What is the default font size in Excel?
#30. What does the function AVERAGEIF() do?
#31. You can display the current date in excell by using a function. Which is it?
You can display the date today by using the formal =TODAY(). If you want to display the current time then you need to use the =now() function