WGU C268 Study Guide for EXCEL PA
EXAM QUESTIONS WITH CORRECT
SOLUTIONS (VERIFIED ANSWERS)
||100% GUARANTEED PASS||UPDATED
2026/2027 SYLLABUS||<<LATEST
VERSION>>
EVENT PROF 1. In the "Input Analysis" section of the spreadsheet model,
calculate the average attendance and sales for each type of product from the past
events listed in the "Past Events" worksheet. - ANSWER ✓ =AVERAGE('Past
Events'!C4:C103)
2. In the "Input Analysis" section of the spreadsheet model, calculate the sample
standard deviation for attendance and sales for each type of product from the past
events listed on the "Past Events" worksheet. (Note for Excel 2007 users: Excel
2007 does not support a specific function to calculate sample standard deviations.
Use the STDEV function instead.) - ANSWER ✓ =STDEV.S('Past
Events'!C4:C103)
3. In the "Input Analysis" section of the spreadsheet model, calculate the 95%
confidence interval for the sales for each type of product. (You will not calculate a
confidence interval for attendance.) Use the number of events (calculated in cell
I3) as part of your calculations. (Note to Excel 2007 users: the
CONFIDENCE.NORM function is not supported in Excel 2007. Use the
CONFIDENCE function instead.) - ANSWER ✓
=CONFIDENCE.NORM(0.05,J7,I3)
4. In the "Input Analysis" section of the spreadsheet model, calculate the
correlations between the sales of each type of product and event attendance. Use
appropriate ranges from the "Past Event" worksheet for your calculations. -
ANSWER ✓ Programs=CORREL('Past Events'!C4:C103,'Past Events'!D4:D103)
Food=CORREL('Past Events'!C4:C103,'Past Events'!E4:E103)
Merchandise=CORREL('Past Events'!C4:C103,'Past Events'!F4:F103)
, 5. The sales for which product type are most highly correlated with attendance?
Select the correct answer from the drop-down list in cell L32. - ANSWER ✓ Food
6. In the "Input Analysis" section of the spreadsheet model, calculate a sales
forecast for each type of product if expected attendance at the future event is 18000
people. Reference cell I13 (the attendance forecast) for your calculations. -
ANSWER ✓ Programs=FORECAST(I$13,'Past Events'!D4:D103,'Past
Events'!C4:C103)Food=FORECAST(I$13,'Past Events'!E4:E103,'Past
Events'!C4:C103)Merchandise=FORECAST(I$13,'Past Events'!F4:F103,'Past
Events'!C4:C103)
7. In the "Input Analysis" section of the spreadsheet model, calculate the upper
limit for your sales forecast for each type of product if expected attendance at the
future event is 18000 people. Reference the confidence interval you created for
your calculation. - ANSWER ✓ Programs=I16+J8
Food=J16+K8
Merchandise=K16+L8
8. In the "Input Analysis" section of the spreadsheet model, calculate the lower
limit for your sales forecast for each type of product if expected attendance at the
future event is 18000 people. Reference the confidence interval you created for
your calculation. - ANSWER ✓ Programs=I16-J8
Food=J16-K8
Merchandise=K16-L8
9. How likely is it that food sales would exceed $220,000 if attendance is 18,000
people? Select the correct answer from the drop-down list in cell L35.v -
ANSWER ✓ <5% chance
10. In the "Event Profitability Analysis" section of the model, enter the projected
sales for each product type for this event by referencing your sales forecast from
the "Input Analysis" section of the model. - ANSWER ✓ Programs=I16
Food=J16
Merchandise=K16
11. Calculate the cost of goods sold (COGS) for each product. The COGS is
calculated as the sales for each product type times the COGS percentage from the
"Model Inputs" section of the model for that product type.term-55 - ANSWER ✓
Programs=C15*C4
EXAM QUESTIONS WITH CORRECT
SOLUTIONS (VERIFIED ANSWERS)
||100% GUARANTEED PASS||UPDATED
2026/2027 SYLLABUS||<<LATEST
VERSION>>
EVENT PROF 1. In the "Input Analysis" section of the spreadsheet model,
calculate the average attendance and sales for each type of product from the past
events listed in the "Past Events" worksheet. - ANSWER ✓ =AVERAGE('Past
Events'!C4:C103)
2. In the "Input Analysis" section of the spreadsheet model, calculate the sample
standard deviation for attendance and sales for each type of product from the past
events listed on the "Past Events" worksheet. (Note for Excel 2007 users: Excel
2007 does not support a specific function to calculate sample standard deviations.
Use the STDEV function instead.) - ANSWER ✓ =STDEV.S('Past
Events'!C4:C103)
3. In the "Input Analysis" section of the spreadsheet model, calculate the 95%
confidence interval for the sales for each type of product. (You will not calculate a
confidence interval for attendance.) Use the number of events (calculated in cell
I3) as part of your calculations. (Note to Excel 2007 users: the
CONFIDENCE.NORM function is not supported in Excel 2007. Use the
CONFIDENCE function instead.) - ANSWER ✓
=CONFIDENCE.NORM(0.05,J7,I3)
4. In the "Input Analysis" section of the spreadsheet model, calculate the
correlations between the sales of each type of product and event attendance. Use
appropriate ranges from the "Past Event" worksheet for your calculations. -
ANSWER ✓ Programs=CORREL('Past Events'!C4:C103,'Past Events'!D4:D103)
Food=CORREL('Past Events'!C4:C103,'Past Events'!E4:E103)
Merchandise=CORREL('Past Events'!C4:C103,'Past Events'!F4:F103)
, 5. The sales for which product type are most highly correlated with attendance?
Select the correct answer from the drop-down list in cell L32. - ANSWER ✓ Food
6. In the "Input Analysis" section of the spreadsheet model, calculate a sales
forecast for each type of product if expected attendance at the future event is 18000
people. Reference cell I13 (the attendance forecast) for your calculations. -
ANSWER ✓ Programs=FORECAST(I$13,'Past Events'!D4:D103,'Past
Events'!C4:C103)Food=FORECAST(I$13,'Past Events'!E4:E103,'Past
Events'!C4:C103)Merchandise=FORECAST(I$13,'Past Events'!F4:F103,'Past
Events'!C4:C103)
7. In the "Input Analysis" section of the spreadsheet model, calculate the upper
limit for your sales forecast for each type of product if expected attendance at the
future event is 18000 people. Reference the confidence interval you created for
your calculation. - ANSWER ✓ Programs=I16+J8
Food=J16+K8
Merchandise=K16+L8
8. In the "Input Analysis" section of the spreadsheet model, calculate the lower
limit for your sales forecast for each type of product if expected attendance at the
future event is 18000 people. Reference the confidence interval you created for
your calculation. - ANSWER ✓ Programs=I16-J8
Food=J16-K8
Merchandise=K16-L8
9. How likely is it that food sales would exceed $220,000 if attendance is 18,000
people? Select the correct answer from the drop-down list in cell L35.v -
ANSWER ✓ <5% chance
10. In the "Event Profitability Analysis" section of the model, enter the projected
sales for each product type for this event by referencing your sales forecast from
the "Input Analysis" section of the model. - ANSWER ✓ Programs=I16
Food=J16
Merchandise=K16
11. Calculate the cost of goods sold (COGS) for each product. The COGS is
calculated as the sales for each product type times the COGS percentage from the
"Model Inputs" section of the model for that product type.term-55 - ANSWER ✓
Programs=C15*C4
