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 result of NOW() function? It return current Time It return current Date and Time None of these It returns current Date None Select the formula to derive sum of all the data points which are higher than 60 =sum(max(70)) =sumif(data_range,”criteria”) =large(data range, k) =max(data_range,”criteria”) None What is the shortcut key of Flash Fill? CTRL + F SHIFT + E CTRL + E SHIFT + F None See the image and select the appropriate cell reference type applied in cell E3 with reference to H3. Mix Reference None of the given Relative Reference Absolute Reference None By which option Pivot Table headers can be change? By selecting headers while creating pivot table By renaming Headers By applying Show in outline form None of the given None What is the keyboard shortcut key to lock cell references in a formula? F4 F2 CTRL + F2 CTRL + F None Which of the following Excel features allow to select all cells that are blanks? Count Go To Special CountA Paste Special None What type of chart is useful for prioritizing the project or problem? [Select Most appropriate] Pareto Chart Column Chart Line Chart Pie Chart None What is the shortcut key to convert raw data into Excel Table? [Select all applicable] CTRL + L CTRL + T SHIFT + L SHIFT + T Is Vlookup & Hlookup Case Sensitive? Yes No None Is it possible to customize Error Alert message in Data Validation? No Yes Depends on Objective None Which function to be used to format cell based on given condition? Conditional Formatting Format Painter & Conditional Formatting Automatic Cell Formatting Format Painter None What is the keyboard shortcut key to open "Save AS" dialog box? SHIFT + S CTRL + S CRTL + SHIFT + S F12 None Which Excel tool is use to create drop-down list Filter Option Sorting Option Data Validation Tool All of them None When Vlookup formula should be applied? [Select all applicable] To lookup the value Horizontally To lookup the value vertically When data headers are in row When data headers are in column Can Pivot table be reported in Existing worksheet ONLY? No Yes None CTRL + D is short cut key for ____________. Duplicate cell content To Open Design Tab To copy content of upper cell To Open dialog box None Which is the principle of Pareto Chart? 10/90 Rule 90/10 Rule 20/80 Rule 80/20 Rule None Bin Interval is pre-requirement to perform Histogram via Data Analysis Tool. No Yes None Slicer tool is used for which purpose? Add/Remove Data Delete Data Edit Data Filter 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
