Microsoft MO-200 Microsoft Excel (Excel and Excel 2019) Exam Practice Test

Page: 1 / 14
Total 35 questions

Question 1

On the 'Enrolment Summary'' worksheet, name the range A3:B7 ''Enrollment'',



Answer : A

Question 2

On the ''Revenue'' worksheet, convert cells A3:B7 to a table with headers. Apply the Green, Table Style Light 14 style.



Answer : A

Question 3

On the ''Last Semester'' worksheet, remove the table row that contains '' Agriculture'' data. Do not change outside the table.



Answer : A

Question 4

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.



Answer : A

Question 5

On the ''Enrollment Summary'' worksheet, apply the Style 7 chart and the Monochromatic Palette 6 color to the chart.



Answer : A

Page:    1 / 14   
Total 35 questions