Expert Answer :QM 160 introduction to data analytic

  

Solved by verified expert:Here is Case 4 about Excel i need it to be solve from step 1 to 18. i did couple of thing already on this case so i just need it to be solve. the Excel sheet will be down in the attachment with the instruction.
img_7323.jpg

img_7324.jpg

Don't use plagiarized sources. Get Your Custom Essay on
Expert Answer :QM 160 introduction to data analytic
Just from $10/Page
Order Essay

cairn_camping.xlsx

excel_2016_module_3_case_4_instructions_1_.docx

Unformatted Attachment Preview

Cairn Camping Supplies
Author
Date
Purpose
Ali Almagahwi
3/14/2018
To create an order form for orders made at
Cairn Camping Supplies
Cairn Camping Supplies
105 East Commerce Way
Fort Smith, AK 72913
(479) 555-8118
Product List
Customer
Order Number
Order Date
Street
City
State
ZIP
Phone
Dixie Kaufmann
Shipping Address
414 Topeak Lane
Fort Smith
AK
72914
(479)555-2081
Delivery Options
Delivery Type
3 Day
Deliver Days
Est. Delivery Date
Delivery Type
Standard
3 Day
2 Day
Overnight
381
4/5/2018
Surcharge
Tax Rate
Item ID
P4981
t7829
led7331
sb8502
Name
Foam Pad
4 Person Tent
LED Rechargeable Lantern
Sunblock SPF 30 (Hiking Size)
Price
Est. Delivery Days
12.95
15.95
23.95
38.75
5
3
2
1
3.70%
Qty
Charge
2
3
4/10/2018
Subtotal
Sales Tax
Shipping & Handling
Shipping & Handling Discount
TOTAL
Item ID
bb7117
bl2815
Name
Blister Patches
Boot Laces (Medium)
Price
$
9.95
$
14.95
bl6638
Snowboard Leash
$
5.95
br9002
fa8442
fa8401
gps1015
gps1587
Bug Repellent (Deep Woodes)
First Aid Kit (Pack Size)
First Aid Kit (Large)
Zendo GPS meter
GPS Tracking Unit
$
$
$
$
$
7.55
11.95
21.73
82.81
112.45
led7331
LED Rechargeable Lantern
$
38.95
led7991
LED Rechargeable Kit
$
21.94
p5148
Self-Inflating Pad
$
37.25
p4981
Foam Pad
$
29.15
pj5199
Insulated Jacket Women’s
$
175.22
pw6558
Insulated Pants Women’s
$
85.87
sb2818
Down Sleeping Bag
$
178.21
sb3089
Arctic Sleep Bag
$
234.89
sb5317
Attack Snowboard Women’s
$
148.21
sb5501
Attack Snowboard Men’s
$
148.21
sb6601
Solar Battery Recharging Unit
sb8108
Solar Battery Panels
sb8502
Sunblock SPF 30 (Hiking Size)
$
$
$
32.55
48.78
12.32
sg8128
Polarized Snow Goggles
$
39.45
sh5591
Snow Helmet Women’s
$
87.15
sh8810
Snow Helmet Men’s
$
87.15
sp5588
Snowshoes Pair
$
63.21
t7815
2 Person Tent
$
295.15
t7829
4 Person Tent
tr8140
Trail Mix (Pouch)
tr8480
Trail Mix (Box)
wb7133
Insulated Water Bottle
$
$
$
$
335.24
9.95
19.95
6.75
wp0312
Water Purifier
$
21.55
wp5818
Water Purifier Tablets
$
10.31
ws6832
Snowshoes Women’s
$
78.15
ws8989
Snowshoes Mens’s
$
78.15
20180314221350cairn_camping.xlsx Order Form 3/14/2018
Excel 2016 Module 3–Case 4 Assignment
1. Complete steps 1 – 18 of Case 4 at the end of Module 3 in your Excel book.
2. Several different prints are required:
a.
b.
c.
d.
e.
f.
g.
Set Orientation to Landscape.
Set the print range so the lookup table is not printed.
Create a footer that contains your name, date, and class time or section
Print a normal view of the worksheet.
Display row and columns headings.
Change worksheet to formula view.
Adjust the width of columns containing formulas so the entire formula in each
column is completely visible. Points will be deducted if the entire formula
cannot be seen!
h. Fit to one page! You may need to shorten the column widths of those columns
that do not contain formulas.
i. Print a formula view of the worksheet.
j. This assignment will be collected Thursday.

Purchase answer to see full
attachment

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:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
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

Order your essay today and save 30% with the discount code ESSAYSHELP