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.
You might also like to view...
What protocol resolves a computer's IPv4 address to its physical, or Media Access Control (MAC) address?
A. User Datagram Protocol (UDP) B. Dynamic Host Configuration Protocol (DHCP) C. Address Resolution Protocol (ARP) D. Domain Name System (DNS)
Which of the following demonstrates that technology alone is not the answer to network security issues?
A) A user manually opens an e-mail attachment and releases a virus. B) A user keeps passwords on a Post-it note attached to their computer monitor. C) The network server is located in a room to which most employees have access. D) All of the above