Microsoft MO-200 - Microsoft Excel (Excel and Excel 2019)
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.
On the ‘’Inventory’ chart sheet, insert a chart title above the chart, at the top of the plot area. Display the percentage values as data labels to the right of each data bar.
On the ‘’Summary’’ worksheet, expand the chart to include the ‘’Current Year’ data.
On the ‘’Sales’’ worksheet, in the ‘City Code’’ column, modify the formula to display the letters in unpercase.
On the ‘’Instructional Hours’’ worksheet, adjust the width of columns B,G to exactly 12.
From the ‘’Graduation’’ worksheet. Move the chart to a new chart sheet named ‘’Graduation Chart.’’
On the ‘Enrolment Summary’’ worksheet, name the range A3:B7 ‘’Enrollment’’,
On the ‘’Revenue’’ worksheet, convert cells A3:B7 to a table with headers. Apply the Green, Table Style Light 14 style.
On the ‘’Region 1’’ worksheet, perform a multi-level sort, Sort table data by ‘’Product’’ (A to Z) and then by ‘’Total Sales’’ (Largest to Smallest).
On the ‘Comparison’ chart sheet, swap the data the axis.
