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 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 By which option Pivot Table headers can be change? None of the given By applying Show in outline form By renaming Headers By selecting headers while creating pivot table None What TRIM function does? Cut the cell content Remove space before text Remove all spaces except single space between word Remove space before /after number None Which of the following features is not under the Data ribbon? PivotTable Text to Columns What-If Analysis Data Validation None Is Vlookup & Hlookup Case Sensitive? Yes No None Is it possible to report Pivot Table in different worksheet? Yes No None How many vertical axis are there in Pareto Chart? 0 3 1 2 None Select the formula to derive sum of all the data points which are higher than 60 =large(data range, k) =max(data_range,”criteria”) =sumif(data_range,”criteria”) =sum(max(70)) None Select right path to activate "Data Analysis Tool Pack" Data Tab-->Analysis Section-->Data Analysis Tool Customize Ribbon File-->Options-->add-ins-->Data Analysis Tool-->Go-->OK C:programm:excel:data analysis tool None Conditional Formatting option is available under _________ tab? Data Design Home Insert None What is the shortcut key to convert raw data into Excel Table? [Select all applicable] CTRL + T SHIFT + T SHIFT + L CTRL + L What type of chart is useful for prioritizing the project or problem? [Select Most appropriate] Pareto Chart Line Chart Column Chart Pie Chart None When Vlookup formula should be applied? [Select all applicable] When data headers are in column To lookup the value Horizontally When data headers are in row To lookup the value vertically Slicer tool is used for which purpose? Filter Data Delete Data Add/Remove Data Edit Data None See the image and select the appropriate cell reference type applied in cell E3 with reference to H3. None of the given Absolute Reference Relative Reference Mix Reference None Select appropriate cell formats available in Excel. All of them Number Text Currency None Which function to be used to format cell based on given condition? Format Painter Automatic Cell Formatting Format Painter & Conditional Formatting Conditional Formatting None What is the keyboard shortcut key to lock cell references in a formula? F2 F4 CTRL + F2 CTRL + F None What is the keyboard shortcut key to open "Save AS" dialog box? F12 CTRL + S SHIFT + S CRTL + SHIFT + S None Which is the principle of Pareto Chart? 80/20 Rule 10/90 Rule 20/80 Rule 90/10 Rule 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
