Microsoft Excel (Excel and Excel 2019) - MO-200 Exam Practice Test
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.
Correct Answer:
=LOWER(LEFT(FIRST), LAST), "@domain.com"
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.
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.
Correct Answer:
Insert, hyperlink.
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.
Check the Solution below.
Correct Answer:
=IF(inventory level<15%), "low", ""). Select and drag to apply to other rows
Topic 3, Class ScheduleCase Study
Exhibit.
Topic 3, Class ScheduleCase Study
Exhibit.
On the ''Orders'' worksheet, filter the table data to display only the orders from ''Alpine SKI House.'' Check the Solution below.
Correct Answer:
On the data tab, click filter. Display only alpine.