Microsoft Excel lesson 4 - Dice Simulator (randbetween function, paste as values)

Channel:

Magic Monk

Subscribers:

65,900

Published on December 29, 2013 6:29:56 AM ● Video Link: https://www.youtube.com/watch?v=BcJENkqJZSg

Duration: 8:08

10,419 views

40

In this tutorial we talk about what a function does (receives input, process the input, presents the output). We use the randbetween function to generate random numbers between 1 and 6 to simulate dice throws, then we use the fill down feature to simulate multiple throws with multiple dice. We then copy the values we have generated and pasted as values so the values wouldn't update automatically every time we update the spreadsheet.

Link to Excel Lessons Playlist:
https://www.youtube.com/playlist?list=PLzr5fRV1AGV9CMSWzCjFExhEfzDxZcGFX