Insert a new worksheet and rename it: MobileSales
If necessary, move the MobileSales worksheet so it appears first in the workbook.
Enter the text and sales data as shown in the table below. Check your work carefully.ABCDE1Top’t Corn Mobile Sales (August)2Truck Location3Farragut SquareGWGeorgetownK Street4Old Bay2800100070012005Truffle3300700150020006Sea Salt and Caramel4500190018001400
Format the data as follows:

Apply the Heading 1 cell style to cell A1.
Apply the Blue fill color to cell A1. Use the third color from the right in the row of Standard colors.
Apply the White, Background 1 font color to cell A1. Use the first color at the left in the first row of Theme colors.
Merge and center the worksheet title across cells A1:E1.
Apply the Heading 2 cell style to cell B2.
Merge and center cells B2:E2.
Bold cells B3:E3.
Apply the Accounting Number Format with 0 digits after the decimal to cells B4:E6.
AutoFit columns A:E.

Calculate total sales for each of the truck locations.

Enter the word Total in cell A7.
Enter a SUM function in cell B7 to calculate the total of cells B4:B6.
Use AutoFill to copy the formula to cells C7:E7.
Apply the Total cell style to cells A7:E7.

Insert a pie chart (2-D Pie) to show the Old Bay sales for the month by location. Each piece of the pie should represent the Old Bay sales for a single location.
Note: You must complete this step correctly in order to receive points for completing the next step. Check your work carefully.
Modify the pie chart as follows:

Apply the Layout 1 Quick Layout.
Move the chart so it appears below the sales data.

Insert a clustered column chart (2-D Column) to show the sales for each type of popcorn for each location. Do not include the totals. Hint: You may need to switch the row/column after inserting the chart.
Note: You must complete this step correctly in order to receive points for completing the next step. Check your work carefully.
Modify the column chart as follows:

If necessary, modify the chart so each location is represented by a data series and the popcorn types are listed along the x axis.
Change the chart title to: August Sales by Popcorn Type
Apply the Style 5 chart Quick Style.
Display the chart data labels using the Outside End option.
If necessary, move the chart so it is next to the pie chart and the top of the charts are aligned.

Preview how the worksheet will look when printed, and then apply print settings to print the worksheet on a single page. Hint: If you have one of the charts selected, deselect it before previewing the worksheet. Preview the worksheet again when you are finished to check your work.

Change the orientation so the page is wider than it is tall.
Change the printing scale so all columns will print on a single page.

Top’t Corn is considering a new truck purchase. Calculate the total cost of the loan.

Change the color of the TruckLoan worksheet tab to Orange. Use the third color from the left in the row of Standard colors.
Set the width of column B to 16.
In cell B6, enter a formula to calculate the total paid over the life of the loan (the monthly payment amount in cell B4 * the number of payments in cell B2). Use cell references.
In cell B7, enter a formula to calculate the total interest paid over the life of the loan (the total payments in cell B6 – the original price of the truck in cell B1). Use cell references.
Apply borders using the Thick Outside Borders option around cells A6:B7.
In cell A10, type: Buy new truck?
In cell B10, enter a formula using the IF function to display Yes if the monthly payment for the truck loan is less than the average sales per month for the current trucks. Display No if it is not.

Complete the following steps in the TysonsStore2019 worksheet:

