You have a spreadsheet containing the sales figures for every sale that has taken place in your organization. The spreadsheet includes the sales person's name, the customer's name, the date of the sale, the amount of the sale, as well as the highest and lowest priced items from the sale.
Your supervisor would like to see the sales figures arranged by total sales and then sales person. How can you rearrange the figures to accomplish her request?

What will be an ideal response?


Convert the range of data to a table and then sort the information by first selecting the values and clicking the Sort & Filter button on the Home tab. Click Custom Sort, then sort total sales as the first level and sales person as the second level.

Computer Science & Information Technology

You might also like to view...

Within Muse, how do you access the Adobe hosting admin website?

What will be an ideal response?

Computer Science & Information Technology

You create a new Access report by clicking the Report Design icon in the Reports group in the Create tab of the Ribbon

Indicate whether the statement is true or false

Computer Science & Information Technology

A ________ is any disk drive, folder, or other place a user can store files and folders

A) location B) hard drive C) removable storage device D) USB

Computer Science & Information Technology

Which of the following statements sets the desired year in the onDateSet method?

A. set.C(Calendar.YEAR, year); B. c.set(Calendar.DateYear, year);  C. c.set(Calendar.YEAR, year);  D. Set(Calendar.YEAR); 

Computer Science & Information Technology