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