On the ''Instructional Hours'' worksheet, adjust the width of columns B,G to exactly 12.
Check the Solution below.

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.
Check the Solution below.

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).
Check the Solution below.

On the ''Authors'' worksheet, in the ''Bonus'' column, use a function to display ''500'' if the ; Books Sold' is greater than 10,000. Otherwise, display ''100''.
Check the Solution below.

On the ''Classes'' worksheet, convert the table to a cell rang. Keep the formatting.
Check the Solution below.