USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Joan has created a spreadsheet that displays the sales of her employees. She would like to view only those employees with sales above $25, 000. How can she do this?
|
|
Sort ascending
|
|
|
Sort descending
|
|
|
Custom sort
|
|
|
Filter to show only $25, 000 or above with a number filter
|
Explanation:
Detailed explanation-1: -Select the Review tab, and then, in the Proofing section, select Workbook Statistics. You can also press CTRL+SHIFT+G. (Note that the CTRL+SHIFT+G shortcut won’t work in Excel for the web.) The Workbook Statistics dialog opens and displays counts and other information about the current worksheet and workbook.
Detailed explanation-2: -The name box is the box at left end of the formula bar that identifies the selected cell, chart item, or drawing object. The Name Box displays the cell reference of the active cell. The Name Box can also be used to assign names to cells or ranges of cells.
There is 1 question to complete.