MO-200-Full-File.pdf
Q: 1
On the ‘’New Policies’’ worksheet, change the elements displayed on the chart by changing the chart
layout to Layout 3.
Your Answer
Q: 2
On the ‘’Orders’’ worksheet, filter the table data to display only the orders from ‘’Alpine SKI House.’’
Your Answer
Q: 3
On the ‘’Next Semester’’ worksheet, create a Clustered Column chart that displays the ‘’Program’’
names and the ‘’Average Cost per student’’ dat
a. Place the chart to the right of the table. The exact size and position of the chart do not matter.
Your Answer
Q: 4
On the ‘’Summary’’ worksheet, expand the chart to include the ‘’Current Year’ data.
Your Answer
Q: 5
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’’.
Your Answer
Q: 6
On the ‘’New Policies’’ worksheet, add a Total Row to the table. Configure the Total Row to display
the number of new policies for each month and for the 6-month total.
Your Answer
Q: 7
On the ‘’Revenue’’ worksheet, convert cells A3:B7 to a table with headers. Apply the Green, Table
Style Light 14 style.
Your Answer
Q: 8
On the ‘’Last Semester’’ worksheet, remove the table row that contains ‘’ Agriculture’’ data. Do not
change outside the table.
Your Answer
Q: 9
https://www.validexamdumps.com/MO-200.html
www.dumpsplanet.com
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,’’
Your Answer
Q: 10
Remove hidden properties and personal information from the workbook. Do not remove any other
content.
Your Answer
Question 1 of 10
