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 See the image and select appropriate option Status Bar None of the given Cell Address Formula Bar None What is the shortcut key to convert raw data into Excel Table? [Select all applicable] SHIFT + L SHIFT + T CTRL + L CTRL + T How are data organised in a spreadsheet? Height and width Rows and columns None Can Pivot table be reported in Existing worksheet ONLY? No Yes None Which is the principle of Pareto Chart? 80/20 Rule 10/90 Rule 90/10 Rule 20/80 Rule None How many arguments are there in Vlookup function? 3 4 2 1 None Which Excel tool is use to create drop-down list Data Validation Tool Filter Option Sorting Option All of them None Descriptive Statistics provides _____________ of sample data. [Select all applicable] Statistical Summary of Data Hypothesis Testing Calculate Central Tendency & Measure of Dispersion Description of Data When Vlookup formula should be applied? [Select all applicable] To lookup the value Horizontally When data headers are in row When data headers are in column To lookup the value vertically What is the shortcut key of Flash Fill? CTRL + E SHIFT + E CTRL + F SHIFT + F None Which function to be used to format cell based on given condition? Format Painter & Conditional Formatting Format Painter Conditional Formatting Automatic Cell Formatting None Which is the correct formula to find difference between two times? =Text(Start Time - End Time) =Text(End Time - Start Time) =Text(End Time - Start Time,hh:mm:ss) =Text(End Time - Start Time,"hh:mm:ss") None Which type of Dashboard is widely used by Senior Level Management? Strategic Dashboard Operational Dashboard Analytical Dashboard Tactical Dashboard None What is the shortcut key to Function Library? SHIFT + F3 F3 CTRL + L CTRL + F3 None Which of the following Excel features allow to select all cells that are blanks? Paste Special Count Go To Special CountA None Is Vlookup & Hlookup Case Sensitive? No Yes None Bin Interval is pre-requirement to perform Histogram via Data Analysis Tool. No Yes None Select right path to activate "Data Analysis Tool Pack" Data Tab-->Analysis Section-->Data Analysis Tool C:programm:excel:data analysis tool File-->Options-->add-ins-->Data Analysis Tool-->Go-->OK Customize Ribbon None What type of chart is useful for prioritizing the project or problem? [Select Most appropriate] Line Chart Column Chart Pareto Chart Pie Chart None What is the keyboard shortcut key to lock cell references in a formula? F2 F4 CTRL + F CTRL + F2 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 Leave a Reply Cancel replyCommentEnter your name or username to comment Enter your email address to comment Enter your website URL (optional)