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