BIS 155 owner of three clothing stores

$6.00

BIS 155 owner of three clothing stores
(TCO 5) You are the owner of three clothing stores and you would like to see how much…

Description

BIS 155 owner of three clothing stores

BIS 155 owner of three clothing stores

A+ Final Exam

(TCO 5) You are the owner of three clothing stores and you would like to see how much combined profit you made from your three stores. Below are three worksheets titled “John”, “Bob”, and “Ruth” which show the ‘Total Sales’ during the months of January and February.

Using the three worksheets shown above, you will create a new worksheet called “2014” which will consolidate and summarize the information from the stores of John, Bob, and Ruth. The new worksheet will look similar to what you see below.

Part 1. Write out a 3-D formula using the SUM function as if it were in (Cell B2) of worksheet “2014” that will calculate the Total Shirt Sales for John, Bob, and Ruth. Write the formula so that it may be copied to the month of February (Cell B3) without modification.

A 3-D formula will be…

Part 2. Write out a worksheet reference formula without the SUM function as if it were in (Cell C2) of worksheet “2014” that will calculate the Total Pant Sales for John, Bob, and Ruth. Write the formula so that it may be copied to the month of February (Cell C3) without modification.

= CountIf(Sheet…

Part 3. Now that there are Total Shirt Sales and Total Pant Sales for January and February in the “2014” worksheet, it is time to calculate CLOTHING TOTAL in all four worksheets (“John”, “Bob”, “Ruth”, and “2014”). Explain how you will complete this step without retyping the formula in each worksheet. Discuss the advantages of doing it this way and describe any pitfalls that might take place.

To calculate the clothing total, one can comfortably use the content in the …

Part 4. Write out a formula using the SUM function as if it were in (Cell D2) of ALL worksheets that will calculate the CLOTHING TOTAL. Write the formula so that it may be copied to the month of February (Cell D3) and to the CLOTHING TOTAL YEARLY TOTAL (Cell D4) without modification. Also, write out a formula using the SUM function as if it were in (Cell B4) of ALL worksheets that will calculate the YEARLY TOTAL for Total Shirt Sales. Write the formula so that it may be copied to YEARLY TOTAL for Total Pant Sales (Cell C4) without modification.

=Sumif(Sheet…

Part 5. You are interested in viewing the contents of all four worksheets (John, Bob, Ruth, and 2014) side-by-side on the screen. Describe the steps that will arrange the worksheet tabs this way and discuss the advantages of doing this.

Basically, this will involve viewing of the …