Microsoft Excel Set – 2 Leave a Comment / By Anil / May 29, 2023 Welcome to your Microsoft Excel Set - 2 1. Which feature is used to rotate the text diagonally or vertically of the selected cells in MS Excel? Orientation Text Layout Cell Orientation Text Flip 2. Which chart type is used to show trends over time and categories? Area Chart Bar Chart Hierarchy Chart Doughnut Chart 3. Under which menu, we can insert Header and Footer on the sheet? Insert Review Format Data 4. Which function is used to create a date with year, month, and day? DATEDIF() DATE() DATEVALUE() CURDATE() 5. Show/Hide Gridlines option is available in the ____ Menu. Page Layout Data Format Insert 6. The currently selected cell address is displayed in ____. Name Box Formula Bar Both A and B None of the above 7. Which function is used to match multiple values and returns the first match? IF() IIF() IFS() SWITCH() 8. What is the correct value of the function? =ROUND (1.9867,2) 1.99 1.98 1 1.90 9. Under which Tab, the chart options are available in MS Excel? Data Insert Review View 10. Steps for protecting a sheet by password in MS Excel? Under the Review Tab, Click on Protect Current Sheet Under Insert Tab, Click on Protect Sheet Under Data Tab, Click on Protect Sheet Under the Review Tab, Click on Protect Sheet 11. Which is not a Text function in MS Excel? CODE() CLEAN() CHAR() DB() 12. Which Excel function is used to get the discount rate for security? DISC() DISCOUNT() PERC() DSC() 13. What is the keyboard shortcut to insert a new sheet in the current workbook in MS Excel? Shift + F9 Shift + F10 Shift + F12 Shift + F11 14. Which chart type is used to visually compare values across a few categories? Area Chart Bar Chart Doughnut Chart Hierarchy Chart 15. Which option allows you to display all numbers which are less than 0 (negative numbers) in red color in MS Excel? Styling Compare Formatting Special Formatting Conditional Formatting 16. What is the keyboard shortcut to insert a new comment in a cell in MS Excel? F2 Ctrl + F2 Alt + F2 Shift + F2 17. Which chart type is used to show the proportions of a while? Hierarchy Chart Bar Chart Doughnut Chart Area Chart 18. Which function is used to get the location of text in a string in MS Excel? INDEX() STRINGSEARCH() FIND() SEARCH() 19. What is the correct value of the function? =ROUND (1.2345,2) 1.24 1.2 1.23 1.25 20. Which feature is used to wrap extra-long text into multiple lines in MS Excel? Word Wrap Letter Wrap Text Wrap Wrap Text 21. Which keyboard shortcut is used to apply 'Wrap Text' on the selected text? Ctrl + H + W Alt + W + H Alt + W Alt + H + W 22. The ____ function is used to convert to text in a number format in MS Excel. CONVERT() TEXT() NUM() CONVERTTEXT() 23. In MS Excel, 'Merge and Center' is used to ____. Combine and centre the content of the selected cell Concatenate the text of the two cells and returns the text Combine and centre the content of the current row None of the above 24. Which programming language is used to write a Macro in MS Excel? C C++ Visual Basic Java 25. Which function is used to remove extra spaces from the text in MS Excel? REMOVE() TRIM() TRUNC() All of the above Related Posts (You May Also Read):