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 What does Double Underscore/Underline format denote in Excel from accounting purpose? Total in a pivot table Grand Total Sub Total Most important information 2 / 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)) 3 / 10 Which is not a reporting format in pivot table? Outline Tabular Compact Modern 4 / 10 What would be the answer for following =8+5*4-6/3 4.96 12.67 50 26 5 / 10 What is the name of an intersection between a column and a row in Excel? Cell Range Rectangle Grid 6 / 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 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 7 / 10 Which is not a valid chart type in Excel? Waterfall Scatter Infograph Radar 8 / 10 Which function will you use to retrieve current time? CURRENTTIME() TODAY() CURTIME() NOW() 9 / 10 How many rows are possible in a worksheet? 2^16 2^22 2^10 2^20 10 / 10 Which is a valid formula in Excel? 45//9 45&9 45**9 45%9 Your score is LinkedIn Facebook Twitter Retake quiz Exit
