Excel Quiz 31 Posted on March 6, 2016September 26, 2021 by Vijay A. Verma Quiz 31 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 If A1 contains 14.567, following formula can be used to extract decimal portion i.e. 0.567 =DECIMAL(A1) =MOD(A1,1) =SUMIF(A1) =DEC2OCT(A1) 2 / 10 If cell A1 contains 14.567, to extract the integer part, following formula can be used =INT(A1) =TRUNC(A1) =A1-MOD(A1,1) All of the above 3 / 10 Which is not a valid Power product in Excel? Power Chart Power Pivot Power Map Power Query 4 / 10 Which is not a chart type present in Excel? Pie Chart Brick Chart Clustered Column Chart Bubble Chart 5 / 10 To find square root of cell A1 which formula can be used =SQRT(A1) =A1^(1/2) =POWER(A1,1/2) All of the above 6 / 10 The entire Excel sheet can not be printed in one page TRUE FALSE 7 / 10 Following is not a way to fill cells in Excel Drag the cell Use fill option Flash Fill Define Name 8 / 10 Which is not an in-built functionality in Excel? Remove Duplicates Data Scraping Data Validation What-if Analysis 9 / 10 What would be the answer for following formula if A1 = 14.567 ? =MROUND(A1,3) 14.6 14.57 15 14.567 10 / 10 Maximum zoom possible in a worksheet is 500% 400% 200% 800% Your score is LinkedIn Facebook Twitter Retake quiz Exit
