For Expert help and assignment handling,
1
C268 Spreadsheets Practice Test Questions
and Answers (100% Correct Answers) Already
Graded A+
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.Ans: =AVERAGE('Past
Events'!C4:C103) for each column
© 2026 Assignment Expert
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
Guru01 - Stuvia
for Excel 2007 users: Excel 2007 does not support a specific function to
calculate sample standard deviations. Use the STDEV function
instead.)Ans: =STDEV.S('Past Events'!C4:C103) for each column
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.)Ans:
=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.Ans: =CORREL('Past Events'!$C$4:$C$103,'Past
Events'!D4:D103)
, For Expert help and assignment handling,
2
The sales for which product type are most highly correlated with
attendance? Select the correct answer from the drop-down list in cell
L32.Ans: Food (highest correlation number)
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.Ans: =FORECAST($I$13,'Past
Events'!D4:D103,'Past Events'!$C$4:$C$103)
© 2026 Assignment Expert
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.Ans: =I16+J8
Guru01 - Stuvia
(sales forecast + 95% confidence interval)
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.Ans: =I16-J8
(sales forecast - 95% confidence interval)
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.Ans: <5% chance
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.Ans: =I16
(calculated previously)
1
C268 Spreadsheets Practice Test Questions
and Answers (100% Correct Answers) Already
Graded A+
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.Ans: =AVERAGE('Past
Events'!C4:C103) for each column
© 2026 Assignment Expert
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
Guru01 - Stuvia
for Excel 2007 users: Excel 2007 does not support a specific function to
calculate sample standard deviations. Use the STDEV function
instead.)Ans: =STDEV.S('Past Events'!C4:C103) for each column
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.)Ans:
=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.Ans: =CORREL('Past Events'!$C$4:$C$103,'Past
Events'!D4:D103)
, For Expert help and assignment handling,
2
The sales for which product type are most highly correlated with
attendance? Select the correct answer from the drop-down list in cell
L32.Ans: Food (highest correlation number)
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.Ans: =FORECAST($I$13,'Past
Events'!D4:D103,'Past Events'!$C$4:$C$103)
© 2026 Assignment Expert
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.Ans: =I16+J8
Guru01 - Stuvia
(sales forecast + 95% confidence interval)
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.Ans: =I16-J8
(sales forecast - 95% confidence interval)
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.Ans: <5% chance
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.Ans: =I16
(calculated previously)
