Full MO-200 Practice Test and 32 unique questions with explanations waiting just for you!
Microsoft Office Specialist Dumps MO-200 Exam for Full Questions - Exam Study Guide
NEW QUESTION 19
On the ''Enrollment Summary'' worksheet, apply the Style 7 chart and the Monochromatic Palette 6 color to the chart.
Check the Solution below.
Answer:
Explanation:
Click and press chart design. Press chart 7. Click change colors.
NEW QUESTION 20
On the 'Enrolment Summary'' worksheet, name the range A3:B7 ''Enrollment'', Check the Solution below.
Answer:
Explanation:
Select the range and type the name
NEW QUESTION 21
On the ''Revenue'' worksheet, convert cells A3:B7 to a table with headers. Apply the Green, Table Style Light 14 style.
Check the Solution below.
Answer:
Explanation:
Select a cell within your data. Press home and then format as table. Click the table style and select your range.
NEW QUESTION 22
On the 'Comparison' chart sheet, swap the data the axis.
Check the Solution below.
Answer:
Explanation:
Right click and open axis options. Check the box that says values in reverse order.
NEW QUESTION 23
You are compiling class data to present to the enrollment director at the School of Fine Art.
On the ''Substitutes'' worksheet beginning at cell A1, import the data from the Substitutes text file in the Documents folder. Use the first row of the data source as headers.
Check the Solution below.
Answer:
Explanation:
File. Open.
Topic 4, Book SalesCase Study
Exhibit.
NEW QUESTION 24
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.
Answer:
Explanation:
Click wrap text.
NEW QUESTION 25
On the ''Classes'' worksheet, convert the table to a cell rang. Keep the formatting.
Check the Solution below.
Answer:
Explanation:
design, convert to range
NEW QUESTION 26
On the ''Contact'' worksheet, in the ''Email Address'' column, use a functional to construct email addresses for each person using the first name and ''@humongousinsurance.com,'' Check the Solution below.
Answer:
Explanation:
=LOWER(LEFT(FIRST), LAST), "@domain.com"
NEW QUESTION 27
You are updating the sales spreadsheet for an online clothing store.
On the "Quote'' worksheet move the cells E8:F32 up to correct the alignment by deleting cells E7:F7.
Check the Solution below.
Answer:
Explanation:
Select and press delete on the home tab.
NEW QUESTION 28
You are revising a sales summary report for Northwind Traders.
On the ''Summary'' worksheet, in cells F4:F11, use conditional formatting to apply the Yellow Fill with Dark Yellow Text format to cells that contain values greater than ''$5,000,000.'' Check the Solution below.
Answer:
Explanation:
Conditional formatting, highlight cell rules, greater than and then pick the color.
Topic 2, Clothing Orders
Exhibit.
NEW QUESTION 29
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.
Check the Solution below.
Answer:
Explanation:
=COUNTIFS(***
NEW QUESTION 30
You are analyzing insurance sales data for the first six months of the year.
On the ''New Policies'' worksheet change the horizontal alignment of the ''Agent'' names to Left (Indent).
Set the indent to 1.
Check the Solution below.
Answer:
Explanation:
In the alignment tab, click increase indent.
NEW QUESTION 31
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.
Answer:
Explanation:
=IF(inventory level<15%), "low", ""). Select and drag to apply to other rows
Topic 3, Class ScheduleCase Study
Exhibit.
NEW QUESTION 32
......
Authentic Best resources for MO-200 Online Practice Exam: https://www.torrentvalid.com/MO-200-valid-braindumps-torrent.html