Excel Quiz 42 Posted on December 9, 2018September 26, 2021 by Vijay A. Verma Quiz 42 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 Which error will you get if you try to enter following formula - =VLOOKUUP(A1,L2:N1000,2,0) #NAME? #DIV/0! #N/A #REF 2 / 10 If A1 has a number in text format, which of the below can be used to convert this to a number in number format? =A1+0 =A1-0 =--A1 All of above 3 / 10 What is the expansion of VBA? Visual Basic for Apps Visual Basic for Application Visual Basic for Excel Based Applications Visual Basic .NET 4 / 10 What is the answer for following if A1: = Barack Hussein Obama =REPLACE(A1,FIND(" ",A1),LEN(A1),"") Extracts First and Last Name Extracts middle name Extracts last name Extracts first name 5 / 10 In which tab, Conditional Formatting is found apart from Home tab? Data Review Formulas In no other tab, only in Home tab 6 / 10 If A1: = 15-Jan-2016, then what would be the answer for =TEXT(A1,"mmmmm") January J Jan Will give error 7 / 10 Which is the best chart in case you want to show percentage distribution of various categories where sum is 100%? Column chart Stacked column chart 100% Stacked column Pie chart 8 / 10 What does SHIFT+Spacebar do? Highlights the entire sheet Highlights the cell Selects entire row Selects entire column 9 / 10 SHIFT+F2 is shortcut for Inserting a comment Delete a comment Jump to the previous comment Jump to the next comment 10 / 10 Which Excel command / tool to be used when you want to keep an eye on changing cells when you update your sheet? Trace Dependents Show Formulas Watch Window Trace Precedents Your score is LinkedIn Facebook Twitter Retake quiz Exit
