MO-200 Microsoft Excel (Excel and Excel 2019) Questions and Answers

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

On the ‘’Revenue’’ worksheet, convert cells A3:B7 to a table with headers. Apply the Green, Table Style Light 14 style.

On the ‘Comparison’ chart sheet, swap the data the axis.

On the ‘’Projections’ worksheet, in the ‘’Quarter2’’ column, enter a formula that multiples the value in the Quarter 1’’ column by the ‘Q2_increase’ named range. Use the range name in the formula instead of a cell reference or value.

You are updating the sales spreadsheet for an online clothing store.

On the " Quote’’ worksheet move the cells E8:F32 up to correct the alignment by deleting cells E7:F7.

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.

On the ‘’Classes’’ worksheet, convert the table to a cell rang. Keep the formatting.