USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Find & Select
|
|
Format Cell
|
|
Sort & Filter
|
|
Organize
|
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.