Excel Quiz 9 Posted on April 11, 2015September 25, 2021 by Vijay A. Verma Quiz 9 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 If A1=johndoe@us.com What would be the answer for =RIGHT(A1,6) @us.com us.com @ u 2 / 10 Fill in the blanks - Add cells to the _ _ _ _ _ _ _ _ _ _ _ list to keep an eye on their values as you update other parts of the sheet. Forms Correl Forms Window Watch Window Fills Blanks 3 / 10 What would be the answer for =SMALL({11,20,45,67,2,98,45},3) 45 0 20 11 4 / 10 What would be answer for =COLUMNS($A:F) 0 A1 6 F1 5 / 10 Largest allowed positive number is 9.99999999999999E+307 10^100 9.9E+308 10^309 6 / 10 Personal.xlsb file doesn’t exist until you record a macro to it. TRUE FALSE 7 / 10 Excel file format to store macros XLSX XLSM CSV All Excel file formats can store macros 8 / 10 Fill in the blanks - This button is found under Data tab -Text to _ _ _ _ _ _ _ ROW COLUMN COLUMNS ROWS 9 / 10 If I am in cell E35 and press Home, which cell would it reach? E38 E1 A1 A35 10 / 10 If A1=johndoe@us.com What would be the answer for =LEN(A1) 0 11 10 14 Your score is LinkedIn Facebook Twitter Retake quiz Exit
