WGU C268 Spreadsheets |PA| Pre-
Assessment | Actual Questions and
Answers Latest Updated
(Graded A+)
Correct 83
Incorrect 0
C268 Spreadsheets | Pre-Assessment
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,G39,N$16:N$
=sumif(d$16:d$35,g40,n$16:n$35)
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!
Assessment | Actual Questions and
Answers Latest Updated
(Graded A+)
Correct 83
Incorrect 0
C268 Spreadsheets | Pre-Assessment
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,G39,N$16:N$
=sumif(d$16:d$35,g40,n$16:n$35)
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!
