Excel for Project Management

What is a Project Charter?

Document setting expectations for how stakeholders will communicate and what information they'll receive or provide

Hierarchical decomposition of the work executed by the project team

Statement of the scope, objectives, and people who are participating in a project

To work with and analyze a set of data with ease, turn a range of cells into a _____________________.

Chart

Table

Timeline

Which Excel feature allows you to pick an item from a list that you create?

Drop-down list

Slicer

PivotTable

What is an Issues Log? Select the correct answer and click Submit.

List used to identify potential risks in a project

List that helps managers track issues that occur in a project

Document that lists issues you have with your stakeholders

What does WBS stand for?

Work Breakdown Structure

Work Breakdown Summary

Work Basic Structure

How do you calculate the Risk Score?

Probability x Expected Value

Impact x Expected Value

Impact x Probability

What Excel feature provides buttons you can click to filter tables?

Slicers

Data Validation

What-If Analysis

Information