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.

Data Entry in Excel Chapter Exam

Exam Instructions:

Choose your answers to the questions and click 'Next' to see the next set of questions. You can skip questions if you would like and come back to them later with the yellow "Go To First Skipped Question" button. When you have completed the practice exam, a green submit button will appear. Click it to see your results. Good luck!

Page 1

Question 1 1. What is another term for click and hold with your mouse?

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

Question 3 3. When starting a number fill that will follow a numeric sequence, Excel needs to see a pattern to get started. How many numbers in the list do you need to enter?

Question 4 4. What other find options will you see if you click on the Options button in the Find dialogue box?

Question 5 5. If you wanted to replace 'Boulder' with 'Denver,' what field or box would you type 'Denver' into?

Page 2

Question 6 6. If you wanted to copy data in the first cell down an entire column, stopping at the last row of data in the spreadsheet, what steps would you use?

Question 7 7. The small square in the bottom, right-hand corner of a selected cell or range is referred to as what?

Question 8 8. The AutoFill feature works with what type of data?

Question 9 9. When you perform a Find and Replace, a dialogue box will open when completed. What information does it provide?

Question 10 10. If you wanted to search for all text 'Boulder' and replace with 'Denver,' and you wanted to search the entire workbook, what do you click on under Find and Replace?

Data Entry in Excel Chapter Exam Instructions

Choose your answers to the questions and click 'Next' to see the next set of questions. You can skip questions if you would like and come back to them later with the yellow "Go To First Skipped Question" button. When you have completed the practice exam, a green submit button will appear. Click it to see your results. Good luck!

Support