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 of Flash Fill? SHIFT + E CTRL + E SHIFT + F CTRL + F None Select appropriate cell formats available in Excel. Text Number All of them Currency None Is it possible to customize Error Alert message in Data Validation? Depends on Objective Yes No None What is the result of NOW() function? It returns current Date None of these It return current Date and Time It return current Time None Which of the following Excel features allow to select all cells that are blanks? Count CountA Go To Special Paste Special None Can we delete all worksheet from workbook? No Yes None Can Pivot table be reported in Existing worksheet ONLY? Yes No None Select right path to activate "Data Analysis Tool Pack" Customize Ribbon File-->Options-->add-ins-->Data Analysis Tool-->Go-->OK C:programm:excel:data analysis tool Data Tab-->Analysis Section-->Data Analysis Tool None Histogram is used _______________. [Select all applicable] To prioritise data into Category To arrange data in Category To check cumulative effect of Category To Organise and display data See the image and select the appropriate cell reference type applied in cell E3 with reference to H3. Absolute Reference None of the given Mix Reference Relative Reference None Which type of Dashboard is widely used by Senior Level Management? Tactical Dashboard Operational Dashboard Strategic Dashboard Analytical Dashboard None What is the shortcut key to convert raw data into Excel Table? [Select all applicable] SHIFT + T CTRL + T CTRL + L SHIFT + L What TRIM function does? Remove space before /after number Cut the cell content Remove space before text Remove all spaces except single space between word None How are data organised in a spreadsheet? Rows and columns Height and width None Which Excel tool is use to create drop-down list Data Validation Tool Sorting Option Filter Option All of them None How many arguments can be there in "NestedIF" functions? More than Two One Two None of the given None Slicer tool is used for which purpose? Edit Data Filter Data Delete Data Add/Remove Data None Conditional Formatting option is available under _________ tab? Insert Home Data Design 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 See the image and select appropriate option Status Bar None of the given Cell Address Formula Bar 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
