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 Can Pivot table be reported in Existing worksheet ONLY? No Yes None Is it possible to report Pivot Table in different worksheet? Yes No None What TRIM function does? Cut the cell content Remove all spaces except single space between word Remove space before text Remove space before /after number None Which is the principle of Pareto Chart? 90/10 Rule 20/80 Rule 10/90 Rule 80/20 Rule None How are data organised in a spreadsheet? Height and width Rows and columns None Which function to be used to format cell based on given condition? Automatic Cell Formatting Format Painter Conditional Formatting Format Painter & Conditional Formatting None Select appropriate cell formats available in Excel. Currency Number Text All of them None Bin Interval is pre-requirement to perform Histogram via Data Analysis Tool. Yes No None Steps to remove gap between bins. Select Graph->Change Chart Style Select Graph->Chart Elements->Bar Width to "0" Select Graph->Format Series->Gap Width to "0" None What type of chart is useful for prioritizing the project or problem? [Select Most appropriate] Pareto Chart Column Chart Pie Chart Line Chart 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 When Vlookup formula should be applied? [Select all applicable] To lookup the value Horizontally When data headers are in row To lookup the value vertically When data headers are in column Which of the following Excel features allow to select all cells that are blanks? Paste Special CountA Count Go To Special None What is the shortcut key to Function Library? F3 CTRL + L SHIFT + F3 CTRL + F3 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 Which type of Dashboard is widely used by Senior Level Management? Analytical Dashboard Tactical Dashboard Operational Dashboard Strategic Dashboard None By which option Pivot Table headers can be change? None of the given By applying Show in outline form By selecting headers while creating pivot table By renaming Headers None What is the shortcut key of Flash Fill? SHIFT + F CTRL + E CTRL + F SHIFT + E None What is the keyboard shortcut key to open "Save AS" dialog box? CRTL + SHIFT + S F12 SHIFT + S CTRL + S None See the image and select the appropriate cell reference type applied in cell E3 with reference to H3. None of the given Absolute Reference Relative Reference Mix Reference 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
