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 What type of chart is useful for prioritizing the project or problem? [Select Most appropriate] Line Chart Pareto Chart Pie Chart Column Chart None What is the shortcut key to convert raw data into Excel Table? [Select all applicable] SHIFT + T CTRL + T CTRL + L SHIFT + L What is the result of NOW() function? It return current Date and Time It return current Time It returns current Date None of these None Can Pivot table be reported in Existing worksheet ONLY? No Yes None Histogram is used _______________. [Select all applicable] To check cumulative effect of Category To prioritise data into Category To arrange data in Category To Organise and display data Select all Advantages of Excel. Easy & quick formatting Free to use Effective Data visualization Third Party support Which Excel tool is use to create drop-down list All of them Sorting Option Filter Option Data Validation Tool None Bin Interval is pre-requirement to perform Histogram via Data Analysis Tool. No Yes None What is the shortcut key to Function Library? F3 CTRL + L SHIFT + F3 CTRL + F3 None Conditional Formatting option is available under _________ tab? Home Insert Data Design None By which option Pivot Table headers can be change? By renaming Headers By selecting headers while creating pivot table None of the given By applying Show in outline form None Can we delete all worksheet from workbook? No Yes None Which function to be used to format cell based on given condition? Automatic Cell Formatting Format Painter Conditional Formatting Format Painter & Conditional Formatting None How many arguments can be there in "NestedIF" functions? More than Two One Two None of the given None Select right path to activate "Data Analysis Tool Pack" File-->Options-->add-ins-->Data Analysis Tool-->Go-->OK Customize Ribbon Data Tab-->Analysis Section-->Data Analysis Tool C:programm:excel:data analysis tool None Which of the following features is not under the Data ribbon? PivotTable Data Validation Text to Columns What-If Analysis None What is the shortcut key of Flash Fill? SHIFT + F CTRL + E SHIFT + E CTRL + F None Which is the principle of Pareto Chart? 10/90 Rule 80/20 Rule 20/80 Rule 90/10 Rule None When Vlookup formula should be applied? [Select all applicable] To lookup the value Horizontally When data headers are in row When data headers are in column To lookup the value vertically Steps to remove gap between bins. Select Graph->Chart Elements->Bar Width to "0" Select Graph->Format Series->Gap Width to "0" Select Graph->Change Chart Style 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
