Copyright
Microsoft Excel Certification: Practice & Study Guide  /  Business Courses

Test Prep Plan - Take a practice test

Take this practice test to check your existing knowledge of the course material. We'll review your answers and create a Test Prep Plan for you based on your results.
How Test Prep Plans work
1
Answer 50 questions
Test your existing knowledge.
2
View your test results
Based on your results, we'll create a customized Test Prep Plan just for you!
3
Study smarter
Study more effectively: skip concepts you already know and focus on what you still need to learn.

Microsoft Excel Certification: Practice & Study Guide Final Exam

Free Practice Test Instructions:

Choose your answer to the question and click 'Continue' to see how you did. Then click 'Next Question' to answer the next question. When you have completed the free practice test, click 'View Results' to see your results. Good luck!

Question 1 1. There are three different types of alert messages: Stop, Caution and Information. What is the purpose of the Stop alert message?

Question 2 2. What are the margin settings for Excel's standard Normal option?

Question 3 3. Looking at the image below, which option would you select to print only the selected worksheet?

Question 4 4. What is a CSV or Comma Delimited file normally used for?

Question 5 5. In MS Excel, which characters are not accepted as part of a file name?

Question 6 6. If you wanted to send a PDF version of your worksheet to a team of co-workers, requesting their comments and suggested changes, which option should you select?

Question 7 7. By default, how does MS Excel align numbers? (Horizontally)

Question 8 8. Where on the Excel screen will you find the worksheet tabs?

Question 9 9. What are the steps if you need to remove the Print Area settings?

Question 10 10. If you prefer keyboard commands over mouse clicks, what keyboard combination will perform a basic save?

Question 11 11. Under what ribbon menu and group of commands will you see the Find & Select tool?

Question 12 12. If you prefer the right-click method to ribbon commands, you can right-click on the cell to be formatted. Which option do you select from the drop-down menu?

Question 13 13. What steps do you take in order to run the Check Compatibility command?

Question 14 14. If you wanted to enlarge the printout of your spreadsheet, which percentage below would be work?

Question 15 15. Which of the following restrictions is a type available in the Excel Data Validation rule?

Tell us about yourself

Are you a student or a teacher?

I am a student I am a teacher

Microsoft Excel Certification: Practice & Study Guide Final Free Practice Test Instructions

Choose your answer to the question and click 'Continue' to see how you did. Then click 'Next Question' to answer the next question. When you have completed the free practice test, click 'View Results' to see your results. Good luck!

Support