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