WGU C268 PA EXAM STUDY GUIDE FOR EXCEL
WITH 100% COMPLETE SOLUTION
Correct 83
100%
Incorrect 00
Your answers
1 of 83
Term
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 for Excel 2007 users:
Excel 2007 does not support a specific function to calculate
sample standard deviations. Use the STDEV function instead.)
Give this one a try later!
, 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)
=AVERAGE('Past Events'!C4:C103)
=STDEV.S('Past Events'!C4:C103)
Programs=FORECAST(I$13,'Past Events'!D4:D103,'Past Events'!
C4:C103)Food=FORECAST(I$13,'Past Events'!E4:E103,'Past Events'!
C4:C103)Merchandise=FORECAST(I$13,'Past Events'!F4:F103,'Past Events'!
C4:C103)
Don't know?
2 of 83
Term
Copy the balance amount calculation down to complete the
balance column of the amortization table.
Give this one a try later!
Paste down column .
Drag from J16:J18 and click on quick analysis. Then insert a pie chart. Click on
the numbers the click on select data. Click edit drag from Table 2 =Google!
$B$16:$B$18
, (The Names). Then click on the pie graph and add chart element, add data
labels, and inside ends. Then click on format data labels. change it to
percentage.
=Countif(B16:D35,G39)
Copy and paste down.
Don't know?
3 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 try later!
=HLOOKUP(D16, E$10:H$11, 2, False) =HLOOKUP(D16, E$11:H$12, 1, True)
=HLOOKUP(D16,
E$11:H$12, =HLOOKUP(D16, E$11:H$12, 3, False)
2,False)
Don't know?
, 4 of 83
Term
Use the SUMIF function to complete the "Total Pay" column in
table 3. Reference the "Employee" field in table 1 as your range,
the "Employee" names in table 3 as your criteria, and the "Total
Pay" field in table 1 as your sum_range.
Give this one a try later!
=sumif(d$15:d$34,g39,n$15:n$34) =sumif(d$16:d$35,g39,m$16:m$35)
=sumif(d$16:d$35,g40,n$16:n$35)
=SUMIF(D$16:D$35,G39,N$1
6:N$
35)
Don't know?
5 of 83
Term
Which type of event ("Concert," "Sporting Event," or "Other
Event") has the largest average attendance? Select your
answer from the drop- down list in cell J20.
Give this one a try later!
WITH 100% COMPLETE SOLUTION
Correct 83
100%
Incorrect 00
Your answers
1 of 83
Term
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 for Excel 2007 users:
Excel 2007 does not support a specific function to calculate
sample standard deviations. Use the STDEV function instead.)
Give this one a try later!
, 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)
=AVERAGE('Past Events'!C4:C103)
=STDEV.S('Past Events'!C4:C103)
Programs=FORECAST(I$13,'Past Events'!D4:D103,'Past Events'!
C4:C103)Food=FORECAST(I$13,'Past Events'!E4:E103,'Past Events'!
C4:C103)Merchandise=FORECAST(I$13,'Past Events'!F4:F103,'Past Events'!
C4:C103)
Don't know?
2 of 83
Term
Copy the balance amount calculation down to complete the
balance column of the amortization table.
Give this one a try later!
Paste down column .
Drag from J16:J18 and click on quick analysis. Then insert a pie chart. Click on
the numbers the click on select data. Click edit drag from Table 2 =Google!
$B$16:$B$18
, (The Names). Then click on the pie graph and add chart element, add data
labels, and inside ends. Then click on format data labels. change it to
percentage.
=Countif(B16:D35,G39)
Copy and paste down.
Don't know?
3 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 try later!
=HLOOKUP(D16, E$10:H$11, 2, False) =HLOOKUP(D16, E$11:H$12, 1, True)
=HLOOKUP(D16,
E$11:H$12, =HLOOKUP(D16, E$11:H$12, 3, False)
2,False)
Don't know?
, 4 of 83
Term
Use the SUMIF function to complete the "Total Pay" column in
table 3. Reference the "Employee" field in table 1 as your range,
the "Employee" names in table 3 as your criteria, and the "Total
Pay" field in table 1 as your sum_range.
Give this one a try later!
=sumif(d$15:d$34,g39,n$15:n$34) =sumif(d$16:d$35,g39,m$16:m$35)
=sumif(d$16:d$35,g40,n$16:n$35)
=SUMIF(D$16:D$35,G39,N$1
6:N$
35)
Don't know?
5 of 83
Term
Which type of event ("Concert," "Sporting Event," or "Other
Event") has the largest average attendance? Select your
answer from the drop- down list in cell J20.
Give this one a try later!
