WGU C268 Intro to Spreadsheets | PA | Pre-Assessment | 83
Questions and Answers | 2026 Update | 100% Correct.
Correct 83
Incorrect 00
WGU C268 Intro to Spreadsheet
83 Correct terms
Questions and answers
Term
, Cash Merchandise
Don't know?
2 of 83
Term
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.
Give this one a try later!
Programs=I16-J8
Programs=C15C4 Food=D15D4
Food=J16-K8
Merchandise=E15*E4
Merchandise=K16-L8
Programs=C17-C24 Food=D17-D24 Programs=C15-C16 Food=D15-D16
Merchandise=E17-E24 Merchandise=E15-E16
Don't know?
, 3 of 83
Term
Which product will require the fewest employees? Select the correct
answer from the drop-down list in cell L40.
Give this one a try later!
Notes Food
Programs Merchandise
Don't know?
4 of 83
Term
Use the event data on the "Past Events" worksheet (range A3:G103) to
construct a PivotTable to show the differences in Total Food Sales for
each Type of Event from the Total Food Sales for the Other Events
type. Place the PivotTable on a new worksheet. Use "Type" as a row
label and an appropriate presentation of "Food" as the "Values" field
for the PivotTable. Rename the new worksheet "PT5" (without the
quotes).
Give this one a try later!
, 1.) Rows- Type
2.) Values- Summarize Values By Sum, Show Values As Difference From Type &
Concert
Concert
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)
No
Don't know?
5 of 83
Term
Use the RIGHT function in cell D15 to return the text "on:" from the
statement template in cell D9. Use the difference between the length
of the statement template (in cell D10) and the location of the "#"
character (in cell D11) as the "num_char" argument.
Give this one a try later!
=right(d9,d11-d10) =mid(d9,d10-d11,5)
Questions and Answers | 2026 Update | 100% Correct.
Correct 83
Incorrect 00
WGU C268 Intro to Spreadsheet
83 Correct terms
Questions and answers
Term
, Cash Merchandise
Don't know?
2 of 83
Term
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.
Give this one a try later!
Programs=I16-J8
Programs=C15C4 Food=D15D4
Food=J16-K8
Merchandise=E15*E4
Merchandise=K16-L8
Programs=C17-C24 Food=D17-D24 Programs=C15-C16 Food=D15-D16
Merchandise=E17-E24 Merchandise=E15-E16
Don't know?
, 3 of 83
Term
Which product will require the fewest employees? Select the correct
answer from the drop-down list in cell L40.
Give this one a try later!
Notes Food
Programs Merchandise
Don't know?
4 of 83
Term
Use the event data on the "Past Events" worksheet (range A3:G103) to
construct a PivotTable to show the differences in Total Food Sales for
each Type of Event from the Total Food Sales for the Other Events
type. Place the PivotTable on a new worksheet. Use "Type" as a row
label and an appropriate presentation of "Food" as the "Values" field
for the PivotTable. Rename the new worksheet "PT5" (without the
quotes).
Give this one a try later!
, 1.) Rows- Type
2.) Values- Summarize Values By Sum, Show Values As Difference From Type &
Concert
Concert
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)
No
Don't know?
5 of 83
Term
Use the RIGHT function in cell D15 to return the text "on:" from the
statement template in cell D9. Use the difference between the length
of the statement template (in cell D10) and the location of the "#"
character (in cell D11) as the "num_char" argument.
Give this one a try later!
=right(d9,d11-d10) =mid(d9,d10-d11,5)
