Microsoft
74-343 · Question #7
74-343 Question #7: Real Exam Question with Answer & Explanation
The correct answer is A. Use the following formula: IIf([Physical Deliverable]=Yes And [% Complete]=100,1,0). B. Set Calculation for tasks and summary groups to Sum.. See the full explanation below for the reasoning.
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.
Community Discussion
No community discussion yet for this question.