Excel Quiz 2 Posted on November 15, 2014September 24, 2021 by Vijay A. Verma Quiz 2 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 In Excel, when do you get #Div/0! error? When you divide a number by 0 When you add inifinity to a number When you multiply a character with 0 The error is never encountered in Excel. 2 / 10 You can't create header / footer in Excel. FALSE TRUE 3 / 10 What is the answer for the formula =ROWS(2:10) 8 2 10 9 4 / 10 The cell A1 contains First Name Last Name (for exmaple Vijay Verma), then what does following formula do =LEFT(A1,FIND(" ",A1)-1) The answer is Blank Removes space between First Name and Last Name Extracts Last Name Extract First Name 5 / 10 Which of the following is Absolute Address? A$2 A2 $A2 $A$2 6 / 10 The largest date allowed for calculation in Excel is 31-Dec-2100 1-Jan-2199 31-Dec-2099 31-Dec-9999 7 / 10 The default file format in Excel 2007 and onwards is .xls .csv .xlsx .xlm 8 / 10 What does shortcut CTRL+U do? Underlines the cell content or removes underlining if cell content already has underlining In Excel, there is no shortcut CTRL+U It creates a Union of cells selected It will make the cell Universal 9 / 10 Answer for =ROUNDDOWN(15.486,1) is 15.4 16.4 15.5 16 10 / 10 What is the answer for following formula =SUM(B:C 3:3) 0 57 17 39 Your score is LinkedIn Facebook Twitter Retake quiz
