MO-200 Exam Question 6
On the ''New Policies'' worksheet, change the elements displayed on the chart by changing the chart layout to Layout 3.
Check the Solution below.
Check the Solution below.
MO-200 Exam Question 7
You are compiling data about courses at Bellows College.
On the ''Last Semester'' worksheet configure A3:F3 to automatically wrap the text.
Check the Solution below.
On the ''Last Semester'' worksheet configure A3:F3 to automatically wrap the text.
Check the Solution below.
MO-200 Exam Question 8
On the ''Sales'' worksheet, in the 'City Code'' column, modify the formula to display the letters in unpercase.
Check the Solution below.
Check the Solution below.
MO-200 Exam Question 9
You are revising a sales summary report for Northwind Traders.
On the ''Summary'' worksheet, in cells F4:F11, use conditional formatting to apply the Yellow Fill with Dark Yellow Text format to cells that contain values greater than ''$5,000,000.'' Check the Solution below.
On the ''Summary'' worksheet, in cells F4:F11, use conditional formatting to apply the Yellow Fill with Dark Yellow Text format to cells that contain values greater than ''$5,000,000.'' Check the Solution below.
MO-200 Exam Question 10
From the ''Graduation'' worksheet. Move the chart to a new chart sheet named ''Graduation Chart.'' Check the Solution below.