Microsoft · MO-200
Preview real exam questions, verified answers and available explanations before choosing a study plan.
|
Lab simulation
Simulation At NOD Publishers, you are preparing a workbook for the company's annual review. Reveal model answer Close model answerInsert, hyperlink.
Lab simulation
Simulation 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,'' Reveal model answer Close model answer=LOWER(LEFT(FIRST), LAST), "@domain.com"
Lab simulation
Simulation On the ''Instructional Hours'' worksheet, adjust the width of columns B,G to exactly 12. Reveal model answer Close model answerHome tab, cells group, click format. Click column width.
Lab simulation
Simulation On the ''Revenue'' worksheet, convert cells A3:B7 to a table with headers. Apply the Green, Table Style Light 14 style. Reveal model answer Close model answerSelect a cell within your data. Press home and then format as table. Click the table style and select your range.
Lab simulation
Simulation You are updating the sales spreadsheet for an online clothing store. Reveal model answer Close model answerSelect and press delete on the home tab. Testlet 1 Topic 2, Sales SummaryCase Study      
Lab simulation
Simulation From the ''Graduation'' worksheet. Move the chart to a new chart sheet named ''Graduation Chart.'' Reveal model answer Close model answerRight click on the chart. Click move chart. Click new sheet and rename it. |