Excel Quiz 30 Posted on January 24, 2016September 25, 2021 by Vijay A. Verma Quiz 30 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 =RAND() Any number >=0 and <1 Depends upon system clock 3 Depends upon the seed value 2 / 10 Which one is not a sparkline? Column Trend Win / Loss Line 3 / 10 What would be the answer for =EOMONTH(DATE(2016,1,1),1) 1-Mar-2016 31-Jan-2016 29-Feb-2016 30-Jan-2016 4 / 10 Which are not in Conditional Formatting? Color Scales Clusters Data Bars Icon Sets 5 / 10 Sort in Excel is case-sensitive by default. FALSE TRUE 6 / 10 Hyperlinks to E Mail addresses can be created in Excel TRUE FALSE 7 / 10 Which of the following is a wrong statement? Word files can be opened in Excel ods file can be opened in Excel xml file can be opened in Excel Access Database files can be opened in Excel 8 / 10 The result for the following will not be TRUE or FALSE NOT AND OR IFERROR 9 / 10 What would be the answer for =N(3) #VALUE 0 #NAME? 3 10 / 10 Maximum number of characters in Header / Footer 128 64 255 512 Your score is LinkedIn Facebook Twitter Retake quiz Exit
