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