WGU C268 ACTUAL EXAMS TEST PAPER QUESTIONS
AND ANSWERS SURE A+
✔✔Which product will require the fewest employees? Select the correct answer from
the drop-down list in cell L40. - ✔✔Programs
✔✔Calculate the salary expenses for each product type. This is calculated as the
number of employees needed for each product type times the salary (per employee) in
the "Model Inputs" section. (Employees make the same salary despite the product
type.) This will create a circular reference in your worksheet. You will need to change
the options in Excel to appropriately account for the circular reference. - ✔✔=C28*$C$8
✔✔Complete the "Sales" portion of the "Profit Summary" section of the worksheet by
calculating the total sales for all products from the "Gross Profit" section of the model. -
✔✔=SUM(C15:E15)
✔✔Complete the "Gross Profit" portion of the "Profit Summary" section of the worksheet
by totaling the gross profit for all products from the "Gross Profit" section of the model. -
✔✔=SUM(C17:E17)
, ✔✔Complete the "Total Operating Expenses" portion of the "Profit Summary" section of
the worksheet by calculating the total operating expenses for all products from the
"Operating Expenses" section of the model. - ✔✔=SUM(C21,C22,C23)
✔✔Complete the "Profit before Arena Fee" portion of the 'Profit Summary" section of the
worksheet by calculating the total profit before the arena fee for all products from the
"Operating Expenses" section of the model. - ✔✔=C17-C24
✔✔Complete the "Arena Fee" portion of the "Profit Summary" section of the model by
referencing the arena fee from the "Model Inputs" section of the worksheet. - ✔✔=C9
✔✔Calculate the "Net Profit" portion of the "Profit Summary" section of the model by
subtracting the arena fee from the profit before the arena fee. - ✔✔=C35-C36
✔✔Complete the data table in the "What-if Analysis" section of the worksheet to
compare the net profit for various values of the attendance forecast and the arena fee. -
✔✔1.) Find Net Profit
2.)Select all the cells in the table
3.) Go to Data in Menu
4.) Click on "What If Analysis"
5.) Click on Data Table
6.) "Row Input Cell" -$I$13 (Attendance),"Column Input Cell"-$C$9 (Arena Fee)
✔✔Would the event be profitable with a $150,000 arena fee if 15,000 people were in
attendance? Select the correct answer from the drop-down list in cell L42. - ✔✔No
✔✔Use the event data on the "Past Events" worksheet (range A3:G103) to construct a
PivotTable that will calculate the average attendance for each type of event. Place the
PivotTable on a new worksheet. Use the "Type" field as a row label for the analysis.
Rename the new worksheet "PT1" (without the quotes). - ✔✔1.)Filters-Event
2.)Rows-Type
3.)Values: Summarize Values By Average of Attendance
✔✔Which type of event ("Concert," "Sporting Event," or "Other Event") has the largest
average attendance? Select your answer from the drop-down list in cell J20. -
✔✔Concert
✔✔Use the event data on the "Past Events" worksheet (range A3:G103) to construct a
PivotTable that will calculate the total merchandise sales for events with "Excellent"
crowd size. Place the PivotTable on a new worksheet. Use "Type" as a row label and
"Crowd Size" as a report filter for the analysis. Rename the new worksheet "PT2"
(without the quotes). - ✔✔1.) Filters- Crowd Size
2.) Rows- Type
3.) Values- Sum of Merchandise
AND ANSWERS SURE A+
✔✔Which product will require the fewest employees? Select the correct answer from
the drop-down list in cell L40. - ✔✔Programs
✔✔Calculate the salary expenses for each product type. This is calculated as the
number of employees needed for each product type times the salary (per employee) in
the "Model Inputs" section. (Employees make the same salary despite the product
type.) This will create a circular reference in your worksheet. You will need to change
the options in Excel to appropriately account for the circular reference. - ✔✔=C28*$C$8
✔✔Complete the "Sales" portion of the "Profit Summary" section of the worksheet by
calculating the total sales for all products from the "Gross Profit" section of the model. -
✔✔=SUM(C15:E15)
✔✔Complete the "Gross Profit" portion of the "Profit Summary" section of the worksheet
by totaling the gross profit for all products from the "Gross Profit" section of the model. -
✔✔=SUM(C17:E17)
, ✔✔Complete the "Total Operating Expenses" portion of the "Profit Summary" section of
the worksheet by calculating the total operating expenses for all products from the
"Operating Expenses" section of the model. - ✔✔=SUM(C21,C22,C23)
✔✔Complete the "Profit before Arena Fee" portion of the 'Profit Summary" section of the
worksheet by calculating the total profit before the arena fee for all products from the
"Operating Expenses" section of the model. - ✔✔=C17-C24
✔✔Complete the "Arena Fee" portion of the "Profit Summary" section of the model by
referencing the arena fee from the "Model Inputs" section of the worksheet. - ✔✔=C9
✔✔Calculate the "Net Profit" portion of the "Profit Summary" section of the model by
subtracting the arena fee from the profit before the arena fee. - ✔✔=C35-C36
✔✔Complete the data table in the "What-if Analysis" section of the worksheet to
compare the net profit for various values of the attendance forecast and the arena fee. -
✔✔1.) Find Net Profit
2.)Select all the cells in the table
3.) Go to Data in Menu
4.) Click on "What If Analysis"
5.) Click on Data Table
6.) "Row Input Cell" -$I$13 (Attendance),"Column Input Cell"-$C$9 (Arena Fee)
✔✔Would the event be profitable with a $150,000 arena fee if 15,000 people were in
attendance? Select the correct answer from the drop-down list in cell L42. - ✔✔No
✔✔Use the event data on the "Past Events" worksheet (range A3:G103) to construct a
PivotTable that will calculate the average attendance for each type of event. Place the
PivotTable on a new worksheet. Use the "Type" field as a row label for the analysis.
Rename the new worksheet "PT1" (without the quotes). - ✔✔1.)Filters-Event
2.)Rows-Type
3.)Values: Summarize Values By Average of Attendance
✔✔Which type of event ("Concert," "Sporting Event," or "Other Event") has the largest
average attendance? Select your answer from the drop-down list in cell J20. -
✔✔Concert
✔✔Use the event data on the "Past Events" worksheet (range A3:G103) to construct a
PivotTable that will calculate the total merchandise sales for events with "Excellent"
crowd size. Place the PivotTable on a new worksheet. Use "Type" as a row label and
"Crowd Size" as a report filter for the analysis. Rename the new worksheet "PT2"
(without the quotes). - ✔✔1.) Filters- Crowd Size
2.) Rows- Type
3.) Values- Sum of Merchandise
