In MS Excel 365, when you right-click on a cell and select 'Filter,' which of the following options is NOT visible?
MS Excel 365 lacks a feature to filter data based on cell height. Filters focus on attributes like value, color, and font to streamline data analysis.
Important Key Points:
1. Filters enable quick sorting and data organization based on selected attributes.
Knowledge Booster:
· Cell color: Filters rows sharing a specific background color.
· Cell font: Targets rows with a particular font color.
· Cell values: Common filter for rows sharing identical content.
English
80 Questions
160 Marks
60 Mins English English20 Questions40 Marks12 Mins English English80 Questions160 Marks60 Mins EnglishWhich element of the MS Excel interface displays the name of the currently active cell or the selected range of cells?
Which of the following methods is the quickest way to open an existing MS Excel spreadsheet?
Which keyboard shortcut opens the Print dialog box in MS Excel 365?
If you want to save a workbook in MS Excel 365 so that only viewing is allowed and editing is restricted, which feature should you use?
Which keyboard shortcut is used to save an MS Excel workbook?
Which of the following scenarios would most effectively necessitate the use of a three-dimensional reference within an MS Excel formula?
What is the primary purpose of the 'Formula Bar' in MS Excel?
Which of the following is the keyboard shortcut to save an MS Excel workbook?
Which of the following is an example of a mixed cell reference in MS Excel?
Suggested Test Series
Suggested Test Series
