Moore Computer

Step

Instructions

Points Possible

1

Start Excel. Open TIA_Ch4_Start.xlsx.

0

2

In cell F1, type Current Average, and in cell J1 type New Average

5

3

In cell F2, use the AVERAGE function to compute the average of the range C2:E2. In cell J2, use the AVERAGE function to compute the average of the range G2:I2.

10

4

Select cell F2, then drag the Fill Handle to cell F13. Select cell J2, then drag the Fill Handle to cell J13.

5

5

Select the cells in C2:J13, then format the cell contents with Number format with one decimal.

5

6

Select cell A2, and Merge and Center across cells A2:A5. Then adjust the orientation of the text to Rotate Text Up. Middle Align cell contents and Bold text.

10

7

Use Format Painter to copy these formats to cell A6 and cell A10.

10

8

Select range A2:J5, then apply Thick Outside Borders. Repeat with ranges A6:J9 and A10:J13.

10

9

Select range F1:F13, then apply Thick Outside Borders. Repeat with range J1:J13.

10

10

Select J2:J13. Apply a Conditional Format to format cells that are less than those in cells F2:F13. Use the Green Fill and Dark Green Text format.

10

11

Create a Clustered Bar Chart using ranges B1:B13, F1:F13, J1:J13.

10

12

Add the title Benchmark Comparison: New and Current Versions of CS Software and add a Horizontal Axis title Seconds. Position and resize chart so it fits A16:J34.

15

13

Save and close the workbook, and submit for grading

0

Total Points

100