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]
Putting cells in order based on their contents is called____
A
Sorting
B
Filtering
C
Numbering
D
Identifying
Explanation: 

Detailed explanation-1: -When sorting information in a worksheet, you can rearrange the data to find values quickly. You can sort a range or table of data on one or more columns of data. For example, you can sort employees-first by department, and then by last name.

Detailed explanation-2: -In Excel, you can sort your table by one or more columns, by ascending or descending order, or do a custom sort.

Detailed explanation-3: -A text column can be sorted alphabetically (A-Z or Z-A). A number column can be sorted either from largest to smallest or from smallest to largest. A date and time column can alternatively be sorted from oldest to newest or from newest to oldest.

There is 1 question to complete.