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 inserting a new worksheet and entering 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. You will also calculate the sales for each date, and the average, minimum, and maximum sales.
Skills needed to complete this project:
A |
B |
C |
D |
E |
|
1 |
Top’t Corn Mobile Sales (September) |
||||
2 |
Truck Location |
||||
3 |
Farragut Square |
GW |
Georgetown |
K Street |
|
4 |
Old Bay |
2600 |
900 |
650 |
1100 |
5 |
Truffle |
2900 |
600 |
1300 |
1700 |
6 |
Sea Salt and Caramel |
4000 |
1700 |
1300 |
1500 |
Editing LINK Is https://drive.google.com/file/d/1wkd3y8EfUAWPn8Ey1QMpkuZJS9YmYqPa/view?usp=sharing
In this project, you will work with sales data from Top’t Corn, a popcorn company with...
I have completed these but wanting to compare such as Question 14. Is the word "Total" added in the row or written as "Average" or "Total Average" Also Question 8 is not clear what fill color. Is it supposed to stay as blue and just select gradient fill? Very unclear questions. Thank you. Question: EX16_XL_VOL1_GRADER_CAP_AS – Travel Vacations 1.4 ( Excel, Chapter 4) Project Description: 1 Start Excel. Download and open the file named exploring_ecap_grader_a1.xlsx. 2 On the DC worksheet,...
My Company Projected Budget - 2019 Expense Category 1st Qtr. 2nd Qtr. 3rd Qtr. 4th Qtr. Annual Total Average Minimum % of Total Rent 2800 2800 3000 3000 Electric 700 500 500 800 Phone 300 300 300 300 Supplies 800 600 600 500 Payroll 6000 9000 12000 12000 Total Average Maximum Create a new workbook in Excel Save workbook as “yourinitialsBUDGET” (replace “yourinitials” with your initials) Insert a row between PHONE and SUPPLIES and Enter the following:...
Styles Project Description: You are an accountant for a pharmaceutical sales company. As one of your tasks, you complean annual report that documents regional sales information into one standardized worksheet. As part of this process, you group the worksheets and insert descriptive rows and columns, apply formatting, and insert hundtions. Your last step is to create a sales suminary worksheet and provide basic information for management to evaluate. Steps to Perform: Step Instructions Points Possible 1 0 Open exploring 09...
Instructions 1-17 sheet 1 sheet 2 Should be done on exel file. Assignment Instructions Step Instructions Point Value Open the Excel file Student_Excel_2F_Bonus xlsx downloaded with this project. Rename Sheet1 as Northern and rename Sheet2 as Southern Click the Northern sheet tab to make it the active sheet, and then group the worksheets. In cell A1, type Rosedale Landscape and Garden and then Merge & Center the text across the range A1 F1. Apply the Title cell style. Merge &...
EX16 XL _CH01_GRADER ML2 HW - Real Estate Sales Report 1.3 Project Description: You own a small real estate company in Indianapolis. You track the real estate properties you list for dlients. You want to analyze sales for selected properties. Yesterday, you prepared a workbook with a worksheet for recent sales data and another worksheet listing several properties you listed. You want to calculate the number of days that the houses were on the market and their sales percentage of...
In this exercise, you will complete a bond amortization schedule for Minute Construction. You will calculate the bond characteristics and generate a schedule with key components. You will protect worksheet elements and create a macro. Start a new file. Reduce the width of column A to 0.75 and the height of row 1 to 7.20. Enter the bond details in the range B2:C8. Include a centered header and appropriate titles. Enter the details for a bond with a $310,000 face...
Please Answer all these. Those questions are from New Perspectives Microsoft Office 365 & Excel 2016 . Need answers from Excel concern : 1. What formula would you enter to add the values in cells C1, C2, and C3? What function would you enter to achieve the same result? 2. What formula would you enter to count how many numeric values are in the range D21:D72? 3. If you insert cells into the range C1:D10, shifting the cells to the...
2 Select the range A4:G9 and create a clustered column chart Position the clustered column chart so that the upper-left cormer is within cell A15 and the lower-right corner is within cell G34 4 Swap the data on the category axis and in the legend 5 Apply the Style 6 chart style. Select Color 12 in the Change Colors gallery Note, the color name may be listed as Monochromatic Palette 8, depending on the version of Office being used 6...
COMPLETE THE FOLLOWING USING THE ATTACHED DOCUMENTS In this exercise, you will perform a financial statement analysis for Water Feature Designers Inc. You will perform horizontal/vertical analyses and create charts to highlight key information from these analyses. You will also calculate financial ratios and insert cell comments. Use this information to complete the ratio analysis. Ratio Current Ratio Debt-to-Equity Ratio Profit Margin 2016 7.62 0.17 .186 2015 3.45 0.28 292 2014 8.21 0.18 255 1. Open EA9-A2-FSA from your Chapter...
Data File needed for this Case Problem: Green.xlsx 0 Green Clean Homes Sean Patel is developing a business plan for Green Clean Homes, a new professional home cleaning service in Toledo, Ohio. As part of his business plan, Sean needs to predict the company's annual income and expenses. You will help him finalize and format the Excel workbook containing the projected income statement. Complete the following 1. Open the Green workbook located in the Excel2 >Case1 folder, and then save...