WGU E005 Business Productivity Software Project Guide and
Example Framework | 2026 Update with complete solutions.
1. A project manager at a regional logistics firm is configuring a shared Excel workbook to
track delivery exceptions. Multiple dispatchers will enter data simultaneously, and the manager
needs to prevent conflicting edits while preserving a complete audit trail. Which workbook
configuration strategy best satisfies these requirements?
A. Convert the workbook to an Excel Table, enable Track Changes on a shared network drive, and require all
users to sort by the timestamp column before entering data.
B. Store the workbook in SharePoint, use co-authoring with version history enabled, and apply data validation
to keep entries within acceptable ranges.
C. Protect the worksheet with a password, but leave the shared workbook feature off so that only one user
can edit at a time.
D. Use the legacy Shared Workbook feature and accept that changes are tracked only in the active session.
Answer: B. Store the workbook in SharePoint, use co-authoring with version history enabled,
and apply data validation to keep entries within acceptable ranges.
2. In a spreadsheet used to calculate quarterly commissions, a data analyst notices that the
total column shows a #DIV/0! error for a salesperson with zero sales. The analyst needs to
display 0 instead of the error while keeping the formula intact for future updates. Which
approach is most robust and consistent with best practices for data analysis?
A. Use the IFERROR function to wrap the division formula and output 0 when an error occurs.
B. Manually replace the error cells with the value 0 and remove the formula.
C. Change the number format of the cell to hide the error.
D. Use conditional formatting to turn the error text white.
Answer: A. Use the IFERROR function to wrap the division formula and output 0 when an error
occurs.
3. A business analyst is creating a pivot table to summarize sales data by region and product
category. The source data includes blank cells in the 'Product Category' column, and the
analyst wants to exclude those blank rows from the pivot table without deleting them from the
source data. Which pivot table option or technique is the most efficient?
A. Apply a filter in the pivot table's row labels to deselect '(blank)' items.
B. Replace the blank cells with a placeholder like 'Not specified' in the source data.
C. Use the pivot table's 'Layout & Format' settings to hide blank rows.
D. Manually delete the blank rows from the source data before refreshing the pivot.
Answer: A. Apply a filter in the pivot table's row labels to deselect '(blank)' items.
4. A project manager is developing a project plan for a software implementation and needs to
define the critical path. Which statement correctly describes the role of the critical path in
project scheduling?
A. The critical path is the sequence of activities that has the least amount of slack, and any delay in these
activities will delay the project's finish date.
B. The critical path consists of the activities with the longest individual durations, regardless of their
dependencies.
C. The critical path is the set of activities that are most important for the project's success and must be
completed first.
, D. The critical path is the path with the most float, meaning it can be delayed without affecting the project end
date.
Answer: A. The critical path is the sequence of activities that has the least amount of slack, and
any delay in these activities will delay the project's finish date.
5. During project execution, a stakeholder requests a change that would add two weeks to the
project timeline. The project manager has already obtained sign-off on the baseline. Which is
the FIRST action the project manager should take?
A. Evaluate the impact of the change on scope, schedule, and budget, and prepare a change request for the
change control board.
B. Immediately update the project schedule to reflect the new timeline and notify the team.
C. Reject the request because the project plan is already approved.
D. Conduct a risk assessment for the new change, but do not document it yet.
Answer: A. Evaluate the impact of the change on scope, schedule, and budget, and prepare a
change request for the change control board.
6. A project team is using a Gantt chart in Microsoft Project to track task progress. Which view
or feature in MS Project provides the most comprehensive view of task dependencies, critical
path, and resource overallocation simultaneously?
A. The Network Diagram view, which shows all tasks as boxes with connecting arrows.
B. The Tracking Gantt view combined with the Resource Usage view in a split screen.
C. The Task Usage view alone, which displays work and cost details.
D. The team planner view, which focuses only on assignments.
Answer: B. The Tracking Gantt view combined with the Resource Usage view in a split screen.
7. A business professional is creating a long report in Microsoft Word and needs to apply
consistent formatting to all headings, including font style, size, and color. They also want to
automatically generate a table of contents. Which set of steps is the most efficient and correct?
A. Apply the built-in Heading 1, Heading 2, etc. styles to the headings, and then insert a table of contents from
the References tab.
B. Manually format each heading with the desired fonts and colors, and then insert a table of contents using
manual text fields.
C. Create a custom style called 'MyHeading' and apply it to all headings, then insert a table of contents from
the Home tab.
D. Use the Format Painter to copy formatting from one heading to all others, and then type a static table of
contents.
Answer: A. Apply the built-in Heading 1, Heading 2, etc. styles to the headings, and then insert
a table of contents from the References tab.
8. In a 200-page proposal, the author needs to add page numbers that start at page 1 on the
first page of the main body, with the cover page and table of contents unnumbered. What is the
correct way to achieve this using Word's section and header/footer features?
A. Insert a section break before the main body, unlink the header/footer from the previous section, and set the
page numbering to start at 1 in that section.
B. Insert page numbers in the header of the entire document and then manually delete them from the cover
and TOC pages.
C. Use the 'Different First Page' option, but that only works for the first page of the document, not multiple
front-matter pages.
D. Set the page number format to start at 0, so the first page displays as 1, and then hide the number on the
, first page.
Answer: A. Insert a section break before the main body, unlink the header/footer from the
previous section, and set the page numbering to start at 1 in that section.
9. A document editor frequently uses a set of standard clauses in legal contracts. Which Word
feature automates the insertion of these clauses with a single click, while also allowing updates
to all inserted instances if the clause text changes?
A. Quick Parts !’ Building Blocks Organizer, allowing the user to save each clause as a building block.
B. Use the Insert Object function to embed the clause as an OLE object.
C. Create a macro that types the clause text every time, but the macro is fixed and cannot be updated.
D. Copy and paste the text from a master document whenever needed.
Answer: A. Quick Parts !’ Building Blocks Organizer, allowing the user to save each clause as a
building block.
10. An analyst at a financial firm is examining a dataset of stock returns and needs to calculate
the average return per month conditional on the market being up or down. Which Excel
function or feature would allow the analyst to perform this conditional averaging efficiently
without creating helper columns?
A. Use the AVERAGEIF function which can apply a single condition to a range and calculate the average.
B. Use the AVERAGE function combined with manual filtering of rows.
C. Use the SUMIF function and divide by COUNTIF, but that requires two steps.
D. Use the DAX formula in a pivot table, but that is too complex.
Answer: A. Use the AVERAGEIF function which can apply a single condition to a range and
calculate the average.
11. A supply-chain analyst is evaluating the correlation between advertising spend and sales
revenue across 12 monthly observations. Using Excel's CORREL function, the analyst obtains
a coefficient of 0.85. Which interpretation is correct?
A. There is a strong positive linear relationship between advertising spend and sales revenue.
B. Advertising spend causes sales revenue to increase by 85% on average.
C. 85% of the variation in sales revenue is explained by advertising spend.
D. The correlation is statistically significant at the 0.05 level.
Answer: A. There is a strong positive linear relationship between advertising spend and sales
revenue.
12. A data analyst is using Excel's Power Query to transform a large dataset from multiple CSV
files. Which transformation step best ensures that future data updates are automatically
incorporated into the analysis without manual re-importing?
A. Set the data source to a folder and use the 'Combine Files' feature in Power Query, which merges all files in
the folder into a single table.
B. Import each CSV file individually with the 'Get Data' command and then concatenate with a manual
VLOOKUP.
C. Copy and paste all the data into a single worksheet, then use a pivot table for analysis.
D. Use the Text Import Wizard to import each file, and then copy the data into a master sheet.
Answer: A. Set the data source to a folder and use the 'Combine Files' feature in Power Query,
which merges all files in the folder into a single table.
13. A presentation designer needs to deliver a consistent brand identity across a 30-slide deck
Example Framework | 2026 Update with complete solutions.
1. A project manager at a regional logistics firm is configuring a shared Excel workbook to
track delivery exceptions. Multiple dispatchers will enter data simultaneously, and the manager
needs to prevent conflicting edits while preserving a complete audit trail. Which workbook
configuration strategy best satisfies these requirements?
A. Convert the workbook to an Excel Table, enable Track Changes on a shared network drive, and require all
users to sort by the timestamp column before entering data.
B. Store the workbook in SharePoint, use co-authoring with version history enabled, and apply data validation
to keep entries within acceptable ranges.
C. Protect the worksheet with a password, but leave the shared workbook feature off so that only one user
can edit at a time.
D. Use the legacy Shared Workbook feature and accept that changes are tracked only in the active session.
Answer: B. Store the workbook in SharePoint, use co-authoring with version history enabled,
and apply data validation to keep entries within acceptable ranges.
2. In a spreadsheet used to calculate quarterly commissions, a data analyst notices that the
total column shows a #DIV/0! error for a salesperson with zero sales. The analyst needs to
display 0 instead of the error while keeping the formula intact for future updates. Which
approach is most robust and consistent with best practices for data analysis?
A. Use the IFERROR function to wrap the division formula and output 0 when an error occurs.
B. Manually replace the error cells with the value 0 and remove the formula.
C. Change the number format of the cell to hide the error.
D. Use conditional formatting to turn the error text white.
Answer: A. Use the IFERROR function to wrap the division formula and output 0 when an error
occurs.
3. A business analyst is creating a pivot table to summarize sales data by region and product
category. The source data includes blank cells in the 'Product Category' column, and the
analyst wants to exclude those blank rows from the pivot table without deleting them from the
source data. Which pivot table option or technique is the most efficient?
A. Apply a filter in the pivot table's row labels to deselect '(blank)' items.
B. Replace the blank cells with a placeholder like 'Not specified' in the source data.
C. Use the pivot table's 'Layout & Format' settings to hide blank rows.
D. Manually delete the blank rows from the source data before refreshing the pivot.
Answer: A. Apply a filter in the pivot table's row labels to deselect '(blank)' items.
4. A project manager is developing a project plan for a software implementation and needs to
define the critical path. Which statement correctly describes the role of the critical path in
project scheduling?
A. The critical path is the sequence of activities that has the least amount of slack, and any delay in these
activities will delay the project's finish date.
B. The critical path consists of the activities with the longest individual durations, regardless of their
dependencies.
C. The critical path is the set of activities that are most important for the project's success and must be
completed first.
, D. The critical path is the path with the most float, meaning it can be delayed without affecting the project end
date.
Answer: A. The critical path is the sequence of activities that has the least amount of slack, and
any delay in these activities will delay the project's finish date.
5. During project execution, a stakeholder requests a change that would add two weeks to the
project timeline. The project manager has already obtained sign-off on the baseline. Which is
the FIRST action the project manager should take?
A. Evaluate the impact of the change on scope, schedule, and budget, and prepare a change request for the
change control board.
B. Immediately update the project schedule to reflect the new timeline and notify the team.
C. Reject the request because the project plan is already approved.
D. Conduct a risk assessment for the new change, but do not document it yet.
Answer: A. Evaluate the impact of the change on scope, schedule, and budget, and prepare a
change request for the change control board.
6. A project team is using a Gantt chart in Microsoft Project to track task progress. Which view
or feature in MS Project provides the most comprehensive view of task dependencies, critical
path, and resource overallocation simultaneously?
A. The Network Diagram view, which shows all tasks as boxes with connecting arrows.
B. The Tracking Gantt view combined with the Resource Usage view in a split screen.
C. The Task Usage view alone, which displays work and cost details.
D. The team planner view, which focuses only on assignments.
Answer: B. The Tracking Gantt view combined with the Resource Usage view in a split screen.
7. A business professional is creating a long report in Microsoft Word and needs to apply
consistent formatting to all headings, including font style, size, and color. They also want to
automatically generate a table of contents. Which set of steps is the most efficient and correct?
A. Apply the built-in Heading 1, Heading 2, etc. styles to the headings, and then insert a table of contents from
the References tab.
B. Manually format each heading with the desired fonts and colors, and then insert a table of contents using
manual text fields.
C. Create a custom style called 'MyHeading' and apply it to all headings, then insert a table of contents from
the Home tab.
D. Use the Format Painter to copy formatting from one heading to all others, and then type a static table of
contents.
Answer: A. Apply the built-in Heading 1, Heading 2, etc. styles to the headings, and then insert
a table of contents from the References tab.
8. In a 200-page proposal, the author needs to add page numbers that start at page 1 on the
first page of the main body, with the cover page and table of contents unnumbered. What is the
correct way to achieve this using Word's section and header/footer features?
A. Insert a section break before the main body, unlink the header/footer from the previous section, and set the
page numbering to start at 1 in that section.
B. Insert page numbers in the header of the entire document and then manually delete them from the cover
and TOC pages.
C. Use the 'Different First Page' option, but that only works for the first page of the document, not multiple
front-matter pages.
D. Set the page number format to start at 0, so the first page displays as 1, and then hide the number on the
, first page.
Answer: A. Insert a section break before the main body, unlink the header/footer from the
previous section, and set the page numbering to start at 1 in that section.
9. A document editor frequently uses a set of standard clauses in legal contracts. Which Word
feature automates the insertion of these clauses with a single click, while also allowing updates
to all inserted instances if the clause text changes?
A. Quick Parts !’ Building Blocks Organizer, allowing the user to save each clause as a building block.
B. Use the Insert Object function to embed the clause as an OLE object.
C. Create a macro that types the clause text every time, but the macro is fixed and cannot be updated.
D. Copy and paste the text from a master document whenever needed.
Answer: A. Quick Parts !’ Building Blocks Organizer, allowing the user to save each clause as a
building block.
10. An analyst at a financial firm is examining a dataset of stock returns and needs to calculate
the average return per month conditional on the market being up or down. Which Excel
function or feature would allow the analyst to perform this conditional averaging efficiently
without creating helper columns?
A. Use the AVERAGEIF function which can apply a single condition to a range and calculate the average.
B. Use the AVERAGE function combined with manual filtering of rows.
C. Use the SUMIF function and divide by COUNTIF, but that requires two steps.
D. Use the DAX formula in a pivot table, but that is too complex.
Answer: A. Use the AVERAGEIF function which can apply a single condition to a range and
calculate the average.
11. A supply-chain analyst is evaluating the correlation between advertising spend and sales
revenue across 12 monthly observations. Using Excel's CORREL function, the analyst obtains
a coefficient of 0.85. Which interpretation is correct?
A. There is a strong positive linear relationship between advertising spend and sales revenue.
B. Advertising spend causes sales revenue to increase by 85% on average.
C. 85% of the variation in sales revenue is explained by advertising spend.
D. The correlation is statistically significant at the 0.05 level.
Answer: A. There is a strong positive linear relationship between advertising spend and sales
revenue.
12. A data analyst is using Excel's Power Query to transform a large dataset from multiple CSV
files. Which transformation step best ensures that future data updates are automatically
incorporated into the analysis without manual re-importing?
A. Set the data source to a folder and use the 'Combine Files' feature in Power Query, which merges all files in
the folder into a single table.
B. Import each CSV file individually with the 'Get Data' command and then concatenate with a manual
VLOOKUP.
C. Copy and paste all the data into a single worksheet, then use a pivot table for analysis.
D. Use the Text Import Wizard to import each file, and then copy the data into a master sheet.
Answer: A. Set the data source to a folder and use the 'Combine Files' feature in Power Query,
which merges all files in the folder into a single table.
13. A presentation designer needs to deliver a consistent brand identity across a 30-slide deck
