Computer Applications I

Back to November

Entry Task

Instructions

Assignment

Open Gradebook.

Make the following changes:

*Merge and Center cells A1:H1

• Change the Font Size in cell A1 to 14

• Bold the text in cell A1

• Change the Fill Color in cell A1 to Dark Blue.

• Change the Font Color in cell A1 to Yellow.

*Insert a row above 3

• Insert the number 100 in each cell for cells B3:G3

• Center Align the text in cell B3:G3

• In cell A3, put the word Value.

*In Cell H3 Sum values in cells B3:G3

• Use Fill Command to fill the formula in cell H3 to cell H4:H10.

*In cell I4 figure the student's percentage.  Divide H4 (Student's total points) by H3 (Total Value of the Quizzes)

• Change the formula in cell I4 to have cell H3 as an absolute value (Hint = $).

• Use Fill Command to fill the formula in cell I4 to cell I5:I10.

• Change the cell format in cells I4:I10 to Percentage with 1 decimal place.

*In cell B11 use a FUNCTION to average the values in cells B4:B10.

• Use Fill Command to fill the formula in cell B11 to cells C11:I11

*Add border to cells A1:I10.

*Landscape the worksheet.

*Print the document.

*Display formulas. (Ctrl+`) and adjust the column width so the printout is only two pages and all formulas can be read.

*Print the document showing formulas.