Computer Applications for Business Study

Computer Applications for Business Week 7 Assignment

MS
Excel: Querying (Web)

Week 7 Assignment

Start with a new spreadsheet in or
installed version of Microsoft Excel with no template applied. A template is
not allowed for assignment.

” v:shapes=”Picture_x0020_1″ style=”box-sizing: border-box; outline: none; border: 0px; vertical-align: middle;”>

A local company would like to be able to search their inventory in
an easy manner. They have given you data in table above, then:

• Create the table above in excel.

oAdd two more rows of inventory data of your
choice.

oFormat the column headings to be bold.

oIn Cell A14 put your name and GID number

• Save workbook before filters as
  CS155Week7LastnameFirstName.

oEnsure you use your
ownlastnameandfirstnamein filename.

• Perform the following filters.

oAll inventory items with more than 10 in stock.

• Save as CS155Week7ALastnameFirstName

oAll inventory items from the manufacturer,
Boles.

• Save as CS155Week7BLastnameFirstName

oAll inventory items under $100.

• Save as CS155Week7CLastnameFirstName

oAll inventory items with 5 or less in stock and
a list price of less than $300.

• Save as CS155Week7DLastnameFirstName

Five files will be attached and submitted in one submission

• File one Saved before beginning extractions.
  Save as CS155Week7LastnameFirstName
• File twoSaved after Filter A. Save as
  CS155Week7ALastnameFirstName
• File three Saved after Filter B. Save as
  CS155Week7BLastnameFirstName
• File four– Saved after Filter C. Save as
  CS155Week7CLastnameFirstName
• File five– Saved after Filter D. Save as
  CS155Week7DLastnameFirstName