Create A New File Based On The Inventory List Template

Question: Hide the column showing 2016 data and the bonus rate.

Answer: You clicked cell B1, right clicked the column B header. In the Col Header Right-Click menu, you clicked the Hide menu item.

Question: In cell D15, enter a formula using a counting function to count the number of cells in the Billable? column (cells D2:D14) that are not blank.

Answer:

Question: Set row 1 to print on every page.

Answer:

Question: Set the print area so only the selected cells will print.

Answer: You clicked the back arrow button. In the Page Layout Ribbon Tab in the Page Setup Ribbon Group, you clicked the Print Area button. In the Print Area menu, you clicked the Set Print Area menu item.

Question: Change the color of the sheet tab for the Dec 18 worksheet to Green, Accent 6, Lighter 80% (the last option in the second row of theme colors).

Answer: You right clicked the Dec 18 tab. In the Tab Right Click menu in the Tab Color menu, you selected the Green, Accent 6, Lighter 80% color option.