IT Apps - Exercise 6

In this exercise, you create a worksheet that uses Excel’s Mathematical and statistical functions to generate a value for use in a sweepstakes contest.

1. Create a worksheet that looks like the one shown below: 

2. Your first step is to populate the worksheet with a list of 10 random integer values between 0 and 100. To do so:

Select: cell A5

Type: =int(rand()*100)

Press: Enter

Copy this from A5 to A14

Random value will appear in each cell.

3. Then, calculate the average value in D6.

Each person who rents a video will have an opportunity to press F9 key to recalculate the worksheet. If his ‘Average random value’ is greater than the ‘Value to beat’ then he is a winner

4.  In cell D8, use the IF functions to informs the participant on how they’ve done. The winner must achieve an average random value that is greater than the specified value to beat. If he wins, cell D8 will displays “Winner!”, otherwise displays “Try Again!”. To do so:

Select: D8

Type: =IF(D6>60, “Winner!”, “Try Again!”)

Press: Enter

5. In cell range A5 to A14, use conditional formatting fill the cells with blue background if the random value is less than or equal to 60.
6. In cell D8, also use the Conditional Formatting to fill it with yellow background if the participant wins.
7. On your own, press the F9 key to test your luck.

http://mc.tt/92KgGSFsqd