4/9/25, 8:57 AM WGU C268 Study Guide for EXCEL PA
WGU C268 | PA and OA | Study Guide | Questions and
Answers | 2025 Update | 100% Correct.
Correct 83
Incorrect 00
83 Correct terms
Questions and answers
Term
table 4. Reference the appropriate field in table 2 as your range and
the "Difficulty" rating in table 4 as your criteria.
Give this one a go later!
=SUMIF(D$40:D$46,G46,E$40:
=sumif(d$40:d$46,g46,e$40:e$47)
E$46)
,4/9/25, 8:57 AM WGU C268 Study Guide for EXCEL PA
=sumif(d$40:d$46,g46,e$40:e$45) =sumif(d$40:d$46,g45,e$40:e$46)
Don't know?
2 of 83
Term
Use the HLOOKUP function to complete the "Hourly Wage" column
of table 1. Use the "Employee" column of table 1 as the lookup_value
and the "Employee Wage Information" above table 1 as your
reference table.
Give this one a go later!
=hlookup(d16, E$11:h$12, 2,true) =hlookup(d16, E$11:h$12, 3,false)
=HLOOKUP(D16, E$11:H$12,
=hlookup(d16, E$11:h$12, 1,true)
2,False)
Don't know?
,4/9/25, 8:57 AM WGU C268 Study Guide for EXCEL PA
3 of 83
Term
Calculate the commissions paid for each product type. The
commissions paid are calculated as the expected sales for each
product type times the commission percentage from the "Model
Inputs" section of the model.
Give this one a go later!
Programs=C15*C5
Programs=c15-c16 Food=d15-d16
Food=D15*D5
Merchandise=e15-e16
Merchandise=E15*E5
Programs=c17-c24 Food=d17-d24 Programs=i16+j8 Food=j16+k8
Merchandise=e17-e24 Merchandise=k16+l8
Don't know?
4 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 go later!
, 4/9/25, 8:57 AM WGU C268 Study Guide for EXCEL PA
Programs=I16-J8
Programs=c15c5 Food=d15d5
Food=J16-K8
Merchandise=e15*e5
Merchandise=K16-L8
Programs=c17-c24 Food=d17-d24 Programs=i16 Food=j16
Merchandise=e17-e24 Merchandise=k16
Don't know?
5 of 83
Term
Copy the balance amount calculation down to complete the
balance column of the amortization table.
Give this one a go later!
Paste down column .
Drag from c19:j19 and click on quick analysis. select on line graph. click on the
numbers and then click on select data. change the name to the dates of table 1
=google!$c$7:$j$7.
Copy and paste down.
=or(g16>3,h16=3)
Don't know?
WGU C268 | PA and OA | Study Guide | Questions and
Answers | 2025 Update | 100% Correct.
Correct 83
Incorrect 00
83 Correct terms
Questions and answers
Term
table 4. Reference the appropriate field in table 2 as your range and
the "Difficulty" rating in table 4 as your criteria.
Give this one a go later!
=SUMIF(D$40:D$46,G46,E$40:
=sumif(d$40:d$46,g46,e$40:e$47)
E$46)
,4/9/25, 8:57 AM WGU C268 Study Guide for EXCEL PA
=sumif(d$40:d$46,g46,e$40:e$45) =sumif(d$40:d$46,g45,e$40:e$46)
Don't know?
2 of 83
Term
Use the HLOOKUP function to complete the "Hourly Wage" column
of table 1. Use the "Employee" column of table 1 as the lookup_value
and the "Employee Wage Information" above table 1 as your
reference table.
Give this one a go later!
=hlookup(d16, E$11:h$12, 2,true) =hlookup(d16, E$11:h$12, 3,false)
=HLOOKUP(D16, E$11:H$12,
=hlookup(d16, E$11:h$12, 1,true)
2,False)
Don't know?
,4/9/25, 8:57 AM WGU C268 Study Guide for EXCEL PA
3 of 83
Term
Calculate the commissions paid for each product type. The
commissions paid are calculated as the expected sales for each
product type times the commission percentage from the "Model
Inputs" section of the model.
Give this one a go later!
Programs=C15*C5
Programs=c15-c16 Food=d15-d16
Food=D15*D5
Merchandise=e15-e16
Merchandise=E15*E5
Programs=c17-c24 Food=d17-d24 Programs=i16+j8 Food=j16+k8
Merchandise=e17-e24 Merchandise=k16+l8
Don't know?
4 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 go later!
, 4/9/25, 8:57 AM WGU C268 Study Guide for EXCEL PA
Programs=I16-J8
Programs=c15c5 Food=d15d5
Food=J16-K8
Merchandise=e15*e5
Merchandise=K16-L8
Programs=c17-c24 Food=d17-d24 Programs=i16 Food=j16
Merchandise=e17-e24 Merchandise=k16
Don't know?
5 of 83
Term
Copy the balance amount calculation down to complete the
balance column of the amortization table.
Give this one a go later!
Paste down column .
Drag from c19:j19 and click on quick analysis. select on line graph. click on the
numbers and then click on select data. change the name to the dates of table 1
=google!$c$7:$j$7.
Copy and paste down.
=or(g16>3,h16=3)
Don't know?
