Labour Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: suredis

Microsoft MO-200 Microsoft Excel (Excel and Excel 2019) Exam Practice Test

Page: 1 / 4
Total 35 questions

Microsoft Excel (Excel and Excel 2019) Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$47.25  $134.99

PDF Study Guide

  • Product Type: PDF Study Guide
$40.25  $114.99
Question 1

You are compiling data about courses at Bellows College.

On the ‘’Last Semester’’ worksheet configure A3:F3 to automatically wrap the text.

Options:

Question 2

On the ‘’Enrollment Summary’’ worksheet, apply the Style 7 chart and the Monochromatic Palette 6 color to the chart.

Options:

Question 3

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,’’

Options:

Question 4

On the ‘’New Policies’’ worksheet, change the elements displayed on the chart by changing the chart layout to Layout 3.

Options:

Question 5

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.’’

Options:

Page: 1 / 4
Total 35 questions