WGU C268 SPREADSHEETS
COMPREHENSIVE ASSESSMENT SCRIPT
VERIFIED QUESTIONS COMPLETE
ANSWERS GRADED APLUS
◉ 10. Use the SUMIF function to complete the "Total Hours"
column in table 3. Reference the appropriate field in table 1 as
your range and the "Employee" names in table 3 as your criteria.
Answer: =sumif(D$16:D$35, G39, E$16:E$35)
◉ 11. 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.
Answer: =SUMIF(D$16:D$35,G39,N$16:N$35)
◉ 12. Use the COUNTIF function to complete the "# of Touch-ups"
column in table 4. Reference the appropriate field in table 2 as
your range and the "Difficulty" rating in table 4 as your criteria.
Answer: =COUNTIF(D$40:D$46,G46)
◉ 13. Use the SUMIF function to complete the "Cost Touch-ups"
column in table 4. Reference the appropriate field in table 2 as
your range and the "Difficulty" rating in table 4 as your criteria.
Answer: =SUMIF(D$40:D$46,G46,E$40:E$46)
,◉ 14. 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)
◉ GOOGLE 1. Construct a column chart to examine the total
annual revenue for Google, Inc. from 2003 to 2010, using the data
in table 1 (range C12:J12). Format the chart with the title "Total
Google Revenue" and the years across the horizontal axis. Do not
include a legend. Note: in order for the grading engine to identify
the chart for grading, the title must be precisely, "Total Google
Revenue" (without the quotes).
Answer: Drag from C12:J12 and click on quick analysis. Click on
bar graphs. Click on numbers below graph and click select data.
Click on edit drag on Table 1 (Quarters) =Google!$C$7:$J$7 (The
Dates).
◉ 2. Add a linear trendline to the "Total Google Revenue" chart.
Answer: Click on design and then add chart element. Click on
trendline then click on linear.
◉ 3. Construct a stacked column chart to compare the revenue
totals for each year, using the quarterly revenue totals (range
C8:J11). Format the chart with the title "Google Revenue by
Quarter," the year as the horizontal axis, and a legend that depicts
each quarter using the text labels provided in the tables. Do not
, include the total annual revenue (range C12:J12) in the chart.
Note: in order for the grading engine to identify the chart for
grading, the title must be precisely, "Google Revenue by Quarter"
(without the quotes).
Answer: Drag from C8:J11 and click on quick analysis. Click on
chart then more charts. Then click on stack columns. Then click
on the numbers logo underneath the bar graph to get to the select
data logo. Then click on edit and drag on Table 2 Segment
=Google!$C$15:$J$15 (The Dates). After click on the series logo
and then click select data. Click Series 1 and edit it as Total Q1
Revenue (=Google!$B$8).
◉ 4. Construct a pie chart to compare the business segments for
2010 (range J16:J18). Format the chart with the title "Google
Revenue by Business Segment" a legend that depicts each
business segment, and data labels with the percentage for each
segment on the chart. Note: in order for the grading engine to
identify the chart for grading, the title must be precisely, "Google
Revenue by Business Segment" (without the quotes).
Answer: 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.
◉ 5. Construct a line chart to examine the total annual revenue for
Google, Inc. from 2003 to 2010 (use the data in table 2 - range
C19:J19). Format the chart with the title on top "Google Revenue
Line" and the years across the horizontal axis. Do not include a
COMPREHENSIVE ASSESSMENT SCRIPT
VERIFIED QUESTIONS COMPLETE
ANSWERS GRADED APLUS
◉ 10. Use the SUMIF function to complete the "Total Hours"
column in table 3. Reference the appropriate field in table 1 as
your range and the "Employee" names in table 3 as your criteria.
Answer: =sumif(D$16:D$35, G39, E$16:E$35)
◉ 11. 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.
Answer: =SUMIF(D$16:D$35,G39,N$16:N$35)
◉ 12. Use the COUNTIF function to complete the "# of Touch-ups"
column in table 4. Reference the appropriate field in table 2 as
your range and the "Difficulty" rating in table 4 as your criteria.
Answer: =COUNTIF(D$40:D$46,G46)
◉ 13. Use the SUMIF function to complete the "Cost Touch-ups"
column in table 4. Reference the appropriate field in table 2 as
your range and the "Difficulty" rating in table 4 as your criteria.
Answer: =SUMIF(D$40:D$46,G46,E$40:E$46)
,◉ 14. 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)
◉ GOOGLE 1. Construct a column chart to examine the total
annual revenue for Google, Inc. from 2003 to 2010, using the data
in table 1 (range C12:J12). Format the chart with the title "Total
Google Revenue" and the years across the horizontal axis. Do not
include a legend. Note: in order for the grading engine to identify
the chart for grading, the title must be precisely, "Total Google
Revenue" (without the quotes).
Answer: Drag from C12:J12 and click on quick analysis. Click on
bar graphs. Click on numbers below graph and click select data.
Click on edit drag on Table 1 (Quarters) =Google!$C$7:$J$7 (The
Dates).
◉ 2. Add a linear trendline to the "Total Google Revenue" chart.
Answer: Click on design and then add chart element. Click on
trendline then click on linear.
◉ 3. Construct a stacked column chart to compare the revenue
totals for each year, using the quarterly revenue totals (range
C8:J11). Format the chart with the title "Google Revenue by
Quarter," the year as the horizontal axis, and a legend that depicts
each quarter using the text labels provided in the tables. Do not
, include the total annual revenue (range C12:J12) in the chart.
Note: in order for the grading engine to identify the chart for
grading, the title must be precisely, "Google Revenue by Quarter"
(without the quotes).
Answer: Drag from C8:J11 and click on quick analysis. Click on
chart then more charts. Then click on stack columns. Then click
on the numbers logo underneath the bar graph to get to the select
data logo. Then click on edit and drag on Table 2 Segment
=Google!$C$15:$J$15 (The Dates). After click on the series logo
and then click select data. Click Series 1 and edit it as Total Q1
Revenue (=Google!$B$8).
◉ 4. Construct a pie chart to compare the business segments for
2010 (range J16:J18). Format the chart with the title "Google
Revenue by Business Segment" a legend that depicts each
business segment, and data labels with the percentage for each
segment on the chart. Note: in order for the grading engine to
identify the chart for grading, the title must be precisely, "Google
Revenue by Business Segment" (without the quotes).
Answer: 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.
◉ 5. Construct a line chart to examine the total annual revenue for
Google, Inc. from 2003 to 2010 (use the data in table 2 - range
C19:J19). Format the chart with the title on top "Google Revenue
Line" and the years across the horizontal axis. Do not include a
