最新的Microsoft Excel (Excel and Excel 2019) - MO-200免費考試真題
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''.
Check the Solution below.
Check the Solution below.
正確答案:
=IF(books sold>10,000, "500", "100"). Select and drag to apply to other rows
On the ''Last Semester'' worksheet, remove the table row that contains '' Agriculture'' data. Do not change outside the table.
Check the Solution below.
Check the Solution below.
正確答案:
On the home tab, click find and select and click find. Type agriculture and press find all. Select all and then delete them with the home tab by clicking delete sheet rows.
On the 'Comparison' chart sheet, swap the data the axis.
Check the Solution below.
Check the Solution below.
正確答案:
Right click and open axis options. Check the box that says values in reverse order.
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.
正確答案:
Click chart and press "chart design" click style 3.