MO-200 試験問題を無料オンラインアクセス

On the ''New Policies'' worksheet, in cells J5:J13, insert Win/Loss sparkllines to compare the January through June values.
Check the Solution below.

正解：

Select a blank cell and press insert. Pick win/loss sparklines. Select the data range. Click and drag the bottom right corner for more.
Topic 6, Enrollment

On the ''Prices'' worksheet, in the ''inventory Notice'' column, use a function to display ''Low'' if the '' inventory Level % is below 15%. Otherwise, leave the ''Inventory Notice'' blank.
Check the Solution below.

正解：

=IF(inventory level<15%), "low", ""). Select and drag to apply to other rows
Topic 3, Class ScheduleCase Study
Exhibit.

On the ''New Policies'' worksheet, change the elements displayed on the chart by changing the chart layout to Layout 3.
Check the Solution below.

On the ''Orders'' worksheet, filter the table data to display only the orders from ''Alpine SKI House.'' 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.