Final Excel Assessment – Test Your Skills

Instructions for Students:

Complete the multiple-choice questions carefully.
Attempt all questions; answers should be based on concepts learned in all 8 topics.
Students scoring 70% or more will be eligible to download the certificate.

Test Structure:

Multiple Choice Questions (MCQs) covering formulas, functions, and theory.
Practical scenario-based questions to test your dashboard and data analysis skills.

Guidelines for Submission:

Students must submit answers within the allotted time.
Immediate result will show pass/fail and certificate download link if passed.

Take the Final Test:

Results

🎉 Congratulations! You Passed the Final Excel Assessment 🎉

Content:

Well done! You have successfully completed the Final Excel Assessment – Comprehensive Test.
You scored 70% or higher, which makes you eligible to download your certificate.
This certificate validates your skills in:
- Advanced Excel Formulas & Functions
- Data Analysis & Pivot Tables
- Excel Charts & Visualization
- Dashboard Creation & Interactivity
- Power Query & Power Pivot
- Macros & Automation
- Advanced Excel Add-ins

Next Steps:

Keep practicing your Excel skills using the course materials and exercises.
Share your achievement with peers, employers, or on LinkedIn.
Click here to download your certificate.

⚠️ Quiz Not Passed – Keep Trying! ⚠️

Content:

You scored less than 70% in the Final Excel Assessment – Comprehensive Test.
Don’t worry! Failing this test is a learning opportunity.
Review the course materials and practice the exercises in all 8 topics:
- Advanced Excel Formulas & Functions
- Data Analysis & Pivot Tables
- Charts & Data Visualization
- Dashboard Creation & Interactivity
- Power Query & Power Pivot
- Macros & Automation
- Advanced Excel Add-ins
Once you feel confident, retry the quiz to achieve a passing score and unlock your certificate.

Next Steps:

Go back to the course materials and revise lessons where you faced difficulties.
Practice with Excel files and exercises provided in the course.

#1. Which function is used to calculate the sum of values based on a condition?

a) SUM

b) SUMIF

c) COUNTIF

d) AVERAGE

#2. What does the VLOOKUP function do?

a) Looks up a value vertically

b) Looks up a value horizontally

c) Filters a table

d) Creates a chart

#3. Which function can handle errors in formulas?

a) IFERROR

b) SUM

c) LEN

d) MID

#4. Which chart is best for showing trends over time?

a) Column

b) Line

c) Pie

d) Scatter

#5. To remove duplicate rows from a dataset, you should use:

a) Conditional Formatting

b) Data Validation

c) Remove Duplicates

d) Pivot Table

#6. Which function calculates the payment for a loan?

a) FV

b) PMT

c) NPV

d) IRR

#7. What does a slicer in a Pivot Table do?

a) Sorts the table

b) Filters data visually

c) Calculates totals

d) Creates a chart

#8. Which of these is NOT an array formula?

a) FILTER

b) UNIQUE

c) SUMIF

d) SEQUENCE

#9. How do you make a dashboard interactive?

a) By adding slicers and timelines

b) By adding more colors

c) By printing it

d) By using static charts

#10. Which function returns the number of workdays between two dates?

a) NETWORKDAYS

b) TODAY

c) DATEDIF

d) EOMONTH

#11. Which function can return the position of a value in a range?

a) INDEX

b) MATCH

c) VLOOKUP

d) HLOOKUP

#12. What does the CONCAT function do?

a) Splits text

b) Joins text

c) Counts characters

d) Converts text to numbers

#13. Which function returns the length of a text string?

a) LEN

b) LEFT

c) RIGHT

d) MID

#14. Which of these is used to remove leading and trailing spaces in a text?

a) TRIM

b) PROPER

c) UPPER

d) LOWER

#15. What is the purpose of the IF function?

a) Count values

b) Perform logical tests

c) Lookup values

d) Create charts

#16. Which formula checks if multiple conditions are TRUE?

a) OR

b) AND

c) NOT

d) IFERROR

#17. Which of these is used to calculate the future value of an investment?

a) FV

b) PMT

c) IRR

d) NPV

#18. Which function calculates the net present value of an investment?

a) PMT

b) NPV

c) FV

d) IRR

