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