Excel Quiz 28 Posted on December 27, 2015September 25, 2021 by Vijay A. Verma Quiz 28 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 is not a functionality in Excel Slicer AutoSum Apply filter to find out duplicate records Watch Window 2 / 10 SUBSTITUTE is case-sensitive FALSE TRUE 3 / 10 The intersection of row and column is a Border Cell Height Width 4 / 10 Following is not present in Pivot Table areas Rows Header Values Columns 5 / 10 What type of line indicate a page break Dashed Line Zig zag line Dotted Line Solid Line 6 / 10 To search only a particular column Select the column and press CTRL Select a cell in the column Select that column Search can not be limited to only one column 7 / 10 The shortcut for Find and Replace is CTRL+H CTRL+R CTRL+M CTRL+F 8 / 10 Following is not a method to convert from Number to Text Concatenate a blank at the end of the Number Press F2 and then Enter Concatenate a blank in the front of the Number Use Text to Column Wizard 9 / 10 What would be the answer for =MOD(45,8) 3 0 5 1 10 / 10 Which of the following is wrong? The sheet tab can be copied The sheet tab can be colored. Width of sheet tab can be increased or decreased The sheet tab can be moved Your score is LinkedIn Facebook Twitter Retake quiz Exit
