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 What is XLTX file type? Excel binary file Excel template file without macro Excel template file with macro There is no such file type in Excel. 2 / 10 A formula in a cell can be started with # + ? - 3 / 10 In general, pie chart should be used When data is normally distributed When % distribution has to be shown When the difference between smallest and largest data is very huge When most of the data is 0 4 / 10 Referring to below picture, what would be the answer for =HLOOKUP("A124",$B$1:$H$2,2,0) F #N/A B D 5 / 10 Scatter chart can not be created in Excel No Yes 6 / 10 Shift+Tab will move cursor from Bottom to Top Top to Bottom Left to Right Right to Left 7 / 10 Referring to below picture, what would be the answer for =VLOOKUP("A127",$A$1:$B$8,2,0) #N/A A127 E Blanks 8 / 10 To put 1/2 (i.e. 0.5 as a fraction) Type 0, press space bar and then 1/2 Type 0 and then 1/2 Excel doesn't offer this capability Press space bar and type 1/2 9 / 10 Shortcut CTRL+Home does following Moves the cursor to cell A1 Doesn't do anything Moves the cursor to Z1 Selects all visible cells 10 / 10 To display current time, following can be used =curtime() =today() =time() =now() Your score is LinkedIn Facebook Twitter Retake quiz Exit
