Perform the following instructions using Excel commands. Do not perform hand calculations or use hand calculators--Excel is a great calculator once you get familiar with the program. You will be assessed on use of the Excel environment to perform the following actions. If unfamiliar with Excel spreadsheet basics, you will want to examine the available Excel Guide within Blackboard (find the guides via the Excel Guides button). Look in the first tab, entitled Excel Basics. In most cases, place your commands/formulas/actions in the cells of the "Results for Instructions:" column next to the proper problem label arrow.

Time (in seconds)

Squared Values

9.892

Instructions

Results for Instruction:

11.156

i.

Using Excel, sort the eight given time values in column O from greatest to least.

i.

(Results should be in "Time" column of values at the right)

8.292

ii.

Sum only the greatest and least of these values by using cell references within a formula.

21.223

Sum of greatest and least (ii.)

12.047

iii.

Change the font color on your sum result of ii. to purple.

14.729

iv.

Increase the font of your result in ii. to 16 point.

19.651

v.

Find the average (mean) of the time values given in column O.

Average (v.)

15.299

vi.

Use Excel's "ROUND" command to round the avearge result from part v. to three decimal places.(DO NOT USE the format display of three decimal places!!!)

Rounded Average (vi.)

vii.

Within the single result cell, create a formula that will sum the largest three values in the list divided by the value result from ii.

vii.

viii.

In cell Q35, use a formula to produce the square of the time value given in cell O35. Then use the "fill handle" feature to find the square of the remaining seven values in the Time data.

viii.

(Results should be in "Squared Values" column)

ix.

In cell S35, divide the squared value in cell Q35 by the average from cell M42 (using an absolute reference for cell M42). Then use the "fill handle" feature to repeat this process for the remaining seven squared values in that list.

ix.

(Results should be in "Squared . . Average Value" column)

x.

Throughout the semester, it will be a common occurrence that a cell will contain more content/text than is visible in the spreadsheet's cell. This will often be the case in regard to feedback provided to you by the instructor or responses that you type. Thus, you will need to read the entire contents of a cell by first clicking on the cell and then reading the entire contents above in the formula bar area OR you can double click on the cell to expand the cell's content. Do either of these for this instruction cell, writing the last full sentence of this paragraph in the results cell to the right. The quick red fox jumps over the lazy tan dog and says: "Lazy dog, come chase me!"

Last sentence in x.