Microsoft Excel spreadsheets

  1. See the dice throwing simulation and learn the IF(), the RAND(), the INT() functions. Can you generate a random whole integer number between 1 and 6, or between 1 and 365 for the days of the year?

  2. See the FORMULAS used in the above.

  3. See BOTH #1 and #2 together.

  4. See 2nd worksheet example with TEXT functions, and good review of SUM() and AVERAGE(), as well as CONCATENATE(), LEFT(), RIGHT(), LEN(), MID(), FIND(), etc.

  5. See 2nd worksheet with FORMULAS and FUNCTIONS showing, courtesy of the Tools menu, Option command, View folder of that dialog box.

  6. See BOTH #4 and #5 together.
DOWNLOAD or OPEN the EXCEL WORKBOOK you have been studying here on this page.