WGU C268 SPREADSHEETS FORMULAE PRACTICE TEST
CORRECTLY SOLVED A+ RATED NEWEST 2025/2026
GUARANTEED PASS ASSURED SUCCESS.
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.
=sumif($d$16:$d$35,g39,n16:n35)
Looks in table range d16-d35, looks for value from g39, adds the
number from table range n16-n35
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.
=countif($d$40:$d$46,g46)
Formula looks at absolute rang of d40-d46, for value in g46
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.
=(sumif($d$40:$d$46,g46,$e$40:$e$46))
Formula looks at table range d40-d46, looks for value in g46, and
then looks at e40-e46
, 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.
=averageif($g$16:$g$35,g46,$e$16:$e$35)
Gets the average of values in g16-g35, for value in g46, averages
values in e16-e35
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).
Highlight c12-j12
Select "insert" from the top ribbon menu
Insert a 2d column chart
Rename the chart name to total google revenue
Single click chart, click the filter icon on the right, click select
data on pop-up menu, click edit in the horizontal axis labels
Select the range c7-j7 to fill in the data in the axis range window.
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,
CORRECTLY SOLVED A+ RATED NEWEST 2025/2026
GUARANTEED PASS ASSURED SUCCESS.
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.
=sumif($d$16:$d$35,g39,n16:n35)
Looks in table range d16-d35, looks for value from g39, adds the
number from table range n16-n35
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.
=countif($d$40:$d$46,g46)
Formula looks at absolute rang of d40-d46, for value in g46
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.
=(sumif($d$40:$d$46,g46,$e$40:$e$46))
Formula looks at table range d40-d46, looks for value in g46, and
then looks at e40-e46
, 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.
=averageif($g$16:$g$35,g46,$e$16:$e$35)
Gets the average of values in g16-g35, for value in g46, averages
values in e16-e35
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).
Highlight c12-j12
Select "insert" from the top ribbon menu
Insert a 2d column chart
Rename the chart name to total google revenue
Single click chart, click the filter icon on the right, click select
data on pop-up menu, click edit in the horizontal axis labels
Select the range c7-j7 to fill in the data in the axis range window.
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,
