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

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.