Microsoft Excel (Excel and Excel 2019) - MO-200 Exam Practice Test
Remove hidden properties and personal information from the workbook. Do not remove any other content.
Check the Solution below.
Check the Solution below.
Correct Answer:
File, check for issues, inspect, remove all. Click close.
On the ''Prices'' worksheet, apply the Title style to cell A1.
Check the Solution below.
Check the Solution below.
Correct Answer:
Home Tab/ Styles group/ cell styles
On the ''Instructional Hours'' worksheet, modify the chart to display ''Hours'' as the Primary Vertical Axis Title.
Check the Solution below.
Check the Solution below.
Correct Answer:
Click on the green plus sign and press axis titles.
On the ''New Policies'' worksheet, in cells J5:J13, insert Win/Loss sparkllines to compare the January through June values.
Check the Solution below.
Check the Solution below.
Correct Answer:
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
Topic 6, Enrollment