Copyright

Insert Data in Cells and Ranges 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. Looking at the image below, A11 is highlighted. If you click OK, what data will end up in A11?

Question 2 2. If you wanted to search for all text 'Boulder' and replace with 'Denver,' and you wanted to search the entire workbook, which image shows the correct action?

Question 3 3. Under what ribbon menu and grouping of commands will you find the Copy and Paste commands?

Question 4 4. Looking at the image below, in what cell will the total of $783.00 end up? (Assume that the first column is A, the second is B and the third is C.)

Question 5 5. Imagine you have a spreadsheet with several numbers down a column. At the bottom of the column you create a formula to total the numbers. You want to copy only the total to another cell. Which paste option should you choose?

Page 2

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

Question 7 7. In the Consolidate dialogue box, the first selection you make is Function. In order to total everything up in the master worksheet, what should be selected?

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

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

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

Page 3

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

Question 12 12. Which statement is true about the Consolidate tool?

Question 13 13. In Excel, the numbers and text you see in the cell is also referred to as what?

Question 14 14. Look at the image below. B6 is a formula that totals B2, B3 and B4. If we copy B6 to C6 and use the paste option for Formulas and Number Formatting, what will end up in C6?

Question 15 15. Looking at the image below, in what cell number will my new blank cell be inserted? (Assume that the first column is A, the second is B and the third is C.)

Page 4

Question 16 16. Under what ribbon menu and grouping of commands will you find the Insert and Delete options?

Question 17 17. 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 18 18. When you perform a Find and Replace, a dialogue box will open when completed. What information does it provide?

Question 19 19. If you want to make sure that the master updates automatically if you change data to other referenced worksheets, what should you do?

Question 20 20. In the image below A10, A11, B10 and B11 are all selected. If you click OK, what content will be in B10 and B11?

Page 5

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

Question 22 22. 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 23 23. When you copy data or content, it's stored in a temporary place so you can paste the content to another cell or range of cells. What is the storage place called?

Question 24 24. Where in the ribbon will you find the Consolidate command?

Question 25 25. After you consolidate the worksheets, the master is grouped together with buttons to show and hide detailed information. What is this called?

Insert Data in Cells and Ranges 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!

Intro to Excel: Essential Training & Tutorials  /  Business Courses
Support