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