SEQUENCE, RANDBETWEEN and RANDARRAY
IntermediateAdvanced
10 questions, about 16 minutes
Let Excel number things for you with SEQUENCE, and pick random numbers with RANDBETWEEN and RANDARRAY.
What we'll do
- Numbering with SEQUENCE
- Random numbers with RANDBETWEEN
- A table of random numbers with RANDARRAY
What you'll use
SEQUENCERANDBETWEENRANDARRAYSUM
How it works
In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.
2examplesYou watch
10questionsYou do it yourself