Microsoft Excel (Excel and Excel 2019) - MO-200 Exam Practice Test
From the ''Graduation'' worksheet. Move the chart to a new chart sheet named ''Graduation Chart.'' Check the Solution below.
Correct Answer:
Right click on the chart. Click move chart. Click new sheet and rename it.
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.
Correct Answer:
=IF(books sold>10,000, "500", "100"). Select and drag to apply to other rows
On the ''Prices'' worksheet, in the ''Tax column, enter a formula that multiples the value in the ''Unit Price'' column by cell L2.
Check the Solution below.
Check the Solution below.
Correct Answer:
=_*_
You are compiling data about courses at Bellows College.
On the ''Last Semester'' worksheet configure A3:F3 to automatically wrap the text.
Check the Solution below.
On the ''Last Semester'' worksheet configure A3:F3 to automatically wrap the text.
Check the Solution below.
Correct Answer:
Click wrap text.