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 shortcut key to convert raw data into Excel Table? [Select all applicable] SHIFT + T CTRL + T SHIFT + L CTRL + L Select the formula to derive sum of all the data points which are higher than 60 =max(data_range,”criteria”) =sum(max(70)) =sumif(data_range,”criteria”) =large(data range, k) None Can Pivot table be reported in Existing worksheet ONLY? Yes No None Which type of Dashboard is widely used by Senior Level Management? Tactical Dashboard Operational Dashboard Analytical Dashboard Strategic Dashboard None What is the shortcut key of Flash Fill? CTRL + E SHIFT + E CTRL + F SHIFT + F None CTRL + D is short cut key for ____________. To Open dialog box Duplicate cell content To copy content of upper cell To Open Design Tab None By which option Pivot Table headers can be change? By applying Show in outline form By renaming Headers By selecting headers while creating pivot table None of the given None Which of the following features is not under the Data ribbon? Text to Columns Data Validation What-If Analysis PivotTable None Select all Advantages of Excel. Easy & quick formatting Third Party support Effective Data visualization Free to use See the image and select appropriate option Cell Address Status Bar Formula Bar None of the given None Which function to be used to format cell based on given condition? Conditional Formatting Automatic Cell Formatting Format Painter Format Painter & Conditional Formatting None What is the shortcut key to Function Library? CTRL + L F3 CTRL + F3 SHIFT + F3 None See the image and select the appropriate cell reference type applied in cell E3 with reference to H3. None of the given Relative Reference Absolute Reference Mix Reference None Select right path to activate "Data Analysis Tool Pack" Customize Ribbon Data Tab-->Analysis Section-->Data Analysis Tool File-->Options-->add-ins-->Data Analysis Tool-->Go-->OK C:programm:excel:data analysis tool None What is the keyboard shortcut key to lock cell references in a formula? F2 CTRL + F F4 CTRL + F2 None How are data organised in a spreadsheet? Height and width Rows and columns None When Vlookup formula should be applied? [Select all applicable] When data headers are in column To lookup the value Horizontally To lookup the value vertically When data headers are in row Can we delete all worksheet from workbook? Yes No None Is it possible to customize Error Alert message in Data Validation? Yes Depends on Objective No None Select appropriate cell formats available in Excel. All of them Number Text Currency 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
