Скачать или смотреть Simnet 2016 Excel 2016 Capstone Project EX-2 - Working with Sales Data (Modified 2018 Update 2025) |

Simnet 2016 Excel 2016 Capstone Project EX-2 - Working with Sales Data (Modified 2018 Update 2025) | Simnet 2016 Excel 2016 Capstone Project EX 2 Working with Sales Data Modified 2018 Update 2025 |


Contact me
Whatsapp : +923255362864
Email : mylab1471@gamil,com
Whatsapp Link :
https://wa.me/message/WV3LUWBVEHUAM1

We can handle all online courses, Business and Management, Business and Finance, Business and Accounting, Human Resource Management, History, English, Literature, Nursing, psychology, Statistics, Information Technology, Applied Sciences, Computer Science and Many more
We will help you in weekly quizzes, assignments, exams, thesis writing, dissertation writing, Matlab all courses.


We can do complete MyITLab course , Microsoft Word, Microsoft PowerPoint, Microsoft Excel, Microsoft Access

SIMnet 2016: Excel 2016
Capstone Project Level 2
Excel 2016 Capstone Project EX-2
Working with Sales Data
In this project, you will work with sales data from Top’t Corn, a popcorn company with an online store, multiple
food trucks, and one store in a local shopping mall. You will begin by entering sales data for the four food truck
locations, formatting the data, and calculating totals. You will create a pie chart to represent the sales 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 the new truck purchase is a good idea. Working
with the daily sales data for the brick-and-mortar store you will calculate the sales for each date, and the average,
minimum, and maximum sales. Finally, you will work with their online sales data to format it as an Excel table
and apply sorting and filtering.
Skills needed to complete this project:
• Insert a worksheet
• Name a worksheet
• Move a worksheet
• Enter text
• Enter numbers
• Edit text
• Apply a cell style
• Merge and center text across cells
• Apply bold formatting
• Add cell shading
• Change font color
• Apply number formatting
• Autofit a column
• Enter a SUM function
• Copy formula using AutoFill
• Insert a pie chart
• Change the chart title
• Hide the chart legend
• Show chart data labels
• Move a chart
• Insert a column chart
• Switch the row/column in a column chart
• Apply a chart Quick Style
Step 1
• Preview how a worksheet will look when
printed
• Change worksheet orientation
• 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
• 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
• Enter an AVERAGE function
• Use the MIN function in a formula
• Use the MAX function in a formula
• Convert data into a table
• Apply a table Quick Style
• Sort data in a table
• Filter data in a table
• Close a workbook
This image appears when a project instruction has changed to accommodate an update to
Microsoft Office 365. If the instruction does not match your version of Office, try using the alternate instruction
instead.
Download
start file
1. Open the start file EX2016-Capstone-Level2. If the workbook opens in Protected View, click the Enable
Editing button in the Message Bar at the top of the worksheet so you can modify it.
1 | Page
Last Modified: 4/9/2018
SIMnet 2016: Excel 2016
Capstone Project Level 2
2. The file will be renamed automatically to include your name. Change the project file name if directed to
do so by your instructor, and save it.
3. Insert a new worksheet and rename it: Trucks
4. If necessary, move the Trucks worksheet so it appears first in the workbook.
5. Enter the text and sales data as shown in Figure 1.
Figure 1
6. Format the data as follows:
a.
Apply the Heading 1 cell style to cell A1.
b. Merge and center cells A1:E1.
c.
Apply the Heading 2 cell style to cell B2.
d. Merge and center cells B2:E2.
e.
f.
Bold cells B3:E3 and cells A4:A6.
Apply the Blue, Accent 1 fill color to cells B3:E3.
g. Apply the White, Background 1 font color to cells B3:E3.
h. Apply the Accounting Number Format with 0 digits after the decimal to cells B4:E6.
i.
AutoFit columns A:E.
7. Calculate total sales for each of the truck locations.