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.
On the ‘’Orders’’ worksheet, filter the table data to display only the orders from ‘’Alpine SKI House.’’
On the ‘’Instructional Hours’’ worksheet, adjust the width of columns B,G to exactly 12.
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 ‘’Sales’’ worksheet, in the ‘City Code’’ column, modify the formula to display the letters in unpercase.