Universal Containers has a dashboard for Sales Managers to visualize the YoY Growth of their...

To replace null results in the YoY Growth calculation with a 100% value when there is no account in the 'Last Year' column, the correct function to use is:

C: coalesce(). This function is used to return the first non-null value in a list of arguments. In the formula for calculating YoY Growth, it can be used to check for a null value in the 'Last Year' data and replace it with a default value (like 100), effectively handling cases where no comparison data exists.