WGU C268 STUDY GUIDE FOR EXCEL PA
CURRENTLY TESTING COMPLETE EXAM
QUESTIONS WITH DETAILED VERIFIED
ANSWERS /EXPERT VERIFIED /ALREADY
GRADED A+
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. - CORRECT 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.) - CORRECT 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.) -
CORRECT ANSWER ✔✔- =CONFIDENCE.NORM(0.05,J7,I3)
Pg. 1
,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. -
CORRECT 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. - CORRECT 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. -
CORRECT 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. - CORRECT 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
Pg. 2
, future event is 18000 people. Reference the confidence interval you created for
your calculation. - CORRECT 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 - CORRECT
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. - CORRECT 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 - CORRECT
ANSWER ✔✔- Programs=C15*C4
Food=D15*D4
Merchandise=E15*E4
12. Calculate the gross profit for each product. The gross profit is calculated as the
sales minus the COGS for each product. - CORRECT ANSWER ✔✔- Programs=C15-
C16
Food=D15-D16
Merchandise=E15-E16
Pg. 3
CURRENTLY TESTING COMPLETE EXAM
QUESTIONS WITH DETAILED VERIFIED
ANSWERS /EXPERT VERIFIED /ALREADY
GRADED A+
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. - CORRECT 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.) - CORRECT 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.) -
CORRECT ANSWER ✔✔- =CONFIDENCE.NORM(0.05,J7,I3)
Pg. 1
,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. -
CORRECT 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. - CORRECT 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. -
CORRECT 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. - CORRECT 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
Pg. 2
, future event is 18000 people. Reference the confidence interval you created for
your calculation. - CORRECT 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 - CORRECT
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. - CORRECT 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 - CORRECT
ANSWER ✔✔- Programs=C15*C4
Food=D15*D4
Merchandise=E15*E4
12. Calculate the gross profit for each product. The gross profit is calculated as the
sales minus the COGS for each product. - CORRECT ANSWER ✔✔- Programs=C15-
C16
Food=D15-D16
Merchandise=E15-E16
Pg. 3
