74-343 · Question #7
You are a project manager who uses Project Standard 2013, and your task list includes a flag field that indicates, with Yes or No, if a non-summary task represents a physical deliverable. Your…
Sign in or unlock 74-343 to reveal the answer and full explanation for question #7. The question stem and answer options stay visible for context.
Question
You are a project manager who uses Project Standard 2013, and your task list includes a flag field that indicates, with Yes or No, if a non-summary task represents a physical deliverable. Your project involves several tasks marked as deliverables, and management requires you to track how many deliverables are completed. The deliverable is considered completed when the Percent complete field is 100%. You need to create a formula to calculate the total number of deliverables that are completed. Which two steps should you perform? (Each correct answer presents part of the solution. Choose two.)
Options
- AUse the following formula: IIf([Physical Deliverable]=Yes And [% Complete]=100,1,0).
- BSet Calculation for tasks and summary groups to Sum.
- CUse the following formula: IIf([Physical Deliverable]=Yes And [% Complete]=100,0,1).
- DSet Calculation for tasks and summary groups to Count All.
Unlock 74-343 to see the answer
You've previewed enough free 74-343 questions. Unlock 74-343 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.