WGU C268 SPREADSHEETS BANK
CURRENTLY TESTING COMPLETE EXAM
QUESTIONS WITH DETAILED VERIFIED
ANSWERS /EXPERT VERIFIED /ALREADY
GRADED A+
Which product generates the largest gross profit? Select the correct answer from
the drop-down list in cell L38. - CORRECT ANSWER ✔✔- Merchandise
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. - CORRECT ANSWER
✔✔- =C15*C5
Enter the fixed costs in the model. Reference the appropriate amount for each
product type in the "Model Inputs" section. - CORRECT ANSWER ✔✔- =C6
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. - CORRECT ANSWER ✔✔- =SUM(C21,C22,C23)
Calculate the profit before the arena fee for each product type. This is the gross
profit minus the total operating expenses for each type of product, including the
salary expenses (yet to be calculated). - CORRECT ANSWER ✔✔- =C17-C24
Pg. 1
, 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.) -
CORRECT ANSWER ✔✔- =CONFIDENCE.NORM(0.05,J7,$I$3)
Would the event be profitable with a $150,000 arena fee if 15,000 people were in
attendance? Select the correct answer from the drop-down list in cell L42. -
CORRECT ANSWER ✔✔- No
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. -
CORRECT ANSWER ✔✔- =CORREL('Past Events'!D4:D103,'Past Events'!C4:C103)
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. -
CORRECT ANSWER ✔✔- =ROUNDUP(C26*C7,0)
Which product will require the fewest employees? Select the correct answer from
the drop-down list in cell L40. - CORRECT ANSWER ✔✔- Programs
Use the LEFT function in cell D13 to return the text "I spent $" from the statement
template in cell D9. Refer to the location of the "$" character you calculated in
cell D12 as the "num_char" argument for your function. - CORRECT ANSWER ✔✔-
=LEFT(D9,D12)
Pg. 2
CURRENTLY TESTING COMPLETE EXAM
QUESTIONS WITH DETAILED VERIFIED
ANSWERS /EXPERT VERIFIED /ALREADY
GRADED A+
Which product generates the largest gross profit? Select the correct answer from
the drop-down list in cell L38. - CORRECT ANSWER ✔✔- Merchandise
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. - CORRECT ANSWER
✔✔- =C15*C5
Enter the fixed costs in the model. Reference the appropriate amount for each
product type in the "Model Inputs" section. - CORRECT ANSWER ✔✔- =C6
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. - CORRECT ANSWER ✔✔- =SUM(C21,C22,C23)
Calculate the profit before the arena fee for each product type. This is the gross
profit minus the total operating expenses for each type of product, including the
salary expenses (yet to be calculated). - CORRECT ANSWER ✔✔- =C17-C24
Pg. 1
, 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.) -
CORRECT ANSWER ✔✔- =CONFIDENCE.NORM(0.05,J7,$I$3)
Would the event be profitable with a $150,000 arena fee if 15,000 people were in
attendance? Select the correct answer from the drop-down list in cell L42. -
CORRECT ANSWER ✔✔- No
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. -
CORRECT ANSWER ✔✔- =CORREL('Past Events'!D4:D103,'Past Events'!C4:C103)
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. -
CORRECT ANSWER ✔✔- =ROUNDUP(C26*C7,0)
Which product will require the fewest employees? Select the correct answer from
the drop-down list in cell L40. - CORRECT ANSWER ✔✔- Programs
Use the LEFT function in cell D13 to return the text "I spent $" from the statement
template in cell D9. Refer to the location of the "$" character you calculated in
cell D12 as the "num_char" argument for your function. - CORRECT ANSWER ✔✔-
=LEFT(D9,D12)
Pg. 2
