Group the Q1 through Q4 worksheets, and then change the color of the Q1:Q4 worksheet tabs to Red. Ungroup the worksheets. On the Q1 worksheet, enter a function in cell H5 to calculate the total cost of the total number of items sold for each item type. Copy the formula through cell range H6:H19. On the Auto Fill Options dialog box, choose Fill Without Formatting. Format cell range H6:H20 with the Accounting Number Format. Group the Q1 through Q4 worksheets. On the Q1 worksheet, select cell range A4:H19, and fill Formats across the worksheets. With the worksheets still grouped, select Q1 worksheet. Select cell range H5:H19, and fill All across the worksheets Q1:Q4. With the worksheets still grouped, select Q1 worksheet. Select cell range A20:H20, and fill All across worksheets Q1:Q4. On the Year worksheet, enter a 3-D SUM function in cell C5 to calculate the total items sold in Q1:Q4. Using the Fill Handle, copy the formula through cell range C6:C19. On the Auto Fill Options, choose Fill Without Formatting. With the range still selected, copy the formula through cell range C5:G19. On the YearLinked worksheet, select cell A4 and create a linked consolidated summary based on position that links to the data to find the total number of items sold for each department each quarter. Reference cell range A4:H20 on the Q1, Q2, Q3, and Q4 worksheets. Use the labels in Top row and Left column. AutoFit columns A:I and then hide columns B:C. Select cell A4 type Item Delete the Prices worksheet. Note the effect of this change on the Q1:Q4 worksheets. Open the downloaded Excel workbook Excel_BU04_Assessment2_OrderCost.xlsx. In Excel_BU04_Assessment2_Order_LastFirst, on the Q1:Year worksheets, in cell range B5:B19, correct the VLOOKUP to reference the PriceList named range (cell range A2:B16) on the Excel BU04_Assessment2_OrderCost.xlsx workbook. Copy the formula without formatting. Close the OrderCost workbook.

Group the Q1 through Q4 worksheets, and then change the color of the Q1:Q4 worksheet tab to Red. Ungroup the worksheets. On the Q1 worksheet, enter a function in cell H5 to calculate the total cost of the total number of items sold for each item type. Copy the formula through cell range H6:H19. On the Auto Fill Options dialog box, choose Fill Without Formatting. Format cell range H6:H20 with the Accounting Number Format. Group the Q1 through Q4 worksheets. On the Q1 worksheet, select cell range A4:H19, and fil Formats across the worksheets. With the worksheets still grouped, select Q1 worksheet. Select cell range H5:H19, and fill All across the worksheets Q1:Q4. With the worksheets still grouped, select Q1 worksheet. Select cell range A20:H20, and fill All across worksheets Q1:Q4. On the Year worksheet, enter a 3-D SUM function in cell C5 to calculate the total items sold in Q1:Q4. Using the Fill Handle, copy the formula through cell range C6:C19. On the Auto Fill Options, choose Fill Without Formatting. With the range still selected, copy the formula through cell range C5:G19. On the YearLinked worksheet, select cell A4 and create a linked consolidated summary based on position that links to the data to find the total number of items sold for each department each quarter. Reference cell range A4:H20 on the Q1, Q2, Q3, and Q4 worksheets. Use the labels in Top row and Left column. AutoFit columns A:I and then hide columns B:C. Select cell A4 type Item Delete the Prices worksheet. Note the effect of this change on the Q1:Q4 worksheets. Open the downloaded Excel workbook Excel_BU04_Assessment2_OrderCost.xisx. In Excel BU04_Assessment2 Order_LastFirst, on the Q1:Year worksheets, in cell range B5:B19, correct the VLOOKUP to reference the PriceList named range (cell range A2:B16) on the Excel_BU04_Assessment2_OrderCost.xlsx workbook. Copy the formula without formatting. Close the OrderCost workbook. Quarter 1 Uniform Orders Yearly Uniform Orders Tops Price Hat $12.95 Long skirt $36.95 Mens Jacket \$ $26.95 Mens long sleeve $14.95 Mens pants \$ \$ 50.95 Mens sweater \$ $2.95 Scarf \$ $11.95 Short skirt \$ 24.95 Short sleeve \$ $10.95 Tie \$ $10.95 Vest $13.95 Womens jacket \$ 23.95 Womens long sleeve \$ 19.95 Womens pants \$ \$45.95 Womens sweater \$ $36,95 Quarter 4 Uniform Orders \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline Item & Price & Sales & & Front Desk & Grounds & Room Keeping & Other & Total \\ \hline Women's long sleeve & 19.95 & & 4 & 3 & 0 & 7 & 1 & \\ \hline Men's long sleeve & 14.95 & & 5 & 3 & 6 & 2 & 0 & \\ \hline Short sleeve & 10.95 & & 1 & 8 & 5 & 6 & 1 & \\ \hline Vest & 13.95 & & 7 & 7 & 4 & 3 & 0 & \\ \hline Women's Jacket & 23.95 & & 4 & 2 & 3 & 1 & 0 & \\ \hline Men's Jacket & 26.95 & & 5 & 1 & 6 & 3 & 0 & \\ \hline Women's sweater & 36.95 & & 3 & 2 & 1 & 1 & 1 & \\ \hline Men's sweater & 42.95 & & 3 & 5 & 5 & 1 & 1 & \\ \hline Women's pants & 45.95 & & 7 & 1 & 1 & 5 & 0 & \\ \hline Men's pants & 50.95 & & 6 & 2 & 3 & 1 & 1 & \\ \hline Long skirt & 36.95 & & 2 & 1 & 0 & 2 & 0 & \\ \hline Short skirt & 24.95 & & 1 & 2 & 0 & 0 & 0 & \\ \hline Hat & 12.95 & & 1 & 0 & 1 & 0 & 1 & \\ \hline Scarf & 11.95 & & 0 & 2 & 2 & 0 & 0 & \\ \hline Tie: & 10.95 & & 2 & 2 & 0 & 0 & 2 & \\ \hline \end{tabular} Quarter 3 Uniform Orders Quarter 2 Uniform Orders