Welcome to the Exam based on Advanced Excel for Data Analytics course.
You have to answer 20 questions. This quiz will be automatically submitted after 30 minutes. You can see timer in the title bar of the website. There is no negative marking.
You will get email with certificate if you are eligible. (Eligibility criteria is 50% or more).
NOTE: The name you written in this quiz will be appeared on the certificate. It will not change after.
All the Best !!!
Team Stat Modeller
CTRL + D is short cut key for ____________.
Select the formula to derive sum of all the data points which are higher than 60
By which option Pivot Table headers can be change?
What is the shortcut key to Function Library?
Is Vlookup & Hlookup Case Sensitive?
See the image and select appropriate option
Which Excel tool is use to create drop-down list
What is the shortcut key of Flash Fill?
When to use IFERROR Formula?
What is the result of NOW() function?
Select all Advantages of Excel.
What is the shortcut key to convert raw data into Excel Table? [Select all applicable]
Is it possible to report Pivot Table in different worksheet?
See the image and select the appropriate cell reference type applied in cell E3 with reference to H3.
Conditional Formatting option is available under _________ tab?
Which is the principle of Pareto Chart?
Which type of Dashboard is widely used by Senior Level Management?
Is it possible to customize Error Alert message in Data Validation?
What type of chart is useful for prioritizing the project or problem? [Select Most appropriate]
When Vlookup formula should be applied? [Select all applicable]
You cannot copy content of this page