Activity 2 Apply a Theme to a Payroll Worksheet then insert text in cells, apply formatting to the cells and cell contents, You will open a workbook containing a worksheet with payroll Information theme, and then change the theme font and colors. worksheet. A theme is a set of formatting choices that includes a Excel provides a number of themes that can be used to formato theme (a set of lines and fill effects). To apply a theme, click the Pas set of colors). a font theme (a set of heading and body text fonts). and then click the Themes button in the Themes group. At the door and the live preview feature displays the worksheet with the theme 2. Make cell G4 active and then insert a formula that calculates the amount of social 1. Open SBAPayroll and then save it with the name 3-SBAPayroll Hil; you will need to use the mixed cell reference HSII when writing the forma tax. (Multiply the gross pay amount in cell E4 with the social security rate in all 3. Copy the formula in cell G4 to the range G5:G9. 4. Make H4 the active cell and then insert a formula that calculates the net paygros minus withholding and social security tax). 5. Copy the formula in cell H4 to the range H5:H9. d. Click the then clic Tutorial Applying and Modifying Themes Applying a Theme A Themes pointer Hint Apply a theme to give your worksheet a professional look , click the desired applied. Activity 2 Applying a Theme e. cli 11. Sele the 12. Say Act File Home Page (A fonts Themes Marie Once 6. Increase the height of row 1 to 36.00 points. 7. Make cell Al active, click the Middle Align bution in the Alignment group, click the Font Sizeption box arrow, click 18 at the drop-down getic and then click the Bold button. 8. Tomuto & Barnett Associates in cell Al. 9. Setext he range A2:H3 and then click the Bold button in the Font group. 10. Apply a theme and customize the font and colors by completing the following steps: a. Make cell Al active. b. Click the Page Layout tab. c. Click the Themes button in the Themes group, hover the mouse pointer over individual themes at the drop-down gallery to see how they affect the formatting of the worksheet, and then click Wisp. Applyin Format 10c Oro Facet Aa As ogs Aa Activity 2 Apply a Theme to a Payroll Worksheet then insert text in cells, apply formatting to the cells and cell contents, You will open a workbook containing a worksheet with payroll Information theme, and then change the theme font and colors. worksheet. A theme is a set of formatting choices that includes a Excel provides a number of themes that can be used to formato theme (a set of lines and fill effects). To apply a theme, click the Pas set of colors). a font theme (a set of heading and body text fonts). and then click the Themes button in the Themes group. At the door and the live preview feature displays the worksheet with the theme 2. Make cell G4 active and then insert a formula that calculates the amount of social 1. Open SBAPayroll and then save it with the name 3-SBAPayroll Hil; you will need to use the mixed cell reference HSII when writing the forma tax. (Multiply the gross pay amount in cell E4 with the social security rate in all 3. Copy the formula in cell G4 to the range G5:G9. 4. Make H4 the active cell and then insert a formula that calculates the net paygros minus withholding and social security tax). 5. Copy the formula in cell H4 to the range H5:H9. d. Click the then clic Tutorial Applying and Modifying Themes Applying a Theme A Themes pointer Hint Apply a theme to give your worksheet a professional look , click the desired applied. Activity 2 Applying a Theme e. cli 11. Sele the 12. Say Act File Home Page (A fonts Themes Marie Once 6. Increase the height of row 1 to 36.00 points. 7. Make cell Al active, click the Middle Align bution in the Alignment group, click the Font Sizeption box arrow, click 18 at the drop-down getic and then click the Bold button. 8. Tomuto & Barnett Associates in cell Al. 9. Setext he range A2:H3 and then click the Bold button in the Font group. 10. Apply a theme and customize the font and colors by completing the following steps: a. Make cell Al active. b. Click the Page Layout tab. c. Click the Themes button in the Themes group, hover the mouse pointer over individual themes at the drop-down gallery to see how they affect the formatting of the worksheet, and then click Wisp. Applyin Format 10c Oro Facet Aa As ogs Aa