WGU C268 Study Guide for EXCEL PA Questions
with verified correct detailed answers latest
update 2025
22. 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--- correct precise answers ---
=SUMIF(D$16:D$35,G39,N$16:N$35)
23. 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--- correct
precise answers --- =COUNTIF(D$40:D$46,G46)
24. 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--- correct precise
answers --- =SUMIF(D$40:D$46,G46,E$40:E$46)
25. 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---
correct precise answers --- =AVER- AGEIF(G$16:G$35,G46,E$16:E$35)
26. 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)---
correct precise answers --- 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).
27. Add a linear trendline to the "Total Google Revenue" chart---
correct precise answers --- Click on design and then add chart
element. Click on trendline then click on linear.
28. 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)--- correct precise answers --- 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).
29. Construct a pie chart to compare the business segments for 2010
(range J16:J18). Format the chart with the title "Google Revenue by
Business Seg- ment" 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)--- correct precise answers --- 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.
30. 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 legend.
Note: in order for the grading engine to identify the chart for grading,
the title must be precisely, "Google Revenue Line" (without the
quotes)--- correct precise answers --- Drag from C19:J19 and click on
quick analysis. Select on line graph. Click on the numbers and then
with verified correct detailed answers latest
update 2025
22. 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--- correct precise answers ---
=SUMIF(D$16:D$35,G39,N$16:N$35)
23. 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--- correct
precise answers --- =COUNTIF(D$40:D$46,G46)
24. 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--- correct precise
answers --- =SUMIF(D$40:D$46,G46,E$40:E$46)
25. 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---
correct precise answers --- =AVER- AGEIF(G$16:G$35,G46,E$16:E$35)
26. 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)---
correct precise answers --- 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).
27. Add a linear trendline to the "Total Google Revenue" chart---
correct precise answers --- Click on design and then add chart
element. Click on trendline then click on linear.
28. 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)--- correct precise answers --- 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).
29. Construct a pie chart to compare the business segments for 2010
(range J16:J18). Format the chart with the title "Google Revenue by
Business Seg- ment" 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)--- correct precise answers --- 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.
30. 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 legend.
Note: in order for the grading engine to identify the chart for grading,
the title must be precisely, "Google Revenue Line" (without the
quotes)--- correct precise answers --- Drag from C19:J19 and click on
quick analysis. Select on line graph. Click on the numbers and then
