[Mar-2024] Free MO-200 Exam Questions MO-200 Actual Free Exam Questions
Verified MO-200 dumps and 32 unique questions
NEW QUESTION # 14
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 # 15
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 # 16
On the ''Instructional Hours'' worksheet, modify the chart to display ''Hours'' as the Primary Vertical Axis Title.
Check the Solution below.
Answer:
Explanation:
Click on the green plus sign and press axis titles.
NEW QUESTION # 17
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 # 18
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 # 19
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 # 20
On the ''New Policies'' worksheet, add a Total Row to the table. Configure the Total Row to display the number of new policies for each month and for the 6-month total.
Check the Solution below.
Answer:
Explanation:
Click design and press total row. Click and drag.
NEW QUESTION # 21
On the ''Prices'' worksheet, apply the Title style to cell A1.
Check the Solution below.
Answer:
Explanation:
Home Tab/ Styles group/ cell styles
NEW QUESTION # 22
On the ''Instructional Hours'' worksheet, adjust the width of columns B,G to exactly 12.
Check the Solution below.
Answer:
Explanation:
Home tab, cells group, click format. Click column width.
NEW QUESTION # 23
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 # 24
At NOD Publishers, you are preparing a workbook for the company's annual review.
On
the ''Summary worksheet, from the existing text in cell A2, insert a hyperlink to
''http://www:nodpublishers.com with a ScreenTip that displays ''Company Website''.
Check the Solution below.
Answer:
Explanation:
Insert, hyperlink.
NEW QUESTION # 25
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.
Answer:
Explanation:
=_*_
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
......
Latest 100% Passing Guarantee - Brilliant MO-200 Exam Questions PDF: https://examsdocs.dumpsquestion.com/MO-200-exam-dumps-collection.html