MO-200 Microsoft Excel (Excel and Excel 2019)

Loading demo links...

Showing 1–3 of 5 questions

Question 1 (Clothing Orders)

CORRECT TEXT

On the ‘’Prices’’ worksheet, apply the Title style to cell A1.

Answer is in the explanation below.

Question 2 (Class ScheduleCase Study Exhibit.)

CORRECT TEXT

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.

Answer is in the explanation below.

Question 3 (Sales SummaryCase Study Exhibit.)

CORRECT TEXT

On the ‘’Summary’ worksheet, in cell B15, use a function to display the highest sales amount from the ‘’Total Sales’’ column.

Answer is in the explanation below.