Computer Applications I

Back to April

Entry Task

Instructions

Assignment

Open Basketball Statistics - Excel Review

Make the following changes:

*Merge and Center cells A1:L1

• Change the Fill Color in cell A1 to Black

• Change the Font Color in cell Al to White

• Change the Font size in cell A1 to 14.

*Wrap the text in cell C3:L3

• Use AutoFit selection to adjust the column width for cells C3:L3

• Bold the text in cells A3:L3

*Format cell E4:E10 & H4:H10 to be Percentage with 1 decimal place.

*Perform the following calculations.

• Figure Team Field Goal % in cells E4:E7. (Hint: =Field Goals/Field Goal Attempts)

• Figure Team Free Throw %. in cells H4:H7.

• Figure Team Rebound Average in cells J4:J7 (Hint: =Rebounds/Games).

• Figure Total Points in cells K4:K7 (Hint: =Field Goals are worth 2 pts and Free Throws are worth 1).

• Figure Team Scoring Average in cells L4:L7 (Hint: =Total Points/Games)

• Figure Max (row 8), Min (row 9), Average (row 10) and Count (Row 11) for each column.

*Add a border to cells A3:L11

*Change the page to Landscape Orientation.

*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.