Pass the Microsoft Office Specialist MO-200 Questions and answers with ExamsMirror

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

You are compiling data about courses at Bellows College.

On the ‘’Last Semester’’ worksheet configure A3:F3 to automatically wrap the text.

On the ‘’New Policies’’ worksheet, in cells J5:J13, insert Win/Loss sparkllines to compare the January through June values.

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,’’

On the ‘’Prices’’ worksheet, in the ‘’Tax column, enter a formula that multiples the value in the ‘’Unit Price’’ column by cell L2.

You are updating the sales spreadsheet for an online clothing store.

On the "Quote’’ worksheet move the cells E8:F32 up to correct the alignment by deleting cells E7:F7.

From the ‘’Graduation’’ worksheet. Move the chart to a new chart sheet named ‘’Graduation Chart.’’

On the ‘’Instructional Hours’’ worksheet, modify the chart to display ‘’Hours’’ as the Primary Vertical Axis Title.

On the ‘’Region 1’’ worksheet, perform a multi-level sort, Sort table data by ‘’Product’’ (A to Z) and then by ‘’Total Sales’’ (Largest to Smallest).

On the ‘Comparison’ chart sheet, swap the data the axis.