Home > Microsoft Excel > Quizzes > PRDV252 Final Exam - Intermediate Excel
PRDV252 Final Exam - Intermediate Excel
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 2% • Most missed: “On what ribbon will you find Freeze Panes?”

MCQs on formatting, formulas and functions, multi-page spreadsheets, charting data, creating tables that have database features, and be introduced to pivot tables.
 

PRDV252 Final Exam - Intermediate Excel
Time left 00:00
25 Questions

1. The IF function has which three parts in what order?
2. Which of the following functions is written in the correct syntax?
3. On what ribbon will you find Freeze Panes?
4. Which of the following features helps to visually answer specific questions about a user's data by formatting the data to a set of requirements defined by the user?
5. In Excel, a chart that is displayed on the same sheet as the data it is derived from is considered what?
6. Fill in the blank to complete the statement below.
'font-style:normal;font-variant:normal;font-weight:normal;font-stretch:normal;line-height:1.25;font-family:'Myriad Pro'
7. The VLOOKUP function has which three main parts in what order?
8. Which of the following actions allows you to print a worksheet?
9. Which of the following is an appropriate tool to use when you want to visually represent the numeric data in a worksheet?
10. Which of the following tools is NOT available in the Formula Auditing grouping?
11. What is the term for a situation in which a formula/function uses cells from another worksheet within the same workbook?
12. In Excel, what are pre-defined formulas with a specific syntax pattern called?
13. What are the table styles available in Excel 2010?
14. You will find Filter options on which ribbon?
15. Which of the following destinations is NOT a choice in the Insert Hyperlink dialog box?
16. What is the name of a chart that shows percentages of a whole and has no axes?
17. What is the feature that turns a curser into a small crosshair shape on the right corner of the active cell(s)?
18. Which function evaluates a specific condition and returns one value if it is true and another if it is false?
19. Which type of chart displays comparisons about items that are typically organized along the horizontal axis with values along the vertical axis?
20. Which of the following is the correct syntax for a Sum Function in a Summary worksheet for values coming from worksheets named Quarter 1, Quarter 2, Quarter 3, and Quarter 4?
21. Excel 2010 introduced a new feature that comprises a very small chart within a worksheet cell that provides a visual representation of data or shows patterns in data. What is this feature called?
22. What is a handy keyboard shortcut that puts dollar signs ($$) around cell and row addresses in a formula and creates an absolute value?
23. Fill in the blanks to complete the statement below.
'font-style:normal;font-variant:normal;font-weight:normal;font-stretch:normal;line-height:1.25;font-family:'Myriad Pro'
24. Which of the following is NOT available on a Table Tools Ribbon for Table Styles Options?
25. When you are creating formulas using cell location, your default cell reference is:

⚡ Recently practiced quizzes in this topic
Live quiz activity
Computer Excel Exam 2 WGU Spreadsheet Formula Basic Microsoft Excel Practice Test Prove It - Microsoft Excel Test Microsoft Excel (MS Excel) Practice Test: All Topics Counting and Rounding Formulas Useful Excel Vocabulary Management Science MGSC 290 Final Excel Fundamentals Test (Upwork) Prove It - Microsoft Excel 2
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.