Excel 365/2019 Capstone – Level 3 Working with Sales Data Alternate with VLOOKUP
Need this completed Excel document.
The instructions and starting document are attached.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() Print Info

Student Name: Gullickson, Finn

Student ID: D41122036

Username: D41122036
Excel 365/2019 Capstone –
Level 3 Working with Sales Data
Alternate with VLOOKUP
COURSE NAME BIS155 SEP20 Master | Data Analysis with

Spreadsheets with Lab – 11964

Start Date: 10/17/2011:59 PMUS/Mountain
Due Date: 10/24/2011:59 PMUS/Mountain
End Date: 10/25/2011:59 PMUS/Mountain

In this project, you will work with sales data from Top’t Corn, a popcorn company with an
online store, multiple food trucks, and two retail stores. You will begin by copying the sales
data for one of the retail stores from another workbook. Next, you will insert a new worksheet
and enter sales data for the four food truck locations, formatting the data, and calculating
totals. You will create a pie chart to represent the total units sold by location and a column
chart to represent sales by popcorn type. You will format the charts, and then set up the
worksheet for printing. Next, you help Top’t Corn calculate payments for a loan and decide
whether or not the purchase is a good idea. Working with the daily sales data for one of the
brick-and-mortar stores, you will apply conditional formatting to find the top 10 sales dates. Y
ou will also calculate the sales for each date, and the average, minimum, and maximum sales.
You will use Goal Seek to find the appropriate price to reach a higher daily average sales goal.
You will use VLOOKUP to look up sales data for a specific date. Finally, you will work with
their online sales data to format it as an Excel table and apply sorting and filtering. You will
create a PivotTable and a PivotChart from a copy of the online sales data to summarize the
sales.

Skills needed to complete this project:

Open a workbook
Copy a worksheet to another workbook
Close a workbook
Insert a worksheet
Name a worksheet
Move a worksheet

SIMnet – Excel 365/2019 Capstone – Level 3 Working with Sales Da… https://devry.simnetonline.com/sp/embed/#pr/5573835

1 of 8 10/21/20, 9:10 PM

Enter text
Enter numbers
Edit text
Autofit a column
Apply a cell style
Add cell shading
Change font color
Merge and center text across cells
Apply bold formatting
Apply number formatting
Enter a SUM function
Copy formula using AutoFill
Insert a pie chart
Apply a chart Quick Layout
Move a chart
Insert a column chart
Switch the row/column in a column chart
Change the chart title
Apply a chart Quick Style
Show chart data labels
Preview how a worksheet will look when printed
Change worksheet orientation
Change the print margins
Scale a worksheet for printing
Change the color of a worksheet tab
Apply a column width
Calculate a loan payment with PMT
Enter a simple formula using multiplication
Enter a simple formula using subtraction
Add cell borders
Create a formula referencing cells in another worksheet
Enter an AVERAGE function
Use the IF function
Hide a worksheet
Apply date formats
Apply Top Ten conditional formatting
Use an absolute reference in a formula
Name a range of cells
Use aOldTownStore

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

1-Aug 140 49 110 299

2-Aug 141 100 133 375

3-Aug 32 68 35 135

4-Aug 130 35 34 199

5-Aug 104 124 93 321

6-Aug 43 135 117 295

7-Aug 61 9 62 132

8-Aug 16 68 93 177

9-Aug 8 70 19 97

10-Aug 145 9 114 275

11-Aug 94 14 148 256

12-Aug 50 59 87 196

13-Aug 92 110 65 267

14-Aug 64 140 63 267

15-Aug 40 46 12 98

16-Aug 136 50 128 314

17-Aug 21 34 55 110

18-Aug 32 122 133 287

19-Aug 57 144 12 213

20-Aug 36 98 107 241

21-Aug 122 140 44 306

22-Aug 53 76 97 226

23-Aug 96 122 48 266

24-Aug 96 100 43 239

25-Aug 118 106 30 251

26-Aug 115 61 47 223

27-Aug 29 53 133 215

28-Aug 20 124 10 154

29-Aug 66 73 130 269

30-Aug 73 78 124 275

31-Aug 93 42 76 205

Daily Total (# sold) 43678 43679 43680 43681 43682 43683 43684 43685 43686 43687 43688 43689 43690 43691 43692 43693 43694 43695 43696 43697 43698 43699 43700 43701 43702 43703 43704 43705 43706 43707 43708 299 375 135 199 321 295 132 177 97 275 256 196 267 267 98 314 110 287 213 241 306 226 266 239 251 223 215 154 269 275 205 Old Bay 43678 43679 43680 43681 43682 43683 43684 43685 43686 43687 43688 43689 43690 43691 43692 43693 43694 43695 43696 43697 43698 43699 43700 43701 43702 43703 43704 43705 43706 43707 43708 140 141 32 130 104 43 61 16 8 145 94 50 92 64 40 136 21 32 57 36 122 53 96 96 118 115 29 20 66 73 93 Black Truffle 43678 43679 43680 43681 43682 43683 43684 43685 43686 43687 43688 43689 43690 43691 43692 43693 43694 43695 43696 43697 43698 43699 43700 43701 43702 43703 43704 43705 43706 43707 43708 49 100 68 35 124 135 9 68 70 9 14 59 110 140 46 50 34 122 144 98 140 76 122 100 106 61 53 124 73 78 42 Sea Salt and Caramel 43678 43679 43680 43681 43682 43683 43684 43685 43686 43687 43688 43689 43690 43691 43692 43693 43694 43695 43696 43697 43698 43699 43700 43701 43702 43703 43704 43705 43706 43707 43708 110 133 35 34 93 117 62 93 19 114 148 87 65 63 12 128 55 133 12 107 44 97 48 43 30 47 133 10 130 124 76




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.