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