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.

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 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 will help Top’t Corn decide whether or not a new truck loan is a good idea. Working with the daily sales data for one of the brick-and-mortar stores, you will calculate the sales for each date, and the average, minimum, and maximum sales. Finally, you will work with the online sales data to format it as an Excel table and apply sorting and filtering.

Skills needed to complete this project:

Close a workbook

Insert a worksheet

Name a worksheet

Move a worksheet

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

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

Apply date formats

Use an absolute reference in a formula

Name a range of cells

Use a named range in a formula

Use the MIN function in a formula

Use the MAX function in a formula

Apply a table Quick Style

Use the table Total row

Sort data in a table

Filter data in a table