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 What is the maximum column width in Excel? 1032 256 255 8.43 2 / 10 If A1="abc", then what would be the answer for =T(A1) abc 0 1 Blanks 3 / 10 Is .XLSX file smaller than .XLS, in general? True False 4 / 10 A1=1, A2=2, A3=3, A4=4, A5=5, then the answer for =SUMS(A1:A5) would be 15 0 #NAME? Error will come. 14 5 / 10 What is the answer for =COLUMN(Z1)? 1 26 It gives error. 0 6 / 10 What is the answer for =QUOTIENT(45,8) 4 5 0 3 7 / 10 Today is 15-Nov-14, what would be the answer for =TEXT(TODAY(),"mmmm") Sat Saturday Nov November 8 / 10 What is the significance of XFD in Excel? If you type it, you get admin rights in Excel. This is the last column in an Excel sheet. No significance. This is a variable which can be used universally. 9 / 10 A1="a" and B1="A". Then what would be the answer for =EXACT(A1,B1) TRUE FALSE Blanks 0 10 / 10 What is the type of the chart shown in the picture? Pie Chart Percentile Chart Column Chart Scatter Chart 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.