Computer Applications for Business Study

Computer Applications for Business Week 7 Assignment

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

oFormat the column headings to be bold.

oIn Cell A14 put your name and GID number

  • Save workbook before filters as

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,

  • 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
  • File three Saved after Filter B. Save as
  • File four– Saved after Filter C. Save as
  • File five– Saved after Filter D. Save as

Grading Criteria
Maximum Points
Create workbook table with correct
Column headings bold 5
Added two rows of data 10
Filter A:all inventory items
with more than 10 in stock
Filter B: all
inventory items from the manufacturer, Boles
Filter C: all
inventory items under $100
D:all inventory items with 5 or less in stock and a list price of
less than $300
Cell A14 – name and GID number 10
Override for incorrect
file type, template used or incorrect content

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
Need assignment help? You can contact our live agent via WhatsApp using +1 718 717 2861

Feel free to ask questions, clarifications, or discounts available when placing an order.
  +1 718 717 2861           + 44 161 818 7126           [email protected]
  +1 718 717 2861         [email protected]