WGU C268 SPREADSHEETS OA AND PA
2026-2027 BANK CURRENTLY TESTING
COMPLETE EXAM QUESTIONS WITH
DETAILED VERIFIED ANSWERS
/EXPERT VERIFIED /ALREADY
GRADED A+
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. -
....ANSWER...=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. -
....ANSWER...=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. - ....ANSWER...=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. -
....ANSWER...=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. -
....ANSWER...=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. -
....ANSWER...=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. -
....ANSWER...=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. -
....ANSWER...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. -
....ANSWER...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). - ....ANSWER. 1.)Filters-
Event
2026-2027 BANK CURRENTLY TESTING
COMPLETE EXAM QUESTIONS WITH
DETAILED VERIFIED ANSWERS
/EXPERT VERIFIED /ALREADY
GRADED A+
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. -
....ANSWER...=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. -
....ANSWER...=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. - ....ANSWER...=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. -
....ANSWER...=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. -
....ANSWER...=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. -
....ANSWER...=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. -
....ANSWER...=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. -
....ANSWER...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. -
....ANSWER...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). - ....ANSWER. 1.)Filters-
Event
