Required information

To complete this activity, you will need to have Excel installed on your computer. This activity requires you to work in Excel and answer questions in Connect. You will read a brief scenario and then download an Excel file that you will need to answer the required questions.

For Requirements $1$ and $2,$ you will begin by viewing brief video tutorials explaining how to use PivotTables and PivotCharts. You will then use what you learned to work directly in Excel to answer required questions.

For Requirements $3$ and $4,$ you will begin by viewing a brief video tutorial explaining how to use the SUMIF function in Excel. You will use what you learned tio work directly in Excel to answer required questions.

$[$The following information applies to the questions displayed below.$]$

Crispin Company's sales from last year were $$8$ million. The company maintains no beginning or ending inventories. It has assembled all of its costs from last year and would like your assistance in sorting these costs into various categories, depicting them graphically, and preparing traditional and contribution format income statements.