Excel Quiz 12 Posted on May 16, 2015September 25, 2021 by Vijay A. Verma Quiz 12 This is a general quiz to test your Excel knowledge. There are a total of 10 questions to answer. To pass, you need to answer at least 6 questions correctly. Please fill in your Name & Email to take the Quiz (Name and E Mail are not shared with anybody else. E Mail is used to mail the pdf certificate to you when you pass) 1 / 10 Scatter chart can not be created in Excel No Yes 2 / 10 Referring to below picture, what would be the answer for =VLOOKUP("A127",$A$1:$B$8,2,0) A127 E #N/A Blanks 3 / 10 To display current time, following can be used =curtime() =now() =time() =today() 4 / 10 Referring to below picture, what would be the answer for =HLOOKUP("A124",$B$1:$H$2,2,0) #N/A F B D 5 / 10 A formula in a cell can be started with + # ? - 6 / 10 Shortcut CTRL+Home does following Selects all visible cells Moves the cursor to cell A1 Doesn't do anything Moves the cursor to Z1 7 / 10 In general, pie chart should be used When % distribution has to be shown When the difference between smallest and largest data is very huge When most of the data is 0 When data is normally distributed 8 / 10 To put 1/2 (i.e. 0.5 as a fraction) Type 0, press space bar and then 1/2 Press space bar and type 1/2 Type 0 and then 1/2 Excel doesn't offer this capability 9 / 10 Shift+Tab will move cursor from Right to Left Left to Right Bottom to Top Top to Bottom 10 / 10 What is XLTX file type? Excel template file without macro Excel binary file Excel template file with macro There is no such file type in Excel. Your score is LinkedIn Facebook Twitter Retake quiz Exit
