Advanced Excel for Data Analytics 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 Your Name Your Email Your Number Your Unique Reference Number Which is the principle of Pareto Chart? 20/80 Rule 10/90 Rule 90/10 Rule 80/20 Rule None Is it possible to report Pivot Table in different worksheet? Yes No None By which option Pivot Table headers can be change? None of the given By selecting headers while creating pivot table By applying Show in outline form By renaming Headers None CTRL + D is short cut key for ____________. Duplicate cell content To copy content of upper cell To Open dialog box To Open Design Tab None Can Pivot table be reported in Existing worksheet ONLY? No Yes None Slicer tool is used for which purpose? Delete Data Filter Data Add/Remove Data Edit Data None Bin Interval is pre-requirement to perform Histogram via Data Analysis Tool. Yes No None Descriptive Statistics provides _____________ of sample data. [Select all applicable] Calculate Central Tendency & Measure of Dispersion Description of Data Statistical Summary of Data Hypothesis Testing What is the result of NOW() function? It return current Time It returns current Date It return current Date and Time None of these None See the image and select appropriate option Formula Bar Cell Address None of the given Status Bar None How many vertical axis are there in Pareto Chart? 1 3 2 0 None Is it possible to customize Error Alert message in Data Validation? Yes No Depends on Objective None Select all Advantages of Excel. Third Party support Free to use Effective Data visualization Easy & quick formatting Which function to be used to format cell based on given condition? Conditional Formatting Format Painter Format Painter & Conditional Formatting Automatic Cell Formatting None Which Excel tool is use to create drop-down list Filter Option Sorting Option All of them Data Validation Tool None What is the shortcut key of Flash Fill? CTRL + E SHIFT + F CTRL + F SHIFT + E None What is the keyboard shortcut key to lock cell references in a formula? F4 CTRL + F CTRL + F2 F2 None When Vlookup formula should be applied? [Select all applicable] To lookup the value vertically When data headers are in column To lookup the value Horizontally When data headers are in row Histogram is used _______________. [Select all applicable] To check cumulative effect of Category To Organise and display data To prioritise data into Category To arrange data in Category Select appropriate cell formats available in Excel. Currency Number All of them Text None Please Share This Share this content Opens in a new window Opens in a new window Opens in a new window Opens in a new window Opens in a new window Opens in a new window Opens in a new window Opens in a new window
