Using Microsoft 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. Under what ribbon menu will you find the Excel Themes?

Question 2 2. If you already have shaded cells with different color fills and fonts, what happens when you change the theme?

Question 3 3. If you right-click on a row reference number and click on Insert, where will the row be added?

Question 4 4. If you want to quickly insert a column or row, what keyboard short-cut command do you use?

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

Page 2

Question 6 6. Under what menu in the ribbon will you find the Data Validation command?

Question 7 7. If you choose to use the ribbon commands to adjust the values for row height and column width, which ribbon menu and grouping of commands do you use?

Question 8 8. If you set a row height or column width to 0 (zero), what happens to the row and column?

Question 9 9. Which of the following formulas would change the text TROUBLE to trouble?

Question 10 10. The artist name in cell B2 is displayed as billy currington. In D2, you added a formula to change the text to Billy Currington. Which of the following formulas did you use?

Page 3

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

Question 12 12. How do you rename the title of a worksheet tab?

Question 13 13. Which command allows you to specify which row(s) or column(s) should be printed on overflow pages?

Question 14 14. What are the first three steps to customize margins?

Question 15 15. The following string of numbers has been entered in B1, DLM343456B82. Which formula will capture the first three characters?

Page 4

Question 16 16. Using the following string of characters, DLM343456B82, which formula will extract 343456? The data is located in cell B2.

Question 17 17. What type of information might you find in a header or footer of an Excel document?

Question 18 18. Where can you add header information?

Question 19 19. You learned in this lesson about Excel that both Trim and Clean can be used together in one formula. Which formula below has the correct syntax or structure?

Question 20 20. You just imported data to Excel from an external database. Unfortunately, the data in your Excel spreadsheet has several characters you do not recognize and do not belong. Which formula would be the best to help you remove the odd characters?

Page 5

Question 21 21. To add a new worksheet in an Excel document, you should click on:

Question 22 22. The first thing to do when moving or copying a worksheet to a different workbook is to:

Question 23 23. What type of image is best to use as a watermark?

Question 24 24. Where do you find the Picture command for the header option?

Question 25 25. Characters and punctuation, such as periods and commas, must be surrounded by what?

Page 6

Question 26 26. The text in A1 is Johnny. The text in A2 is Johnson. What would be the result of the following formula? =concatenate(A1,'' '',A2)

Question 27 27. Which statement below best describes Themes and use of colors?

Question 28 28. To use the ribbon commands, what menu and grouping of commands will you find the Insert and Delete command?

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

Question 30 30. Which statement best describes the 'header row' in a spreadsheet?

Using Microsoft 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!

Computer Science 103: Computer Concepts & Applications  /  Computer Science Courses
Support