7. Calculate total sales for each of the truck locations. a. Enter the word Total in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
7. 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. 8. Insert a pie chart (2-D Pie) to show the Old Bay sales for the month by location. Each piece of the pie should represent the Old Bay sales for a single location. Note: You must complete this step correctly in order to receive points for completing the next step. Check your work carefully. 9. Modify the pie chart as follows: a. ☐ Apply the Layout 6 Quick Layout. b. Move the chart so it appears below the sales data. 10. Insert a clustered column chart (2-D Column) to show the sales for each type of popcorn for each location, Do not include the totals. Hint: You may need to switch the row/column after inserting the chart. Note: You must complete this step correctly in order to receive points for completing the next step. Check your work carefully. 11. Modify the column chart as follows: a. ☐ If necessary, modify the chart so each location is represented by a data series and the popcorn types are listed along the x axis. b. Change the chart title to: September Sales by Popcorn Type C. ☐ Apply the Style 7 chart Quick Style. d. Display the chart data labels using the Outside End option. e. If necessary, move the chart so it is next to the pie chart and the top of the charts are aligned. 49 肠 Reset Progr 7. 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. 8. Insert a pie chart (2-D Pie) to show the Old Bay sales for the month by location. Each piece of the pie should represent the Old Bay sales for a single location. Note: You must complete this step correctly in order to receive points for completing the next step. Check your work carefully. 9. Modify the pie chart as follows: a. ☐ Apply the Layout 6 Quick Layout. b. Move the chart so it appears below the sales data. 10. Insert a clustered column chart (2-D Column) to show the sales for each type of popcorn for each location, Do not include the totals. Hint: You may need to switch the row/column after inserting the chart. Note: You must complete this step correctly in order to receive points for completing the next step. Check your work carefully. 11. Modify the column chart as follows: a. ☐ If necessary, modify the chart so each location is represented by a data series and the popcorn types are listed along the x axis. b. Change the chart title to: September Sales by Popcorn Type C. ☐ Apply the Style 7 chart Quick Style. d. Display the chart data labels using the Outside End option. e. If necessary, move the chart so it is next to the pie chart and the top of the charts are aligned. 49 肠 Reset Progr
Expert Answer:
Answer rating: 100% (QA)
To calculate total sales for each of the truck locations and complete the tasks described 1 Enter To... View the full answer
Related Book For
Integrated Accounting
ISBN: 978-1285462721
8th edition
Authors: Dale A. Klooster, Warren Allen, Glenn Owen
Posted Date:
Students also viewed these programming questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
BACKGROUND You are an information analyst working for NEE. The company president has asked you to prepare a Quantitative analysis of financial, sales, and operations data to help determine which...
-
In each case, verily that the points P and Q lie on the line. x = 4 - t P(2, 3, -3), Q(-1, 3, -9) y = 3 z = 1 - 2t
-
Write a research paper about measuring and predicting financial stress for business enterprises. The accounting literature includes several financial stress prediction models for business...
-
Assume that the model y = X + u satisfies the Gauss-Markov assumptions, let G be a (k + 1) (k + 1) nonsingular, nonrandom matrix, and define = G, so that d is also a (k + 1) 1 vector. Let be the...
-
Sabrina Ederly worked as a reporter and contributing editor for Rolling Stone magazine. Ederly intended to write an article for the magazine that focused on the alleged rape of a University of...
-
Optima Company is a high-technology organization that produces a mass-storage system. The design of Optima's system is unique and represents a breakthrough in the industry. The units Optima produces...
-
Amazon Sales $177,866 Accounts receivable: Beginning of year 20,816 End of year 16,677 Determine the accounts receivable turnover. For interim computations, carry amounts out to one decimal place....
-
What users use financial reports? Why do these users need these reports? The initial post needs to be at least 100 words. Include the web address of your source.
-
For a 30 -year monthly level-pay home mortgage loan of \(\$ 500,000\) with a \(3 \%\) interest rate (a) Compute the monthly level payment. (b) What is the total amount of interest you pay during the...
-
The following items are documented in the audit working papers: 1. A sales transaction included in the year ended December 31, 2023, but evidence from the cut-off procedure suggests that the sale...
-
Convexity (a) If \(f^{\prime \prime}\) exists, use the definition 2.11 and \[f^{\prime \prime}(x)=\lim _{h ightarrow 0} \frac{f(x+h)+f(x-b)-2 f(x)}{h^{2}}\] to show that \(f^{\prime \prime}(x) \geq...
-
In relation to the new manufacturing costing system, describe two automated application controls that you would expect to find. Securimax Limited has been an audit client of KFP Partners for the past...
-
During 2019, Doubleday Company converted $1,700,000 of its total $2,000,000 of bonds payable into common stock. Indicate how the transaction would be reported on a statement of cash flows, if at all.
-
John is a manager of the sales department of Conad company. The company operates in the retail industry where it buys products from offshore suppliers at a lower price and sells those products in the...
-
Clark, PA, has been engaged to perform the audit of Kent Ltd.s financial statements for the current year. Clark is about to commence auditing Kents employee pension expense. Her preliminary enquiries...
-
The Income Statement option under the Company Info. tab allows two settings. List the two settings and explain the difference between them.
-
Why is data not lost when invoices and purchase orders are purged?
-
Complete the date range section of the following Journal Report Selection window to display all general journal entries from July 1 through July 31 of the current year. -General Journal - C Include...
-
Part A Branxton Ltds inventory on 1 April 2019 had a cost of $100 000 and a retail value of $170 000. During April, the companys net purchases cost $216 000 and had a net retail value of $324 000....
-
Toowoomba Irrigation Ltd began operations in the southeast Queensland region in July 2015. During the annual audit for the year ended 30 June 2020, it was discovered that errors had been made in the...
-
Bristols Bicycles maintains inventory records under the perpetual inventory system. At 30 June 2019, the inventory balance determined by the system showed a value of $300 000. However, on conducting...
Study smarter with the SolutionInn App