Excel Quiz 3 Posted on November 29, 2014September 24, 2021 by Vijay A. Verma Quiz 3 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 If A1="abc", then what would be the answer for =T(A1) 1 0 Blanks abc 2 / 10 What is the maximum column width in Excel? 8.43 256 1032 255 3 / 10 What is the type of the chart shown in the picture? Column Chart Percentile Chart Pie Chart Scatter Chart 4 / 10 Today is 15-Nov-14, what would be the answer for =TEXT(TODAY(),"mmmm") November Sat Saturday Nov 5 / 10 Is .XLSX file smaller than .XLS, in general? False True 6 / 10 A1="a" and B1="A". Then what would be the answer for =EXACT(A1,B1) 0 TRUE FALSE Blanks 7 / 10 What is the significance of XFD in Excel? No significance. If you type it, you get admin rights in Excel. This is the last column in an Excel sheet. This is a variable which can be used universally. 8 / 10 What is the answer for =QUOTIENT(45,8) 5 3 0 4 9 / 10 What is the answer for =COLUMN(Z1)? 1 26 0 It gives error. 10 / 10 A1=1, A2=2, A3=3, A4=4, A5=5, then the answer for =SUMS(A1:A5) would be 15 14 #NAME? Error will come. 0 Your score is LinkedIn Facebook Twitter Retake quiz
It is a very long time since this quiz appeared, but I first see it now. You say that =QUOTIENT(45,8) = 4 Have you tested that? Reply
It is a very long time since this quiz appeared, but I first see it now.
You say that =QUOTIENT(45,8) = 4
Have you tested that?
Thanks Hans for pointing out the error. The same has been corrected.