Excel Quiz 55 Posted on April 24, 2022December 3, 2022 by Vijay A. Verma Quiz 55 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 Following formula can be used to sum natural numbers from 1 to 10 =SUM(SEQUENCE(10)) =SUM(ROW(1:10)) All options =SUM(COLUMN(A1:J1)) 2 / 10 What does Double Underscore/Underline format denote in Excel from accounting purpose? Grand Total Most important information Sub Total Total in a pivot table 3 / 10 How many rows are possible in a worksheet? 2^10 2^16 2^20 2^22 4 / 10 Which is a valid formula in Excel? 45&9 45**9 45%9 45//9 5 / 10 What is the name of an intersection between a column and a row in Excel? Cell Grid Rectangle Range 6 / 10 What would be the answer for following =8+5*4-6/3 12.67 50 4.96 26 7 / 10 Which is not a valid chart type in Excel? Waterfall Radar Scatter Infograph 8 / 10 Which is not a reporting format in pivot table? Modern Outline Compact Tabular 9 / 10 Which function will you use to retrieve current time? CURRENTTIME() TODAY() CURTIME() NOW() 10 / 10 What is the difference between COUNT and COUNTA? COUNT counts those cells in a range which are not blanks whereas COUNTA counts all cells whether blank or not COUNT counts those cells in a range which have numbers and COUNTA counts all blank cells No difference COUNT counts those cells in a range which have numbers and COUNTA counts all non-blank cells whether numbers or not. Your score is LinkedIn Facebook Twitter Retake quiz Exit
