Excel Quiz 1 Posted on November 2, 2014September 24, 2021 by Vijay A. Verma Quiz 1 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 To extract integer potion of a decimal number such as 34.95 contained in A1, which formula to use - =FRACTION(A1) None of the Above =ROUND(A1,2) =INT(A1) 2 / 10 Cell A1 contains a number in character format, to convert this into number format =DEC(A1) =--A1 =DECIMAL(A1) =A1** 3 / 10 The short cut for Format Cell is CTRL+F CTRL+C CTRL+FC CTRL+1 4 / 10 To sum a list in a column say A1:A100 where hidden rows should be ignored, the formula to be used =SUMIF(A1:A100,"Hidden") =SUBTOTAL(109,A1:A100) =SUMPRODUCT(A1:A100 = "Hidden") =SUM(A1:A100) 5 / 10 COUNT function does what? Counts all cells containing numbers in a range Counts all non blank cells in a range Counts all texts Counts all cells in a range 6 / 10 To start a formula in a cell, which character do you use @ % * = 7 / 10 CSV stands for Container Substitute Value None of the Above Comma Separated Values Comma Severe Volatile 8 / 10 Pivot table is not a feature of Excel True False 9 / 10 CTRL+T does what? Inserts a table Converts a range into table Fills the column with a particular colour Inserts 10,000 in a column 10 / 10 The character code for "Z" is 78 26 99 90 Your score is LinkedIn Facebook Twitter Retake quiz Exit
