Excel Quiz 41 Posted on June 25, 2018September 26, 2021 by Vijay A. Verma Quiz 41 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 result of SIGN(-23.95)? negative - -1 minus 2 / 10 If A1 has date, then what does the following formula give =ROUNDUP(MONTH(A1)/3,0) It will give a date which is 3 months less than the date given in A1 It will give a date which is 3 months more than the date given in A1 It will give a date which is 3 years more than the date given in A1 In which quarter the date falls in 3 / 10 Which is not true about FIND? FIND is case sensitive FIND can have wild card searches You can specify Starting Number in FIND FIND returns the number of the starting position of the first text string from the first character of the second text string 4 / 10 If A1=5-Aug-16, then what would be the answer for =EDATE(A1,-3) 2-Aug-16 5-May-16 5-Aug-19 5-Nov-16 5 / 10 Which function can be used to extract the integer portion of a decimal number? INT TRUNC Both 1 & 2 Neither 1 nor 2 6 / 10 To find the distance between two states in a Grid like below, what should be used LOOKUP INDEX MATCH INDEX and MATCH Combination 7 / 10 Which is not a sparkline? Line Columns Win/Loss Scatter 8 / 10 Which function to use to calculate EMI (Equated Monthly Installment) of a loan? FV PMT NPER NPV 9 / 10 Which function to use to find the salary of a person if the name of person is given VLOOKUP MATCH INDEX HLOOKUP 10 / 10 What is the result of the following formula =COLUMN(D3:G100) 6 7 4 3 Your score is LinkedIn Facebook Twitter Retake quiz Exit
