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 Is it possible to report Pivot Table in different worksheet? Yes No None What type of chart is useful for prioritizing the project or problem? [Select Most appropriate] Column Chart Pie Chart Line Chart Pareto Chart None By which option Pivot Table headers can be change? By renaming Headers By applying Show in outline form By selecting headers while creating pivot table 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 Bin Interval is pre-requirement to perform Histogram via Data Analysis Tool. No Yes None Which is the correct formula to find difference between two times? =Text(Start Time - End Time) =Text(End Time - Start Time,hh:mm:ss) =Text(End Time - Start Time) =Text(End Time - Start Time,"hh:mm:ss") None What is the shortcut key to Function Library? CTRL + L CTRL + F3 SHIFT + F3 F3 None Which function to be used to format cell based on given condition? Format Painter & Conditional Formatting Conditional Formatting Format Painter Automatic Cell Formatting None Descriptive Statistics provides _____________ of sample data. [Select all applicable] Description of Data Hypothesis Testing Statistical Summary of Data Calculate Central Tendency & Measure of Dispersion Select all Advantages of Excel. Easy & quick formatting Third Party support Free to use Effective Data visualization When Vlookup formula should be applied? [Select all applicable] When data headers are in column When data headers are in row To lookup the value vertically To lookup the value Horizontally CTRL + D is short cut key for ____________. Duplicate cell content To Open Design Tab To Open dialog box To copy content of upper cell None Can Pivot table be reported in Existing worksheet ONLY? Yes No None Is Vlookup & Hlookup Case Sensitive? No Yes None Which is the principle of Pareto Chart? 10/90 Rule 20/80 Rule 80/20 Rule 90/10 Rule None How many vertical axis are there in Pareto Chart? 2 0 3 1 None Histogram is used _______________. [Select all applicable] To arrange data in Category To Organise and display data To check cumulative effect of Category To prioritise data into Category How many arguments are there in Vlookup function? 4 2 1 3 None What is the keyboard shortcut key to open "Save AS" dialog box? CTRL + S CRTL + SHIFT + S SHIFT + S F12 None Which Excel tool is use to create drop-down list All of them Filter Option Sorting Option Data Validation 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 Leave a Reply Cancel replyCommentEnter your name or username to comment Enter your email address to comment Enter your website URL (optional)
