subject
Business, 19.10.2020 20:01 allisonlillian

Benicio wants to compare the sales of each product in 2021 with the sales in 2020. He has the 2020 sales data stored in a separate workbook. Add the 2020 sales data to the All Locations worksheet as follows:. a. Open the workbook Support_EX19_CS5-8a_2020.xlsx.
b. Return to the All Locations worksheet in the original workbook.
c. In cell G5, enter a formula using an external reference to display the total sales of Mini products in 2020 (cell F5).
d. In the formula in cell G5, change the absolute reference to a mixed reference, with a relative reference to the row number.
e. Fill the range G6:G8 with the formula in cell G5, filling without formatting.
f. Close the workbook Support_EX19_CS5-8a_2020.xlsx.

ansver
Answers: 3

Another question on Business

question
Business, 22.06.2019 00:30
How did lani lazzari show her investors she was a good investment? (site 1)
Answers: 3
question
Business, 22.06.2019 04:30
Galwaysc electronics makes two products. model a requires component a and component c. model b requires component b and component c. new versions of both models are released each year with updated versions of all components. all components are sourced overseas, and abc contracts annually for a quantity of each component before seeing that year’s demand. components are only assembled into finished products once demand for each model is known. for the coming year, alwaysc’s purchasing manner has proposed ordering 500,000 units of component a, 630,000 of component b, and 1,000,000 units of component c. her boss has asked why she has recommended purchasing so much of components a and b when alwaysc will not have enough of component c to fully use all of the inventory of a and b. what factors might the purchasing manager cite to explain her recommended order? explain your reasoning.
Answers: 3
question
Business, 22.06.2019 12:50
You own 2,200 shares of deltona hardware. the company has stated that it plans on issuing a dividend of $0.42 a share at the end of this year and then issuing a final liquidating dividend of $2.90 a share at the end of next year. your required rate of return on this security is 16 percent. ignoring taxes, what is the value of one share of this stock to you today?
Answers: 1
question
Business, 22.06.2019 14:50
Pear co.’s income statement for the year ended december 31, as prepared by pear’s controller, reported income before taxes of $125,000. the auditor questioned the following amounts that had been included in income before taxes: equity in earnings of cinn co. $ 40,000 dividends received from cinn 8,000 adjustments to profits of prior years for arithmetical errors in depreciation (35,000) pear owns 40% of cinn’s common stock, and no acquisition differentials are relevant. pear’s december 31 income statement should report income before taxes of
Answers: 3
You know the right answer?
Benicio wants to compare the sales of each product in 2021 with the sales in 2020. He has the 2020 s...
Questions
question
Mathematics, 23.02.2021 04:20
Questions on the website: 13722359