Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Excel capstone project 2018

09/01/2021 Client: saad24vbs Deadline: 14 Days

SIMnet 2016: Excel 2016 Capstone Project Level 3


1 | Page Last Modified: 4/9/2018


Excel 2016 Capstone Project EX-3 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 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. You 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.


Skills needed to complete this project:


• Open a workbook


• Copy a worksheet to another workbook


• 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


• 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


• 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


• Calculate a loan payment with PMT


• 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


• Apply Top Ten conditional formatting


• 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


• Wrap text


• Analyze data with Goal Seek


• Use the VLOOKUP function in a formula


• Convert data into a table


• Apply a table Quick Style


• Use the table Total row


• Sort data in a table


• Filter data in a table


• Create a PivotTable


• Create a PivotChart


SIMnet 2016: Excel 2016 Capstone Project Level 3


2 | Page Last Modified: 4/9/2018


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.


IMPORTANT: Download the resource file needed for this project from the Resources link. Make sure to


extract the file after downloading the resources zipped folder. Visit the SIMnet Instant Help for step-by-step


instructions.


1. Open the start file EX2016-Capstone-Level3 workbook. 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.


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. Copy the OldTownStore worksheet from the OldTownSales workbook (downloaded from the


Resources link) to the capstone project.


a. Open the Excel file OldTownSales.


b. Copy the worksheet OldTownStore. In the Move or Copy dialog, be sure to check the Create a copy


check box and select your capstone project Excel file from the Move selected sheets to book drop-


down list. Make the correct selection to ensure the copied worksheet will appear after the


TysonsStore worksheet in your capstone workbook.


c. Close the OldTownSales workbook when you have successfully copied the OldTownStore worksheet to


the capstone workbook.


d. Before continuing, verify that you are working in the capstone project that you downloaded and not


the OldTownSales workbook that you downloaded from the Resources link.


4. Insert a new worksheet and rename it: TruckSales


5. If necessary, move the TruckSales worksheet so it appears first in the workbook.


6. Enter the text and sales data as shown in Figure 1. Check your work carefully.


Figure 1


7. Format the data as follows:


a. Apply the Title cell style to cell A1.


b. Apply the Brown, Accent 6 fill color to cell A1.


c. Apply the White, Background 1 font color to cell A1.


d. Merge and center the worksheet title across cells A1:E1.


Download Resources


Step 1 Download start file


SIMnet 2016: Excel 2016 Capstone Project Level 3


3 | Page Last Modified: 4/9/2018


e. Apply the Heading 1 cell style to cell B2.


f. Merge and center cells B2:E2.


g. Bold cells B3:E3.


h. Apply the Accounting Number Format with 0 digits after the decimal to cells B4:E6.


i. AutoFit columns A:E.


8. Calculate total sales for each of the truck locations.


a. Enter the word Total in cell A7.


b. Enter a SUM function in cell B7 to calculate the total of cells B4:B6.


c. Use AutoFill to copy the formula to cells C7:E7.


d. Apply the Total cell style to cells A7:E7.


9. Insert a pie chart (2-D Pie) to show the total sales for the month by location. Each piece of the pie should

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

University Coursework Help
Best Coursework Help
Top Essay Tutor
Helping Hand
Writer Writer Name Offer Chat
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$37 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$35 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$40 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$35 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Issues facing ford motor company - Liberty university busi 201 - Stainless steel nut and bolt torque settings - You give me that bottom of the ninth quote - Accessdata certifies examiner - Data roaming on or off in australia - Financial Accounting Data - James lull hegemony - Glen waverley secondary college uniform - Rust oleum specialty stainless steel paint - Ol 211 final project milestone two - Setting of ready player one - Michael levin the case for torture - FIN 100 - Global study of shrimp fisheries - Law firm staff evaluation forms - Simulation exercise - Duraglas milk bottle dating - Computer organization assignment - Why can a bird sit on a power line - For anyone - Sy ginsberg corned beef costco - Skill set 1 - Communicating at work 11th edition pdf download - Starwood hotels and resorts worldwide inc 2007 case study - "Case of Controversy Requirement" Please respond to the following: - American revolution - The other wes moore final paper - Ops 571 week 5 individual assignment operations forecasting - International journal of microsimulation - What h3o+ concentration corresponds to each ph value - Aeneid book 2 translation - Idividual Strategies Signature Assignment - Current Liabilities - Beaconsfield primary school review - Leadership Development Plan - What is the unknown metal identified as in this lab - Why did orgo iron his four leaf clover answer - Gram staining microbiology lab report - Soundtraxx tsunami steam cv list - Susan glaspell trifles discussion questions answers - Rowing the bus reading comprehension questions - Biological approach to abnormality - The compass of shame nathanson 1992 - Mathew peck travelling scholarship - Wzzm13 on your sidelines scores - Precision nutrition body measurements - Lit Review - Cisco network proposal part 1 - Trifles mrs peters character analysis - Kuwait conformity assurance scheme kucas - Avant garde literal translation - Oreo ultimate dunking set rite aid - Current issues and enduring questions 12th edition ebook - Vce english study design advice for teachers - Write 2 outstanding reference letters - Ati video case study teamwork and collaboration - How to prove a relation is antisymmetric - When mr pirzada came to dine character analysis - Cheating spouses in historic aztec tribes - Why america is self segregating thesis - Letter of engagement template - What is a google subscriber - E registration aberdeen uni - How do you look after a hamster - 5 - Presentation on a How to Manage HIT (Health Information Technology) Changes - What is roz savage famous for puzzle time answer key - Wedding cake model of justice - Module data analysis line of best fit - An answer to the question what is enlightenment - Bones of the orbit - Qualities of a good student paragraph - Discussion 4 - Being green at ben and jerry's thesis - Questions for act one of the crucible answer key - 50-CL1 - 1 turtledove rise greenough - Chapter 13 the expenditure cycle purchasing to cash disbursements - If the cpm for national geographic magazine is $16.44, it means it will cost $16.44 to reach: - Essay(900 words) - Company Privacy Policy - Operations Security - Sir charles gairdner hospital dental clinic - Herman's hermits starring peter noone curtis peterson auditorium february 9 - Understanding the difference between a discriminative stimulus - Pick bullet 1 $18 - Order 2284353: not raising minimum wage in Michigan - Unit 6 managing a successful business project assignment sample - Everyday use dee - Chc50113 diploma of early childhood education and care answers - Zappos com developing a supply chain to deliver wow - Is it still possible to be a mountain man - New maths frameworking year 8 answers free download - Children and their development 7th edition pdf free - Light and growth lab - Macquarie bank capital notes 3 offer - CS 5 - Contract Law Case Analysis - What is 2 8 in simplest form - African illness a case of parasites answer key - The composer of this excerpt is