WGU C268 COMPREHENSIVE EXAM LATEST
QUESTIONS AND ANSWERS SURE A+
✔✔Use the MINUTE function in cell H18 to calculate the minute portion of the "Time
Stamp" in cell B18. Copy and paste your function down to complete the "Minute" column
of the table. - ✔✔=MINUTE(B18)
✔✔Use the SECOND function in cell I18 to calculate the second portion of the "Time
Stamp" in cell B18. Copy and paste your function down to complete the "Second"
column of the table. - ✔✔=SECOND(B18)
✔✔Use the CONCAT function (or the CONCATENATE function if you are using Excel
2013 or earlier) in cell J18 to create the "Date" by combining the "Month" in cell E18 with
the "Day" in cell F18. "Date" should use this syntax: "Month/Day". Your function should,
therefore, also insert the "/" character between the "Month" and "Day." Copy and paste
your formula down to complete the "Date" column of the table. -
✔✔=CONCAT(E18,"/",F18)
✔✔Use the CONCAT function (or the CONCATENATE function if you are using Excel
2013 or earlier) to create the "Transaction Statement" in cell K18. The statement in cell
K18 should read "I spent $24.06 at merchant #4931 on: 8/1". To make this statement,
combine "Statement P1" in cell D13, the "Amount" in cell D18, "Statement P2" in cell
D14, the "Merchant ID" in cell C18, "Statement P3" in cell D15, and the "Date" in cell
, J18. Copy and paste your function down to complete the "Transaction Statement"
column of the table. - ✔✔=CONCAT($D$13,D18,$D$14,C18,$D$15,J18)
✔✔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. - ✔✔=AVERAGE('Past Events'!C4:C103)
✔✔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.) - ✔✔=STDEV.S('Past Events'!C4:C103)
✔✔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.) -
✔✔=CONFIDENCE.NORM(0.05,J7,$I$3)
✔✔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. - ✔✔=CORREL('Past
Events'!D4:D103,'Past Events'!C4:C103)
✔✔The sales for which product type are most highly correlated with attendance? Select
the correct answer from the drop-down list in cell L32. - ✔✔Food
✔✔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. -
✔✔=FORECAST($I$13,'Past Events'!D4:D103,'Past Events'!C4:C103)
✔✔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. -
✔✔=I16+J8
✔✔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. -
✔✔=I16-J8
QUESTIONS AND ANSWERS SURE A+
✔✔Use the MINUTE function in cell H18 to calculate the minute portion of the "Time
Stamp" in cell B18. Copy and paste your function down to complete the "Minute" column
of the table. - ✔✔=MINUTE(B18)
✔✔Use the SECOND function in cell I18 to calculate the second portion of the "Time
Stamp" in cell B18. Copy and paste your function down to complete the "Second"
column of the table. - ✔✔=SECOND(B18)
✔✔Use the CONCAT function (or the CONCATENATE function if you are using Excel
2013 or earlier) in cell J18 to create the "Date" by combining the "Month" in cell E18 with
the "Day" in cell F18. "Date" should use this syntax: "Month/Day". Your function should,
therefore, also insert the "/" character between the "Month" and "Day." Copy and paste
your formula down to complete the "Date" column of the table. -
✔✔=CONCAT(E18,"/",F18)
✔✔Use the CONCAT function (or the CONCATENATE function if you are using Excel
2013 or earlier) to create the "Transaction Statement" in cell K18. The statement in cell
K18 should read "I spent $24.06 at merchant #4931 on: 8/1". To make this statement,
combine "Statement P1" in cell D13, the "Amount" in cell D18, "Statement P2" in cell
D14, the "Merchant ID" in cell C18, "Statement P3" in cell D15, and the "Date" in cell
, J18. Copy and paste your function down to complete the "Transaction Statement"
column of the table. - ✔✔=CONCAT($D$13,D18,$D$14,C18,$D$15,J18)
✔✔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. - ✔✔=AVERAGE('Past Events'!C4:C103)
✔✔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.) - ✔✔=STDEV.S('Past Events'!C4:C103)
✔✔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.) -
✔✔=CONFIDENCE.NORM(0.05,J7,$I$3)
✔✔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. - ✔✔=CORREL('Past
Events'!D4:D103,'Past Events'!C4:C103)
✔✔The sales for which product type are most highly correlated with attendance? Select
the correct answer from the drop-down list in cell L32. - ✔✔Food
✔✔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. -
✔✔=FORECAST($I$13,'Past Events'!D4:D103,'Past Events'!C4:C103)
✔✔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. -
✔✔=I16+J8
✔✔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. -
✔✔=I16-J8
