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