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 Histogram is used _______________. [Select all applicable] To arrange data in Category To check cumulative effect of Category To Organise and display data To prioritise data into Category Select all Advantages of Excel. Effective Data visualization Third Party support Free to use Easy & quick formatting Is Vlookup & Hlookup Case Sensitive? No Yes None Which is the correct formula to find difference between two times? =Text(End Time - Start Time) =Text(Start Time - End Time) =Text(End Time - Start Time,"hh:mm:ss") =Text(End Time - Start Time,hh:mm:ss) None Which Excel tool is use to create drop-down list Data Validation Tool All of them Sorting Option Filter Option None What is the result of NOW() function? It return current Time It return current Date and Time None of these It returns current Date None Can Pivot table be reported in Existing worksheet ONLY? No Yes None What is the keyboard shortcut key to lock cell references in a formula? F4 CTRL + F F2 CTRL + F2 None Which of the following Excel features allow to select all cells that are blanks? CountA Count Go To Special Paste Special None Select right path to activate "Data Analysis Tool Pack" Customize Ribbon File-->Options-->add-ins-->Data Analysis Tool-->Go-->OK C:programm:excel:data analysis tool Data Tab-->Analysis Section-->Data Analysis Tool None Slicer tool is used for which purpose? Edit Data Delete Data Filter Data Add/Remove Data None Select the formula to derive sum of all the data points which are higher than 60 =sumif(data_range,”criteria”) =large(data range, k) =sum(max(70)) =max(data_range,”criteria”) None When to use IFERROR Formula? To replace error in typing To eliminate error in data To eliminate error in formula To replace with specified value, if formula has error None Which function to be used to format cell based on given condition? Format Painter & Conditional Formatting Automatic Cell Formatting Format Painter Conditional Formatting None How are data organised in a spreadsheet? Rows and columns Height and width None How many vertical axis are there in Pareto Chart? 3 1 2 0 None CTRL + D is short cut key for ____________. To copy content of upper cell Duplicate cell content To Open dialog box To Open Design Tab None What is the shortcut key of Flash Fill? CTRL + F SHIFT + E SHIFT + F CTRL + E None Steps to remove gap between bins. Select Graph->Chart Elements->Bar Width to "0" Select Graph->Change Chart Style Select Graph->Format Series->Gap Width to "0" None How many arguments are there in Vlookup function? 3 4 1 2 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
