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 has asked you to print out a version of the spreadsheet that only contains sales that are greater than $25,000.00. How can you accomplish his request?

What will be an ideal response?


Click the drop down list that will appear at the top of the column containing the total sales, click the (Select All) button to remove all check marks, then select Number Filters, and then Greater Than. In the Custom AutoFilter dialog box, specify the amount and click OK. Now you can print your document containing only those sales that interest your supervisor.

Computer Science & Information Technology

You might also like to view...

Add a field to the SlideShow class to hold the title and modify the show method to first show a blank picture with the title on it.

What will be an ideal response?

Computer Science & Information Technology

Shapes can be added to a SmartArt.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

One person is selected at random from a class of 13 males and 11 females. Find the odds against selecting a female.

A. The odds against selecting a female are 13 : 11. B. The odds against selecting a female are 13 : 24. C. The odds against selecting a female are 11 : 24. D. The odds against selecting a female are 1 : 1. E. The odds against selecting a female are 11 : 13.

Computer Science & Information Technology

Which of the following motherboards would fit in an ATX case?

A. BTX B. ITX C. Ultra ATX D. Micro ATX

Computer Science & Information Technology