Describe the different ways you could sort data in a table and how you would do so.

What will be an ideal response?


Rows in a table can be sorted in alphabetical or sequential order, based on the data in one or more columns. To sort data in a table you specify which column(s) to sort by, what type of data you are sorting, and the sort order. You can sort data in ascending order, which lists data alphabetically or sequentially (A-Z, 0-9, or earliest to latest), or in descending order, which lists data in reverse alphabetical or sequential order (Z-A, 9-0, or latest to earliest).Click the Sort command in the Data group on the Table Tools Layout tab to open the Sort dialog box. Choose which column(s) to sort by, choose the type of information you are sorting (text, numbers, or dates), and set the sort order (ascending or descending). Finally, select secondary and tertiary sort criteria if you are sorting by multiple columns.

Computer Science & Information Technology

You might also like to view...

If you want to display an image without any text around it you should nest it inside of which tag(s)?

a.

b.

c. d.

Computer Science & Information Technology

The _______ command is used to troubleshoot a remote network fault and to see the path a packet takes through several networks

Fill in the blank(s) with correct word

Computer Science & Information Technology

When you use an object in your program, you create a(n) ____________________ of the class of the object.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

You can select multiple paragraphs by using the ____ key(s) repeatedly.

A. CTRL+END B. CTRL+A C. SHIFT+HOME D. CTRL+SHIFT+DOWN ARROW

Computer Science & Information Technology