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

The video tutorial covers the use of custom fields in project management, focusing on formulas. It introduces the Switch function as a simpler alternative to nested IF statements, allowing for more expressions. The tutorial provides a step-by-step guide to implementing the Switch function, using cost variance as an example. It also highlights resources for further learning about project functions and demonstrates how to add graphical indicators to enhance data visualization.

What is a key advantage of using the SWITCH function over nested IF statements?

• It uses less memory.

• It is easier to read.

• It allows for more than three expressions.

• It is faster to execute.

In the context of the SWITCH function, what does the expression-value pair represent?

• A condition and its corresponding output.

• A variable and its type.

• A function and its return value.

• A formula and its syntax.

What is the output when the cost variance is less than or equal to 0 in the SWITCH function example?

• R

• A

• G

• B

What should you do if you receive a warning message after clicking OK on a formula?

• Restart the application.

• Recheck the formula for errors.

• Contact technical support.

• Ignore it and proceed.

What is the purpose of the tooltips option in graphical indicators?

• To increase the size of the indicators.

• To change the color of the indicators.

• To add animations to the indicators.

• To display the underlying data value.

What graphical indicator is used for a value of 'A' in the RAG Auto field?

• Green square

• Amber square

• Red square

• Blue square

What is recommended to do if you want to learn more about different formulas in Project?

• Consult a colleague.

• Attend a workshop.

• Watch more video tutorials.

• Read the help files on Project functions for custom fields.