SPREADSHEET HOMEWORK

Make this simple aplication:

Hint:

1. Make the calculation system on excel to manual, enable the iteration, and max iteration is 1 (open OFFICE BUTTON, EXCEL OPTION, FORMULAS)

2. To generate the dice’s number (cell D2) use random function that is =RANDBETWEEN(1,6)

3. Use IF function to calculate the frequency of each dice’s value

4. Use autoosme to find the total frequency

5. Shoe the column chart in the graph space to show the event of trowing dice probability.

6. Save your work before you do a trowing (before pressing F9), put your name on it. give to the committee or send me email consisting your job. indy_suryajava@yahoo.co.id

7. See the sampel on the picture below showing the result after you press F9 several times).

8. Save as another file, after you do several trowing (pressing F9 several times)

9. Have a good job.