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 CTRL + D is short cut key for ____________. To Open dialog box To copy content of upper cell Duplicate cell content To Open Design Tab None What type of chart is useful for prioritizing the project or problem? [Select Most appropriate] Pie Chart Pareto Chart Column Chart Line Chart None Which Excel tool is use to create drop-down list Sorting Option Data Validation Tool Filter Option All of them None Steps to remove gap between bins. Select Graph->Change Chart Style Select Graph->Format Series->Gap Width to "0" Select Graph->Chart Elements->Bar Width to "0" None When Vlookup formula should be applied? [Select all applicable] To lookup the value vertically To lookup the value Horizontally When data headers are in row When data headers are in column Which function to be used to format cell based on given condition? Automatic Cell Formatting Format Painter & Conditional Formatting Conditional Formatting Format Painter None See the image and select appropriate option Status Bar Formula Bar Cell Address None of the given None How many arguments are there in Vlookup function? 1 3 4 2 None See the image and select the appropriate cell reference type applied in cell E3 with reference to H3. None of the given Mix Reference Absolute Reference Relative Reference 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 Select appropriate cell formats available in Excel. Text Number Currency All of them None Which is the principle of Pareto Chart? 80/20 Rule 20/80 Rule 90/10 Rule 10/90 Rule None What is the shortcut key of Flash Fill? CTRL + E CTRL + F SHIFT + F SHIFT + E None What is the keyboard shortcut key to open "Save AS" dialog box? CTRL + S CRTL + SHIFT + S SHIFT + S F12 None What is the shortcut key to convert raw data into Excel Table? [Select all applicable] SHIFT + T CTRL + T CTRL + L SHIFT + L How many arguments can be there in "NestedIF" functions? One More than Two None of the given Two None Histogram is used _______________. [Select all applicable] To check cumulative effect of Category To Organise and display data To arrange data in Category To prioritise data into Category What TRIM function does? Cut the cell content Remove all spaces except single space between word Remove space before text Remove space before /after number None Bin Interval is pre-requirement to perform Histogram via Data Analysis Tool. No Yes None Select all Advantages of Excel. Effective Data visualization Third Party support Easy & quick formatting Free to use 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
