Excel Quiz 27 Posted on December 13, 2015September 25, 2021 by Vijay A. Verma Quiz 27 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 To remove comma from a given range say A1:A100, following can be done Select your range > CTRL+H > put , without quotes in Find What: box > Replace All Put following formula in B1 and drag down till B100 =REPLACE(A1,,,) None of the above Both 1st and 2nd 2 / 10 Following function can be used to find the last date of the month EDATE LASTDM MONTH EOMONTH 3 / 10 Following is not part of the Review tab Spelling Grammar Protect Sheet Thesaurus 4 / 10 Which is not a chart provided by Excel Radar Gantt Doughnut Bubble 5 / 10 To count the number of columns, following functions can used =ROWS(COLUMNS()) =COLUMN(1:1) =COLUMNS(1:1) =COLUMNS(ROW()) 6 / 10 Following is not a choice to format Font Blinking Font Type Font Style Color 7 / 10 To find maximum in a data range say A1:A100, you can use following formula =MAX(A1:A100) =LARGE(A1:A100,1) =AGGREGATE(14,4,A1:A100,1) All of the above 8 / 10 To perform Fuzzy Lookup in Excel Download Fuzzy Lookup Add-in provided by Microsoft Use the function FLOOKUP Fuzzy Lookup can not be done in Excel None of the above 9 / 10 To convert from a Text number to Numeric Number which is in cell A1, following can be used =NUMBERVALUE(A1) =ISNUMBER(A1) =CONVERT(A1,text,number) None of the above 10 / 10 Go to Special can be reached though ALT+EGS Shortcut CTRL+G > Special Home tab > Find & Select > Go to Special All of the above Your score is LinkedIn Facebook Twitter Retake quiz Exit
