Excel Quiz 49 Posted on November 29, 2020September 26, 2021 by Vijay A. Verma Quiz 49 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 Which of the following is absolute address? $C$5 $AA$1000 $A$1 All of the above 2 / 10 Which is not part of Conditional Formatting? Icon Sets Data Bars Color Scales Custom Icons 3 / 10 Power Pivot is available in which version of Excel 2016 / 365? Office Professional 2016 Office 365 Pro Plus Excel 2016 standalone All of the above 4 / 10 The programming language used in Excel is called .NET VB VBE VBA 5 / 10 Which chart is not present in Excel? Gantt Scatter Bubble Area 6 / 10 If your contains First Name Last Name, then which of the formula can be used to extract first name? Say cell A1 = "John Doe" then which formula will extract John? =LEFT(A1,SEARCH( ,A1)-1) =MID(A1,1,FIND( ,A1)-1) =REPLACE(A1,FIND( ,A1),LEN(A1),) All of the Above 7 / 10 Which of the following function can be used to extract Integer portion of a positive number? Say A1=4.78, then this function should extract 4 as the answer? =INT(A1) =TRUNC(A1) =ROUNDDOWN(A1,0) All of the above 8 / 10 The shortcut to insert a Hyperlink is CTRL+H CTRL+Y CTRL+K CTRL+L 9 / 10 Which number is generated by following function? =RANDBETWEEN(100,999) 100 999 99900 Any number between 100 and 999 both inclusive 10 / 10 Which is a volatile function in Excel? CELL INDEX VLOOKUP MATCH Your score is LinkedIn Facebook Twitter Retake quiz Exit
