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 What does SHIFT+Spacebar do? Highlights the entire sheet Highlights the cell Selects entire row Selects entire column 2 / 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 3 / 10 If A1: = 15-Jan-2016, then what would be the answer for =TEXT(A1,"mmmmm") January J Jan Will give error 4 / 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 5 / 10 SHIFT+F2 is shortcut for Inserting a comment Delete a comment Jump to the previous comment Jump to the next comment 6 / 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 7 / 10 What is the expansion of VBA? Visual Basic for Apps Visual Basic for Application Visual Basic for Excel Based Applications Visual Basic .NET 8 / 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 9 / 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 10 / 10 In which tab, Conditional Formatting is found apart from Home tab? Data Review Formulas In no other tab, only in Home tab Your score is LinkedIn Facebook Twitter Retake quiz Exit
