Check your knowledge

Completed

Answer the following questions to see what you learned.

1.

The finance analyst wants to clean the data in their system to ensure that their budget proposal results are accurate. What should they do?

Change the data in the system so that plenty of variance and outliers are present.

Scrub the data with a sponge.

Ensure that the data is consistent.

2.

Which one of the following best practices is recommended to have the most accurate models in your environment?

Have at least three years of historical data.

Run the Actuals vs. budget proposals weekly.

Limit the departments that are used for running proposals.

3.

What Microsoft product can be used to support editing of various budget proposals that you can run, such as the Original budget, Variance percent, and Percent of budget, side by side?

Power Apps

Report designer

Microsoft Word

You must answer all questions before checking your work.