WGU C268 STUDY GUIDE FOR EXCEL PA
FINAL TEST 2026 QUESTIONS WITH
CORRECT ANSWERS GRADED A+
• Use the AVERAGEIF function to complete the "Average Hours/Job"
column in table 4. Reference the appropriate field in table 1 as your range
and the "Difficulty" rating in table 4 as your criteria..
Answer: =AVERAGEIF($G$16:$G$35,G46,$E$16:$E$35) Gets the
average of values in G16-G35, for value in G46, averages values in
E16-E35
• Calculate the total operating expenses for each product type. This is the sum
of salary expenses (yet to be calculated), commissions, and the fixed costs
for each product type..
Answer: Programs=SUM(C21,C22,C23) Food==SUM(D21,D22,D23)
Merchandise= =SUM(E21,E22,E23)
• SPENDING 1. Use the LEN function in cell D10 to determine the number
of characters in the statement template in cell D9..
Answer: =LEN(D9)
• Calculate the gross profit for each product. The gross profit is calculated as
the sales minus the COGS for each product..
Answer: Programs=C15-C16 Food=D15-D16 Merchandise=E15-E16
• Use the SEARCH function in cell D11 to determine the position of the "#"
character in the statement template (cell D9)..
Answer: =SEARCH("#",D9)
• 13. Which product generates the largest gross profit? Select the correct
answer from the drop-down list in cell L38..
Answer: Merchandise
• Check to see if the total interest calculation in the amortization table is
, correct. The total interest paid is also equal to the difference between the
total amount paid over the course of the loan and the original loan amount.
Insert a formula into cell G14 to calculate the difference between the total
amount paid and the original loan amount. Notice the negative sign
associated with the original loan amount. This value should equal the total
interest calculated using the amortization table..
Answer: =G12+C11
• Use the SEARCH function in cell D11 to determine the position of the "#"
character in the statement template (cell D9)..
Answer: =SEARCH("#",D9) 23 Searches for the # sign in cell D9 and
displays position of character
• Copy the Interest amount calcualtion down to complete the "interest"
column of the amortization table..
Answer: Paste down column .
• Calculate the number of employees that are needed to work the event for
each type of product. This is calculated as the profit before the arena fee for
each type of product, times the employees (% of expected profit) for each
product type from the "Model Inputs" section of the worksheet. Because you
cannot hire a fraction of an employee, round your calculations up to the next
whole number..
Answer: Programs=ROUNDUP(C26*C7,0) Food=ROUNDUP(D26*D7,0)
Merchandise=ROUNDUP(E26*E7,0)
• 13. 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..
Answer: =CONCAT(D$13,D18,D$14,C18,D$15,J18)
FINAL TEST 2026 QUESTIONS WITH
CORRECT ANSWERS GRADED A+
• Use the AVERAGEIF function to complete the "Average Hours/Job"
column in table 4. Reference the appropriate field in table 1 as your range
and the "Difficulty" rating in table 4 as your criteria..
Answer: =AVERAGEIF($G$16:$G$35,G46,$E$16:$E$35) Gets the
average of values in G16-G35, for value in G46, averages values in
E16-E35
• Calculate the total operating expenses for each product type. This is the sum
of salary expenses (yet to be calculated), commissions, and the fixed costs
for each product type..
Answer: Programs=SUM(C21,C22,C23) Food==SUM(D21,D22,D23)
Merchandise= =SUM(E21,E22,E23)
• SPENDING 1. Use the LEN function in cell D10 to determine the number
of characters in the statement template in cell D9..
Answer: =LEN(D9)
• Calculate the gross profit for each product. The gross profit is calculated as
the sales minus the COGS for each product..
Answer: Programs=C15-C16 Food=D15-D16 Merchandise=E15-E16
• Use the SEARCH function in cell D11 to determine the position of the "#"
character in the statement template (cell D9)..
Answer: =SEARCH("#",D9)
• 13. Which product generates the largest gross profit? Select the correct
answer from the drop-down list in cell L38..
Answer: Merchandise
• Check to see if the total interest calculation in the amortization table is
, correct. The total interest paid is also equal to the difference between the
total amount paid over the course of the loan and the original loan amount.
Insert a formula into cell G14 to calculate the difference between the total
amount paid and the original loan amount. Notice the negative sign
associated with the original loan amount. This value should equal the total
interest calculated using the amortization table..
Answer: =G12+C11
• Use the SEARCH function in cell D11 to determine the position of the "#"
character in the statement template (cell D9)..
Answer: =SEARCH("#",D9) 23 Searches for the # sign in cell D9 and
displays position of character
• Copy the Interest amount calcualtion down to complete the "interest"
column of the amortization table..
Answer: Paste down column .
• Calculate the number of employees that are needed to work the event for
each type of product. This is calculated as the profit before the arena fee for
each type of product, times the employees (% of expected profit) for each
product type from the "Model Inputs" section of the worksheet. Because you
cannot hire a fraction of an employee, round your calculations up to the next
whole number..
Answer: Programs=ROUNDUP(C26*C7,0) Food=ROUNDUP(D26*D7,0)
Merchandise=ROUNDUP(E26*E7,0)
• 13. 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..
Answer: =CONCAT(D$13,D18,D$14,C18,D$15,J18)
