FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Sorting is:A) Arranging the rows in a table or list of data in a new order according to the entries in one or more columnsB) Hiding nonmatching rows in a table or list of data according to the criterion or criteria you specifyC) Arranging data in columns with column headersD) Applying cell color, border, shading, and other formatting to data
A
A
B
B
C
C
D
D
Explanation: 

Detailed explanation-1: -Sorting is the process of arranging data into meaningful order so that you can analyze it more effectively. For example, you might want to order sales data by calendar month so that you can produce a graph of sales performance. You can use Discoverer to sort data as follows: sort text data into alphabetical order.

Detailed explanation-2: -Sort. Sorting allows the user to reorder rows by the contents of a column. This is a live continuous sort, and new rows that get added or rows that get edited will be resorted immediately after, and you will not be able to manually reorder rows. You can sort on multiple columns with multiple sort directions.

Detailed explanation-3: -Custom Sort-sorts data in multiple columns by applying different sort criteria.

Detailed explanation-4: -Types of sorting When sorting data, it’s important to first decide if you want the sort to apply to the entire worksheet or just a cell range. Sort sheet organizes all of the data in your worksheet by one column.

There is 1 question to complete.
Previous
Next