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 When to use IFERROR Formula? To eliminate error in data To eliminate error in formula To replace with specified value, if formula has error To replace error in typing None What is the shortcut key of Flash Fill? CTRL + F SHIFT + F CTRL + E SHIFT + E None Select right path to activate "Data Analysis Tool Pack" Customize Ribbon C:programm:excel:data analysis tool Data Tab-->Analysis Section-->Data Analysis Tool File-->Options-->add-ins-->Data Analysis Tool-->Go-->OK None Which is the correct formula to find difference between two times? =Text(End Time - Start Time) =Text(End Time - Start Time,"hh:mm:ss") =Text(Start Time - End Time) =Text(End Time - Start Time,hh:mm:ss) 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 What is the shortcut key to convert raw data into Excel Table? [Select all applicable] SHIFT + L SHIFT + T CTRL + T CTRL + L Which of the following features is not under the Data ribbon? Text to Columns PivotTable Data Validation What-If Analysis None Is it possible to customize Error Alert message in Data Validation? Depends on Objective Yes No None What TRIM function does? Remove space before text Remove all spaces except single space between word Remove space before /after number Cut the cell content None See the image and select appropriate option None of the given Formula Bar Cell Address Status Bar None What is the shortcut key to Function Library? F3 CTRL + F3 SHIFT + F3 CTRL + L None Select appropriate cell formats available in Excel. Text Currency Number All of them None Which Excel tool is use to create drop-down list Sorting Option Data Validation Tool Filter Option All of them None What is the keyboard shortcut key to open "Save AS" dialog box? SHIFT + S F12 CTRL + S CRTL + SHIFT + S None Slicer tool is used for which purpose? Delete Data Filter Data Edit Data Add/Remove Data None Select all Advantages of Excel. Free to use Effective Data visualization Easy & quick formatting Third Party support What is the keyboard shortcut key to lock cell references in a formula? F2 F4 CTRL + F2 CTRL + F None Can Pivot table be reported in Existing worksheet ONLY? Yes No None Which is the principle of Pareto Chart? 20/80 Rule 10/90 Rule 80/20 Rule 90/10 Rule None Select the formula to derive sum of all the data points which are higher than 60 =sumif(data_range,”criteria”) =max(data_range,”criteria”) =large(data range, k) =sum(max(70)) 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
