# 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.

# Excel Formulas & Functions 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 of the following is using an incorrect syntax for the SUMIF formula?

#### Question 2 2. 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 3 3. In order for the syntax to be correct, when writing a formula using the COUNTIF function, operators must have what symbol on both sides?

#### Question 4 4. If you had a cell reference C5, but in your formula you want C to stay constant and 5 to change, what would be the correct structure?

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

### Page 2

#### Question 6 6. If you wanted to find the average price of transmissions sold, which formula would you be likely to use?

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

#### Question 8 8. The following title is entered in A1: Firework. Which formula, entered into C4 will convert the text in A1 to capitalized letters?

#### Question 9 9. Which statement best describes the SUMIF function in Excel?

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

### Page 3

#### Question 11 11. 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?

#### Question 12 12. Which Excel formula would be best to use if you want to remove extra spaces?

#### Question 13 13. Which of the following answers best describes the Trim function in Excel?

#### Question 14 14. The plus symbol (+) and the equal sign (=) are considered what part of a formula?

#### Question 15 15. COUNT, SUM and AVERAGE are all examples of what element in a formula?

### Page 4

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

#### Question 17 17. If you wanted to look in a range and find the text 'peaches', then look in the range adjacent and total only the values where there is a match to peaches, what would be the formula?

#### Question 18 18. What does the term concatenate mean?

#### Question 19 19. 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?

#### Question 20 20. You have a list of numbers in Column B, specifically, B3 through B25. You would like the average, if the number is below 10. Which formula would be best?

### Page 5

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

#### Question 22 22. 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?

#### Question 23 23. There are 4 major elements of a formula. Characters, Operators and Cell References are three of them. What is the fourth element of a formula?

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

#### Question 25 25. Which answers best demonstrates the use of the UPPER function in a formula?

### Page 6

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

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

#### Question 28 28. In the following formula, what is missing? =averageif(A1:A10 hood B1:B10)

#### Question 29 29. There are three types of cell references. Relative and Mixed are two of them. What is the third?

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

#### Excel Formulas & Functions 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!

#### Explore our library of over 79,000 lessons

Browse by subject