Microsoft Project 2021 From Beginners to Advanced - Calculated Custom Field - Part 1

The video tutorial explains how to manage RAG status in a project by first manually entering it and then automating the process using a formula based on cost performance. It covers setting up a cost table, understanding variance, and creating a custom field for automatic RAG status. The tutorial also demonstrates building and refining a formula using the IF function, similar to Excel, to calculate RAG status based on cost variance. Finally, it shows how to make final adjustments and display the RAG Auto status.

What does RAG status stand for in project management?

• Review, Analyze, Guide

• Risk, Assessment, Goal

• Ready, Active, Gone

• Red, Amber, Green

Why did the project decide to automate the RAG status calculation?

• To reduce manual errors

• To save time on data entry

• To base it on cost performance

• To improve team communication

What does a positive variance in the cost table indicate?

• The task is completed

• The task is on schedule

• The task is under budget

• The task is over budget

Which function is used to create a formula for RAG status calculation?

• SUM

• IF

• COUNT

• AVERAGE

What is the RAG status for a task with a cost variance of $500?

• Red

• Blue

• Amber

• Green

What does the RAG status 'G' signify in terms of cost variance?

• Cost variance is positive

• Cost variance is zero or negative

• Cost variance is exactly $1000

• Cost variance exceeds $1000

What is the purpose of using a nested IF statement in the RAG status formula?

• To simplify the formula

• To handle multiple conditions

• To reduce calculation time

• To improve readability

What happens to the original RAG column after the new RAG Auto column is created?

• It is duplicated

• It is renamed

• It is hidden

• It is deleted

How is the RAG status 'R' determined in the formula?

• Cost variance is zero

• Cost variance is less than $1000

• Cost variance exceeds $1000

• Cost variance is negative

What is the final step after setting up the RAG Auto column?

• Add more tasks

• Switch back to entry table view

• Delete the cost table

• Export the data