Filter table data. a. Apply a filter so only the rows containing Channel City and Gulverton appear. b. Apply a custom filter to the filtered table that displays only those items whose Balance Due...

Filter table data.

a. Apply a filter so only the rows containing Channel City and Gulverton appear.

b. Apply a custom filter to the filtered table that displays only those items whose Balance Due amount is greater than $300. Enter your name in cell A25 of the worksheet.

c. Click the PAGE LAYOUT tab, click the Orientation list arrow in the Page Setup group, then click Landscape.

d. View the worksheet in Page Break Preview. Drag the dotted blue bar to the right so all the columns in the table fit on one page.

 e. View the worksheet in Print Preview, then adjust the scaling so all columns fit on one sheet

. f. Compare your completed worksheet to FIGURE H-26. Save your changes, close the workbook, then exit Excel. Submit your completed workbook to your instructor.