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 Can we delete all worksheet from workbook? Yes No None Is Vlookup & Hlookup Case Sensitive? No Yes None See the image and select appropriate option Cell Address Formula Bar None of the given Status Bar None Select the formula to derive sum of all the data points which are higher than 60 =large(data range, k) =sum(max(70)) =max(data_range,”criteria”) =sumif(data_range,”criteria”) None Bin Interval is pre-requirement to perform Histogram via Data Analysis Tool. Yes No None Which type of Dashboard is widely used by Senior Level Management? Operational Dashboard Strategic Dashboard Analytical Dashboard Tactical Dashboard None When to use IFERROR Formula? To replace with specified value, if formula has error To eliminate error in data To replace error in typing To eliminate error in formula None What is the keyboard shortcut key to open "Save AS" dialog box? CRTL + SHIFT + S SHIFT + S F12 CTRL + S None CTRL + D is short cut key for ____________. To copy content of upper cell To Open Design Tab Duplicate cell content To Open dialog box None Slicer tool is used for which purpose? Edit Data Add/Remove Data Delete Data Filter Data None Which of the following features is not under the Data ribbon? Text to Columns What-If Analysis PivotTable Data Validation None What is the shortcut key to Function Library? SHIFT + F3 F3 CTRL + L CTRL + F3 None Is it possible to customize Error Alert message in Data Validation? Depends on Objective Yes No None Conditional Formatting option is available under _________ tab? Design Data Insert Home None Which Excel tool is use to create drop-down list All of them Sorting Option Filter Option Data Validation Tool None What is the shortcut key to convert raw data into Excel Table? [Select all applicable] CTRL + T CTRL + L SHIFT + T SHIFT + L How many arguments are there in Vlookup function? 2 1 3 4 None How many arguments can be there in "NestedIF" functions? None of the given One More than Two Two None What is the keyboard shortcut key to lock cell references in a formula? CTRL + F F4 CTRL + F2 F2 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 Customize Ribbon Data Tab-->Analysis Section-->Data Analysis Tool 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
