Free Microsoft Excel (Excel and Excel 2019) Exam MO-200 Exam Practice Test
MO-200 Exam Features
In Just $59 You can Access
- All Official Question Types
- Interactive Web-Based Practice Test Software
- No Installation or 3rd Party Software Required
- Customize your practice sessions (Free Demo)
- 24/7 Customer Support
Total Questions: 35
-
On the ''Summary'' worksheet, expand the chart to include the ''Current Year' data.
Answer: A Next Question -
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).
Answer: A Next Question -
On the ''Enrollment'' worksheet, in cells G5:G25, insert Column sparkliness to compare the last, current, and next term values for each class period.
Answer: A Next Question -
On the ''Last Semester'' worksheet, remove the table row that contains '' Agriculture'' data. Do not change outside the table.
Answer: A Next Question -
On the ''Revenue'' worksheet, convert cells A3:B7 to a table with headers. Apply the Green, Table Style Light 14 style.
Answer: A Next Question -
On the ''Summary' worksheet, in cell B15, use a function to display the highest sales amount from the ''Total Sales'' column.
Answer: A Next Question -
On the ''Prices'' worksheet, apply the Title style to cell A1.
Answer: A Next Question -
On the ''Orders'' worksheet, filter the table data to display only the orders from ''Alpine SKI House.''
Answer: A Next Question -
On the ''Next Semester'' worksheet, create a Clustered Column chart that displays the ''Program'' names and the ''Average Cost per student'' data. Place the chart to the right of the table. The exact size and position of the chart do not matter.
Answer: A Next Question -
On the ''New Policies'' worksheet, in the ''Inactive Months column, use a function to count the number of months with no new policies, by Agent.
Answer: A Next Question
Total Questions: 35