Excel Quiz 19 Posted on August 22, 2015September 25, 2021 by Vijay A. Verma Quiz 19 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 would be the answer for following - =ADDRESS(3,5,3) E$3 E3 $E$3 $E3 2 / 10 What is the type of this chart? Scatter Area Column Peak 3 / 10 In below picture, what would be the answer for =SUM(OFFSET(A1,3,1,,3)) 78 83 53 77 4 / 10 What are the lines in column F called? Line Drawings Slicers Sparklines Line Charts 5 / 10 In the below picture, what would be the answer for =SUMIF(B2:B8,"<30") 65 52 0 6 6 / 10 In the below picture, what would be the answer for =SUM(INDEX(B2:B8,5):INDEX(D2:D8,5)) 53 93 83 52 7 / 10 Below formula is called =SUM(Sheet2:Sheet6!C1) Absolute Formula Mixed Formula 3D Formula 2D Formula 8 / 10 Protect Sheet is under which tab? Formula View Data Review 9 / 10 If A1 contains "Vijay", what would be the answer for =N(A1) #N/A 0 Vijay Blanks 10 / 10 In the below picture, what would be the answer for =INDEX(A1:E8,5,3) 49 47 29 31 Your score is LinkedIn Facebook Twitter Retake quiz Exit
