FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?
A
Find & Select
B
Format Cell
C
Sort & Filter
D
Organize
Explanation: 

Detailed explanation-1: -Double-click any of the ribbon tabs or press CTRL+F1 to collapse the ribbon if you need to see more of your document. To see the ribbon again, just double-click any ribbon tab, or press CTRL+F1.

Detailed explanation-2: -Deleting Columns and Rows Click the Home tab of the Ribbon. Click the down arrow on the Delete button in the Cells group. Click either the Delete Sheet Columns or the Delete Sheet Rows option.

Detailed explanation-3: -The filter tool gives you the ability to filter a column of data within a table to isolate the key components you need. The sorting tool allows you to sort by date, number, alphabetic order and more. In the following example, we will explore the usage of sorting and filtering and show some advanced sorting techniques.

There is 1 question to complete.