Copyright

Summarize Data with Functions 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. Which function totals the number of cells within a range that contain numbers?

Question 2 2. To find the average of a range of numbers, the AVERAGE function performs what calculation?

Question 3 3. What answer best describes the calculation the following formula would perform? =COUNT(A1:A10)

Question 4 4. What is it called when you have more than one function and calculation, using multiple criteria, in one formula?

Question 5 5. In cell B2, you have a formula that sums cells B3 through B10. You also have a range of numbers in D6 through D10. You want the average of all the numbers in D6 through D10 and the value in B2. What is your formula?

Page 2

Question 6 6. Which formula is correct if you want to add the numbers in cells B3 and B4?

Question 7 7. If you wanted to add the cells A10 through A20 and then multiply that total by 5%, which formula below would be correct?

Question 8 8. If you wanted the average of 5 numbers, 2, 16, 20, 31 and 42, what would be your formula?

Question 9 9. When you enter an Array formula, what must you do to tell Excel to calculate the formula as an Array and not a standard formula?

Question 10 10. Using the example in the image below, what will the value or result be using the following formula? =MIN(D3:D12)

Page 3

Question 11 11. Which formula would add cells A1 through A10 and subtract A15?

Question 12 12. If you wanted to find the empty cells within a range, what formula would work?

Question 13 13. Which formula is an example of finding the smallest number in a range?

Question 14 14. If you have a list of numbers in cells B2 through B20 and you wanted the average of these numbers, what would be the formula?

Question 15 15. Imagine in cells A1 through A10 you have entered the text WIN into 5 of the cells. The other 5 are blank. At the bottom of the column, you enter the formula =COUNT(A1:A10). What value will the formula return?

Page 4

Question 16 16. What types of calculations can you perform using the SUM function?

Question 17 17. What would the formula be if you wanted to multiply B4 by 25%?

Question 18 18. Which function totals the number of cells within a range that contain numbers or text?

Question 19 19. Which formula would find the largest number in the range?

Question 20 20. What happens if you have empty cells in your range, when using the AVERAGE function in a formula?

Page 5

Question 21 21. Using the example in the image below, what would be the value or the result using the following formula? =MAX(D3,29,D12,22)

Summarize Data with Functions 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