IT NEEDS TO BE DONE ON SPREEDSHEET I PROVIDE! In this project, you will work wit

IT NEEDS TO BE DONE ON SPREEDSHEET I PROVIDE!
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.