Business, 19.10.2020 18:01 madiiiiiii69

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.

Answers: 3

Show answers

Another question on Business

Business, 21.06.2019 20:30

Which of the following government agencies is responsible for managing the money supply in the united states? a. the u.s. mint b. the federal reserve bank c. congress d. the department of the treasury 2b2t

Answers: 3

Answer

Business, 22.06.2019 07:00

Amarket that consists of all possible consumers regardless of their specific needs or wants is a

Answers: 1

Answer

Business, 22.06.2019 11:10

An insurance company estimates the probability of an earthquake in the next year to be 0.0015. the average damage done to a house by an earthquake it estimates to be $90,000. if the company offers earthquake insurance for $150, what is company`s expected value of the policy? hint: think, is it profitable for the insurance company or not? will they gain (positive expected value) or lose (negative expected value)? if the expected value is negative, remember to show "-" sign. no "+" sign needed for the positive expected value

Answers: 2

Answer

Business, 22.06.2019 11:30

Margaret company reported the following information for the current year: net sales $3,000,000 purchases $1,957,000 beginning inventory $245,000 ending inventory $115,000 cost of goods sold 65% of sales industry averages available are: inventory turnover 5.29 gross profit percentage 28% how do the inventory turnover and gross profit percentage for margaret company compare to the industry averages for the same ratios? (round inventory turnover to two decimal places. round gross profit percentage to the nearest percent.)

Answers: 2

Answer

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