#19. Which of these is used to calculate internal rate of return?

a) PMT

b) NPV

c) IRR

d) FV

#20. Which function returns today’s date?

a) NOW

b) TODAY

c) DATE

d) DATEDIF

#21. Which function calculates the difference between two dates?

a) NETWORKDAYS

b) DATEDIF

c) EOMONTH

d) TODAY

#22. Which formula can count the number of cells that meet multiple criteria?

a) COUNTIF

b) COUNTIFS

c) SUMIF

d) SUMIFS

#23. Which function adds numbers based on multiple criteria?

a) SUMIF

b) SUMIFS

c) AVERAGEIF

d) COUNTIFS

#24. Which of these is an array formula?

a) UNIQUE

b) SUMIF

c) COUNTIF

d) PMT

#25. Which function returns a value from a table based on row and column numbers?

a) VLOOKUP

b) HLOOKUP

c) INDEX

d) MATCH

#26. Which function finds a value in a range and returns its relative position?

a) INDEX

b) MATCH

c) VLOOKUP

d) HLOOKUP

#27. What type of chart is best for showing proportions?

a) Column

b) Pie

c) Line

d) Scatter

#28. Which function converts text to uppercase?

a) UPPER

b) LOWER

c) PROPER

d) TRIM

#29. Which function capitalizes the first letter of each word?

a) UPPER

b) LOWER

c) PROPER

d) CONCAT

#30. Which Excel feature helps remove duplicates from a table?

a) Conditional Formatting

b) Data → Remove Duplicates

c) Filter

d) Slicer

#31. Which feature allows filtering by multiple criteria visually?

a) Slicer

b) Timeline

c) Conditional Formatting

d) PivotChart

#32. Which feature filters date-based data interactively?

a) Slicer

b) Timeline

c) Conditional Formatting

d) PivotChart

#33. Which tool is used for cleaning large datasets in Excel?

a) PivotTable

b) Power Query

c) Power Pivot

d) Conditional Formatting

#34. Which feature allows creating relationships between multiple tables?

a) Power Query

b) Power Pivot

c) Power Pivot

d) Conditional Formatting

#35. Which function is used to combine text from multiple cells with a delimiter?

a) CONCAT

b) TEXTJOIN

c) LEFT

d) MID

#36. Which function returns unique values from a range?

a) FILTER

b) UNIQUE

c) SEQUENCE

d) SORT

#37. Which chart type is best for showing cumulative data over time?

a) Column

b) Area

c) Line

d) Pie

#38. What is the main purpose of conditional formatting in dashboards?

a) Highlight trends

b) Create charts

c) Filter data

d) Sort data

#39. Which Excel feature allows linking slicers to multiple PivotTables?

a) Report Connections

b) Data Validation

c) Conditional Formatting

d) Power Query

#40. Which function returns the current date and time?

a) NOW

b) TODAY

c) DATE

d) TIME

#41. Which type of dashboard element highlights performance against a target?

a) Chart

b) KPI

c) Table

d) Slicer

#42. Which Excel function can calculate average based on a condition?

a) AVERAGE

b) AVERAGEIF

c) SUMIF

d) COUNTIF

#43. Which of the following is used to automate repetitive tasks in Excel?

a) Macro

b) PivotTable

c) Slicer

d) Timeline

#44. Which of these can you use to sort data dynamically in Excel?

a) SORT

b) FILTER

c) UNIQUE

d) CONCAT

#45. Which function generates a series of sequential numbers in a range?

a) SEQUENCE

b) UNIQUE

c) FILTER

d) SORT

#46. Which Excel feature helps in interactive visualization of multiple metrics?

a) PivotChart

b) SUMIF

c) INDEX

d) IFERROR

#47. Which function checks if a cell contains an error?

a) ISERROR

b) IF

c) LEN

d) MATCH

#48. Which function returns the type of error in a cell?

a) ERROR.TYPE

b) ISNA

c) IFERROR

d) ISERROR

#49. Which chart is best to compare two metrics over the same timeline?

a) Line with markers

b) Pie

c) Area

d) Column

#50. Which Excel tool allows you to analyze large datasets efficiently with relationships and measures?

a) Power Query

b) Power Pivot

c) PivotTable

d) Timeline

Finish