Business, 28.05.2021 14:00, happy121906

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 Gs, 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

Other questions on the subject: Business

Business, 22.06.2019 05:00, grangian06

Personal financial planning is the process of creating and achieving financial goals? true or false

Answers: 1

continue

Business, 22.06.2019 09:00, nicoleaaliyah

Brian has been working for a few years now and has saved a substantial amount of money. he now wants to invest 50 percent of his savings in a bank account where it will be locked for three years and gain interest. which type of bank account should brian open? a. savings account b. money market account c. checking account d. certificate of deposit

Answers: 1

continue

Business, 22.06.2019 09:40, bennett2968

Boone brothers remodels homes and replaces windows. ace builders constructs new homes. if boone brothers considers expanding into new home construction, it should evaluate the expansion project using which one of the following as the required return for the project?

Answers: 1

continue

Business, 22.06.2019 11:10, nataliahenderso

Which feature is a characteristic of a corporation?

Answers: 1

continue

Do you know the correct answer?

Benicio wants to compare the sales of each product in 2021 with the sales in 2020. He has the 2020 s...