Online Access Free MO-200 Exam Questions

You are analyzing insurance sales data for the first six months of the year.
On the ''New Policies'' worksheet change the horizontal alignment of the ''Agent'' names to Left (Indent).
Set the indent to 1.
Check the Solution below.

From the ''Graduation'' worksheet. Move the chart to a new chart sheet named ''Graduation Chart.'' Check the Solution below.

On the ''Sales'' worksheet, in the 'City Code'' column, modify the formula to display the letters in unpercase.
Check the Solution below.

On the ''Authors'' worksheet, in the ''Bonus'' column, use a function to display ''500'' if the ; Books Sold' is greater than 10,000. Otherwise, display ''100''.
Check the Solution below.

On the ''Contact'' worksheet, in the ''Email Address'' column, use a functional to construct email addresses for each person using the first name and ''@humongousinsurance.com,'' Check the Solution below.