Calculate the sales for each date

Assignment Help Other Subject

Reference no: EM133769307

Question: 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

Reference no: EM133769307

Questions Cloud

Analyze the chosen ethical dilemma : Analyze the chosen ethical dilemma using an ethical decision-making model specific to forensic psychology. Detail the steps you would take to resolve

Different severities of anxiety and appropriate intervention : Complete the chart below determining what symptoms are prevalent at the different severities of anxiety and the appropriate interventions.

Concepts to current issues centered on immigration : Summarize the key concepts from the readings on immigration. Apply this concept(s) to current issues centered on immigration.

Summarize what the authors meant : Summarize what the authors meant, or at least what you think the authors meant, and try to see the world with that theoretical lens.

Calculate the sales for each date : 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

Why do you think, as hedges mentioned : Why do you think, as Hedges mentioned, it has yet to be fully incorporated into the field of Religious Studies? Feel free to research beyond Hedges

Discuss the findings of a qi initiative or study : Discuss the findings of a QI initiative or study from either your clinical location/hospital website or another online source.

Summarize the key concepts from the readings on immigration : Summarize the key concepts from the readings on immigration. Apply this concept(s) to current issues centered on immigration.

Find a structure in your environment : Find a structure in your environment (Chicagoland) that was inspired by the Architecture showcased in the textbook. Go out and have a humanistic

User Account

All Pages