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 is the shortcut key of Flash Fill? CTRL + F SHIFT + F CTRL + E SHIFT + E None How many arguments can be there in "NestedIF" functions? More than Two Two None of the given One None Which is the principle of Pareto Chart? 80/20 Rule 20/80 Rule 90/10 Rule 10/90 Rule None What is the result of NOW() function? It return current Date and Time None of these It return current Time It returns current Date None Which type of Dashboard is widely used by Senior Level Management? Operational Dashboard Analytical Dashboard Strategic Dashboard Tactical Dashboard None Histogram is used _______________. [Select all applicable] To check cumulative effect of Category To prioritise data into Category To Organise and display data To arrange data in Category How many vertical axis are there in Pareto Chart? 2 1 0 3 None How are data organised in a spreadsheet? Height and width Rows and columns None Select appropriate cell formats available in Excel. Currency Number Text All of them None See the image and select appropriate option None of the given Formula Bar Cell Address Status Bar None Can we delete all worksheet from workbook? No Yes None How many arguments are there in Vlookup function? 1 3 4 2 None Is it possible to report Pivot Table in different worksheet? Yes No None Can Pivot table be reported in Existing worksheet ONLY? No Yes None What is the keyboard shortcut key to open "Save AS" dialog box? CRTL + SHIFT + S CTRL + S F12 SHIFT + S None Which of the following features is not under the Data ribbon? What-If Analysis Data Validation Text to Columns PivotTable None Select right path to activate "Data Analysis Tool Pack" C:programm:excel:data analysis tool File-->Options-->add-ins-->Data Analysis Tool-->Go-->OK Data Tab-->Analysis Section-->Data Analysis Tool Customize Ribbon None Select all Advantages of Excel. Free to use Easy & quick formatting Third Party support Effective Data visualization What is the shortcut key to Function Library? F3 CTRL + F3 CTRL + L SHIFT + F3 None When to use IFERROR Formula? To eliminate error in formula To replace error in typing To replace with specified value, if formula has error To eliminate error in data 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