Select cells A2:A32, and apply the Short Date date format.
In cell F2, enter a formula to calculate the daily total in dollars. Multiply the value in the Daily Total (# Sold) column by the current price per box in cell K1. Use an absolute reference where appropriate and copy the formula to cells F3:F32.
In cell G2, enter a formula using the IF function to determine whether the daily sales goal in cell K2 was met. Display yes if the value in the Daily Total ($) column is greater than or equal to the daily sales goal. Display no if it is not. Use an absolute reference where appropriate and copy the formula to cells G3:G32.
Create a named range DailyTotals for cells F2:F32.
In cell K3, enter a formula using the named range DailyTotals to calculate the average daily sales in dollars.
In cell K4, enter a formula using the named range DailyTotals to find the lowest daily sales in dollars.
In cell K5, enter a formula using the named range DailyTotals to find the highest daily sales in dollars.

Go to the OnlineSales worksheet and format the sales data as a table using the table style Orange, Table Style Light 10.
Sort the data alphabetically by values in the Item column.
Filter the table to show only rows where the value in the State column is DC.
Save and close the workbook

TruckLoan

Price $ 55,000.00

Loan term (in months) 24

Interest (annual) 3%

Monthly payment $ 2,363.97

Total payments

Interest paid

Average sales $ 4,500.00

OnlineSales

Online Sales During Buy 1 Get 1 Free Sale

Date Quantity Item State

7/30/19 13 Old Bay MD

7/30/19 9 Original Blend OH

7/30/19 28 Original Blend CA

7/30/19 9 Sea Salt and Caramel MO

7/30/19 21 Sea Salt and Caramel NJ

7/30/19 9 Truffle VA

7/30/19 29 Truffle DC

7/30/19 20 Original Blend AL

7/30/19 17 Old Bay MD

7/30/19 20 Truffle DC

7/30/19 16 Sea Salt and Caramel MS

7/30/19 24 Original Blend NC

7/30/19 14 Original Blend VA

7/30/19 24 Old Bay NJ

7/30/19 9 Old Bay NJ

7/30/19 32 Sea Salt and Caramel NY

7/31/19 11 Old Bay ID

7/31/19 12 Sea Salt and Caramel OH

7/31/19 33 Truffle NY

7/31/19 28 Original Blend AL

7/31/19 17 Old Bay MD

7/31/19 31 Original Blend NC

7/31/19 30 Sea Salt and Caramel MS

7/31/19 21 Original Blend VA

7/31/19 21 Old Bay MD

7/31/19 9 Old Bay MD

7/31/19 9 Old Bay VA

7/31/19 27 Original Blend WV

7/31/19 13 Sea Salt and Caramel CA

7/31/19 11 Sea Salt and Caramel MO

7/31/19 16 Sea Salt and Caramel MS

7/31/19 34 Truffle NY

7/31/19 35 Truffle NY

7/31/19 28 Original Blend OH

8/1/19 26 Truffle NY

8/1/19 31 Old Bay MD

8/1/19 9 Old Bay DC

8/1/19 12 Sea Salt and Caramel MS

8/1/19 21 Sea Salt and Caramel AL

8/1/19 15 Sea Salt and Caramel NC

8/1/19 25 Original Blend AL

8/1/19 16 Original Blend DC

8/1/19 30 Original Blend NY

8/1/19 17 Original Blend WV

8/1/19 25 Original Blend OH

8/1/19 22 Truffle VA

8/1/19 13 Old Bay VA

8/1/19 16 Sea Salt and Caramel DC

8/1/19 17 Old Bay MD

8/1/19 11 Old Bay WV

8/1/19 20 Original Blend AL

8/1/19 10 Original Blend SC

8/1/19 16 Truffle SC

8/2/19 33 Original Blend OH

8/2/19 33 Original Blend NY

8/2/19 16 Sea Salt and Caramel NJ

8/2/19 20 Sea Salt and Caramel NJ

8/2/19 13 Old Bay NY

8/2/19 24 Truffle NY

8/2/19 22 Old Bay OH

8/2/19 10 Truffle DC

8/2/19 16 Old Bay CA

8/3/19 25 Original Blend AL

8/3/19 24 Original Blend MS

8/3/19 34 Sea Salt and Caramel OH

8/3/19 11 Old Bay CA

8/3/19 34 Old Bay DC

8/3/19 22 Original Blend CA

8/3/19 29 Truffle VA

8/3/19 29 Sea Salt and Caramel NJ

8/3/19 23 Sea Salt and Caramel WV

8/4/19 28 Old Bay MD

8/4/19 31 Old Bay DC

8/4/19 34 Sea Salt and Caramel NJ

8/4/19 21 Sea Salt and Caramel NY

8/4/19 21 Original Blend MD

8/4/19 33 Original Blend AL

8/4/19 14 Truffle VA

8/4/19 12 Old Bay MD

8/4/19 32 Old Bay MD

8/4/19 20 Old Bay VA

8/4/19 9 Truffle NY

8/4/19 24 Original Blend OH

8/4/19 31 Sea Salt and Caramel CA

8/4/19 18 Original Blend CA

8/4/19 21 Truffle CA

8/4/19 35 Old Bay MD

8/4/19 26 Original Blend MD

8/4/19 16 Old Bay VA

8/4/19 32 Original Blend VA

8/4/19 32 Sea Salt and Caramel MS

8/4/19 22 Original Blend NC

8/4/19 14 Original Blend WV

8/4/19 23 Old Bay WV

8/4/19 16 Truffle OH

8/5/19 12 Old Bay MD

8/5/19 28 Truffle OH

8/5/19 21 Original Blend CA

8/5/19 10 Original Blend MD

8/5/19 17 Sea Salt and Caramel VA

8/5/19 24 Truffle MD

8/5/19 30 Truffle VA

8/5/19 31 Sea Salt and Caramel AL

8/5/19 13 Old Bay MD

8/5/19 34 Old Bay WV

8/5/19 11 Original Blend WV

8/5/19 24 Truffle CA

8/5/19 9 Truffle CA

8/5/19 14 Truffle MO

8/5/19 16 Original Blend WV

8/5/19 29 Sea Salt and Caramel DC

8/5/19 32 Old Bay DC

8/5/19 15 Sea Salt and Caramel MD

8/5/19 28 Sea Salt and Caramel VA

8/5/19 18 Truffle AL

8/5/19 35 Sea Salt and Caramel MS

8/5/19 9 Old Bay NC

BOGOSale2018

Online Sales During Buy 1 Get 1 Free Sale

Date Quantity Item State

7/30/18 21 Old Bay MD

7/30/18 16 Original Blend OH

7/30/18 25 Original Blend CA

7/30/18 19 Sea Salt and Caramel MO

7/30/18 14 Sea Salt and Caramel NJ

7/30/18 21 Truffle VA

7/30/18 5 Truffle DC

7/30/18 11 Original Blend AL

7/30/18 23 Old Bay MD

7/30/18 13 Truffle DC

7/30/18 10 Sea Salt and Caramel MS

7/30/18 11 Original Blend NC

7/30/18 6 Original Blend VA

7/30/18 18 Old Bay NJ

7/30/18 18 Old Bay NJ

7/30/18 20 Sea Salt and Caramel NY

7/31/18 18 Old Bay ID

7/31/18 24 Sea Salt and Caramel OH

7/31/18 11 Truffle NY

7/31/18 16 Original Blend AL

7/31/18 14 Old Bay MD

7/31/18 20 Original Blend NC

7/31/18 14 Sea Salt and Caramel MS

7/31/18 9 Original Blend VA

7/31/18 19 Old Bay MD

7/31/18 25 Old Bay MD

7/31/18 20 Old Bay VA

7/31/18 15 Original Blend WV

7/31/18 5 Sea Salt and Caramel CA

7/31/18 7 Sea Salt and Caramel MO

7/31/18 7 Sea Salt and Caramel MS

7/31/18 12 Truffle NY

7/31/18 11 Truffle NY

7/31/18 6 Original Blend OH

8/1/18 5 Truffle NY

8/1/18 12 Old Bay MD

8/1/18 8 Old Bay DC

8/1/18 20 Sea Salt and Caramel MS

8/1/18 13 Sea Salt and Caramel AL

8/1/18 23 Sea Salt and Caramel NC

8/1/18 12 Original Blend AL

8/1/18 9 Original Blend DC

8/1/18 20 Original Blend NY

8/1/18 7 Original Blend WV

8/1/18 21 Original Blend OH

8/1/18 16 Truffle VA

8/1/18 14 Old Bay VA

8/1/18 24 Sea Salt and Caramel DC

8/1/18 23 Old Bay MD

8/1/18 17 Old Bay WV

8/1/18 11 Original Blend AL

8/1/18 25 Original Blend SC

8/1/18 6 Truffle SC

8/2/18 19 Original Blend OH

8/2/18 22 Original Blend NY

8/2/18 25 Sea Salt and Caramel NJ

8/2/18 13 Sea Salt and Caramel NJ

8/2/18 22 Old Bay NY

8/2/18 18 Truffle NY

8/2/18 14 Old Bay OH

8/2/18 5 Truffle DC

8/2/18 5 Old Bay CA

8/3/18 10 Original Blend AL

8/3/18 12 Original Blend MS

8/3/18 11 Sea Salt and Caramel OH

8/3/18 22 Old Bay CA

8/3/18 11 Old Bay DC

8/3/18 18 Original Blend CA

8/3/18 22 Truffle VA

8/3/18 13 Sea Salt and Caramel NJ

8/3/18 21 Sea Salt and Caramel WV

8/4/18 5 Old Bay MD

8/4/18 5 Old Bay DC

8/4/18 14 Sea Salt and Caramel NJ

8/4/18 11 Sea Salt and Caramel NY

8/4/18 15 Original Blend MD

8/4/18 6 Original Blend AL

8/4/18 17 Truffle VA

8/4/18 20 Old Bay MD

8/4/18 7 Old Bay MD

8/4/18 17 Old Bay VA

8/4/18 19 Truffle NY

8/4/18 6 Original Blend OH

8/4/18 13 Sea Salt and Caramel CA

8/4/18 17 Original Blend CA

8/4/18 22 Truffle CA

8/4/18 18 Old Bay MD

8/4/18 17 Original Blend MD

8/4/18 12 Old Bay VA

8/4/18 13 Original Blend VA

8/4/18 21 Sea Salt and Caramel MS

8/4/18 6 Original Blend NC

8/4/18 24 Original Blend WV

8/4/18 17 Old Bay WV

8/4/18 18 Truffle OH

8/5/18 19 Old Bay MD

8/5/18 16 Truffle OH

8/5/18 17 Original Blend CA

8/5/18 10 Original Blend MD

8/5/18 16 Sea Salt and Caramel VA

8/5/18 22 Truffle MD

8/5/18 16 Truffle VA

8/5/18 23 Sea Salt and Caramel AL

8/5/18 12 Old Bay MD

8/5/18 21 Old Bay WV

8/5/18 8 Original Blend WV

8/5/18 22 Truffle CA

8/5/18 7 Truffle CA

8/5/18 19 Truffle MO

8/5/18 24 Original Blend WV

8/5/18 12 Sea Salt and Caramel DC

8/5/18 22 Old Bay DC

8/5/18 17 Sea Salt and Caramel MD

8/5/18 7 Sea Salt and Caramel VA

8/5/18 13 Truffle AL

8/5/18 22 Sea Salt and Caramel MS

8/5/18 21 Old Bay NC

TysonsStore2019

Date Old Bay Black Truffle Sea Salt and Caramel Daily Total (# sold) Daily Total ($) Sales Goal Met? with Price Increase Current price per box: $6

1-Aug 239 83 209 531 $ 3,186 Daily sales goal: $1,500

2-Aug 225 185 77 487 $ 2,922 Average daily sales:

3-Aug 45 165 156 366 $ 2,196 Lowest daily sales:

4-Aug 240 93 177 510 $ 3,060 Highest daily sales:

5-Aug 195 215 110 520 $ 3,120

6-Aug 25 133 251 409 $ 2,454 Average sales with price increase $ 2,762

7-Aug 126 53 196 375 $ 2,250 New price per box: $6

8-Aug 263 141 37 441 $ 2,646

9-Aug 26 174 204 404 $ 2,424

10-Aug 29 62 29 120 $ 720

11-Aug 210 238 98 546 $ 3,276

12-Aug 269 70 273 612 $ 3,672

13-Aug 150 86 224 460 $ 2,760

14-Aug 70 189 55 314 $ 1,884

15-Aug 221 182 240 643 $ 3,858

16-Aug 30 43 206 279 $ 1,674

17-Aug 53 143 259 455 $ 2,730

18-Aug 274 169 27 470 $ 2,820

19-Aug 166 121 101 388 $ 2,328

20-Aug 211 66 69 346 $ 2,076

21-Aug 114 240 72 426 $ 2,556

22-Aug 81 132 267 480 $ 2,880

23-Aug 273 241 194 708 $ 4,248

24-Aug 266 233 42 541 $ 3,246

25-Aug 168 237 273 678 $ 4,068

26-Aug 54 265 255 574 $ 3,444

27-Aug 165 85 189 439 $ 2,634

28-Aug 274 38 55 367 $ 2,202

29-Aug 25 222 188 435 $ 2,610

30-Aug 121 119 245 485 $ 2,910

31-Aug 114 91 257 462 $ 2,772

TysonsStore2018

Date Old Bay Black Truffle Sea Salt and Caramel Daily Total (# sold)

8/1/18 42 115 92 249

8/2/18 42 42 117 201

8/3/18 105 124 64 293

8/4/18 141 83 76 300

8/5/18 137 73 109 319

8/6/18 68 44 60 172

8/7/18 82 58 145 285

8/8/18 125 96 92 313

8/9/18 20 26 39 85

8/10/18 67 38 21 126

8/11/18 121 124 132 377

8/12/18 140 76 25 241

8/13/18 147 77 77 301

8/14/18 86 128 59 273

8/15/18 50 122 96 268

8/16/18 80 92 139 311

8/17/18 41 69 59 169

8/18/18 26 38 125 189

8/19/18 93 41 133 267

8/20/18 84 144 146 374

8/21/18 25 124 145 294

8/22/18 107 60 142 309

8/23/18 116 115 128 359

8/24/18 46 129 145 320

8/25/18 44 112 99 255

8/26/18 112 96 31 239

8/27/18 73 102 97 272

8/28/18 100 89 109 298

8/29/18 55 30 75 160

8/30/18 137 117 97 351

8/31/18 125 39 80 244




Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.