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 How many arguments are there in Vlookup function? 2 3 4 1 None Select the formula to derive sum of all the data points which are higher than 60 =max(data_range,”criteria”) =sumif(data_range,”criteria”) =sum(max(70)) =large(data range, k) None How are data organised in a spreadsheet? Height and width Rows and columns None See the image and select appropriate option Status Bar Cell Address None of the given Formula Bar None Is it possible to report Pivot Table in different worksheet? No Yes None Histogram is used _______________. [Select all applicable] To prioritise data into Category To Organise and display data To check cumulative effect of Category To arrange data in Category What is the shortcut key of Flash Fill? CTRL + F SHIFT + F SHIFT + E CTRL + E None Which of the following features is not under the Data ribbon? Data Validation Text to Columns PivotTable What-If Analysis None Select all Advantages of Excel. Third Party support Free to use Effective Data visualization Easy & quick formatting Which of the following Excel features allow to select all cells that are blanks? CountA Go To Special Count Paste Special None Which function to be used to format cell based on given condition? Conditional Formatting Automatic Cell Formatting Format Painter & Conditional Formatting Format Painter None What type of chart is useful for prioritizing the project or problem? [Select Most appropriate] Line Chart Pareto Chart Pie Chart Column Chart None Bin Interval is pre-requirement to perform Histogram via Data Analysis Tool. Yes No None Which type of Dashboard is widely used by Senior Level Management? Operational Dashboard Analytical Dashboard Strategic Dashboard Tactical Dashboard None What is the shortcut key to convert raw data into Excel Table? [Select all applicable] SHIFT + L SHIFT + T CTRL + T CTRL + L How many vertical axis are there in Pareto Chart? 3 1 2 0 None Can we delete all worksheet from workbook? Yes No None What is the keyboard shortcut key to lock cell references in a formula? F4 CTRL + F F2 CTRL + F2 None What is the result of NOW() function? It return current Date and Time It returns current Date None of these It return current Time None Conditional Formatting option is available under _________ tab? Data Design Insert Home 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
