Problem $2$:

Use the score data in worksheet "Problem $2",$ change the worksheet code name to "wsScores"

Make this worksheet the active sheet.

Define a range variable "anchorCell" and assign it Cell A$1$

Using the offset property of the anchorCell, use a message box to display the value in cell D$5$

Using the cells property of the anchorCell, use a message box to display the value in cell C$3$

Using range, anchorCell, the end property, select the range for the cells with the ID and SSN

$($Hint: Use xlDown two times to get to the top of the desired range and three times to get to

the bottom of the desired range.$)$

Using range, anchorCell, the end property and the currentRegion property to select the range

for the cells with the ID and SSN

Using the anchorCell, offset with the end property and the FormulaR$1$C$1$ properties, place a

formula at row $11$ that calculates the average over scores $1$ to $6($data in columns B to G$.)$

Using the anchorCell, offset and the Formula properties, place a formula at row $12$ that

calculates the standard deviation over scores $1$ to $6($data in columns B to G$.)$

Show the statistics numbers in rows $11$ and $12$ with only two digits after the decimal point.

Using the copy and paste methods and using the anchorCell and offset to reference a cell,

copy the SSN from the range B$22$:B$30$ to Column I.

Sort cells in range A$2$:I$9$ according to ascending Score$5.$

Using the anchorCell and the offset property, redefine a new range with $4$ rows and $4$

columns with the upper left$-$hand corner being cell C$3($Hint: use the property Resize $($#Rows,

#Cols.$)$ Then highlight the following:

a$.$ the $3-$rd row of the range in Blue

b$.$ the fourth column from the left of the range of the data in Red

c$.$ the entire $5-$th column from the left of the range in Green

d$.$ the entire $5-$th row from the top of the range in Magenta

e$.$ offset the whole range by $3$ rows and make the interior color of the new range Yellow

The before and after are provided.