Q3 COMPUTER FORMATTING AND PRINTING WORKSHEETS

Apply cell styles

      1. Select the cell that you want to format.

2. On the Home tab, in the Styles group, click the (a)   drop-down arrow, and select the cell style that you want to apply.

 

Apply table styles

      1. Select any cell within the table or range of cells you want to format as a table.

2. On the Home tab, in the Styles group, click the (a)   drop-down arrow, and select the cell style that you want to apply.

To apply a document theme

(separate your answers with comma)

      1. On the Page layout tab, in the Themes group, click ____________________.

2. Click the document that you want to use.

3. If a document theme that you want to use is not listed, click ____________________ to find it on your computer or network.

(a)  

Format Cells

(separate your answers with comma)

      1. Select the ____________________ or range you will format.

2. On the Home tab, in the Cells group, click the ____________________ drop-down arrow the select Format cells.

3. In the Format Cells dialog box, you can apply or change the cell formats such as: number, alignment, font, border, fill and protection.

(a)  

Add a border

(separate your answers with comma)

      1. Select the cells that you want to modify.

2. Click the ____________________ drop-down arrow on the ____________________ tab. The Borders drop-down menu will appear.

3. Select the border style you want to use.

(a)  

Print one or several worksheets

(separate your answers with comma)

      1. Select the worksheets that you want to print.

2. Click the File tab, and then click ____________________ or simply press Ctrl + P.

3. You can adjust the ____________________ before you click the Print button.

(a)