Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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,

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.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Primary Science Audit And Test

Authors: Jenny Byrne, Andri Christodoulou, John Sharp

4th Edition

1446282732, 978-1446282731

More Books

Students also viewed these Accounting questions

Question

To find integral of sin(logx) .

Answered: 1 week ago

Question

What is Centrifugation?

Answered: 1 week ago

Question

3. Comment on how diversity and equality should be managed.

Answered: 1 week ago

Question

describe the legislation that addresses workplace equality

Answered: 1 week ago