Use your Excel file to answer the six multiple choice questions below. $($You will have to scroll down to see all of the questions.$)$

Resources

A$.$ Information on how to update Excel and Office $365.$

B$.$ If you do not have Office $365,$ click here to learn how to get it for free.

C$.$ Information on data column headings.

D$.$ Information on addtional data column headings.

Using the pivot table you created for Requirement $2$ in Cabinet Keeper, what were total sales for $2023$ in the Pacific region?

A$.$ $$12,695,423\mathrm{.}71$

B$.$ $$21,358,884\mathrm{.}95$

C$.$ $$8,989,376\mathrm{.}84$

D$.$ $$19,009,984,46$

Using the pivot table you created for Requirement $3$ in Cabinet Keeper, what was the gross profit in $2025?$

A$.$ $$52,088,530\mathrm{.}35$

B$.$ $$63,448,715\mathrm{.}83$

C$.$ $$94,344,556\mathrm{.}98$

D$.$ $$37,259,094\mathrm{.}03$

Using the pivot table you created for Requirement $4$ in Cabinet Keeper, what was the most profitable brand in $2025,$ as measured by gross profit?

A$.$ Classic

B$.$ Contemporary

Using the pivot table you created for Requirement $5$ in Cabinet Keeper, what was the least profitable collection in $2025,$ for the Contemporary brand as measured by the gross profit percentage?

A$.$ Tuscany

B$.$ Somerset

sages

Calculator

Ask my instructor