Copyright
Advanced Excel Training: Help & Tutorials  /  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.

Advanced Excel Training: Help & Tutorials Final Exam

Free Practice Test Instructions:

Choose your answer to the question and click 'Continue' to see how you did. Then click 'Next Question' to answer the next question. When you have completed the free practice test, click 'View Results' to see your results. Good luck!

Question 1 1. 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 2 2. Which statement best describes the SUMIF function in Excel?

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

Question 4 4. If in D3 you have =A1, what cell does D3 refer to?

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

Question 6 6. 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 7 7. 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 8 8. Which function totals the number of cells within a range that contain numbers or text?

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

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

Question 11 11. Which cell reference will not change if copied or moved?

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

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

Question 14 14. 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 15 15. There are three types of cell references. Relative and Mixed are two of them. What is the third?

Tell us about yourself

Are you a student or a teacher?

I am a student I am a teacher

Advanced Excel Training: Help & Tutorials Final Free Practice Test Instructions

Choose your answer to the question and click 'Continue' to see how you did. Then click 'Next Question' to answer the next question. When you have completed the free practice test, click 'View Results' to see your results. Good luck!

Support