Stage: 3 and 4 Challenge Level: 
- Typing in cell values can be boring work. It can be very useful sometimes to lift a copy of values already generated elsewhere by formulae.
- Select the range of desired values and choose Copy in the usual way.
- If you perform a normal Paste the formula and formatting will be recreated in the new setting, which may not always be what's wanted.
- However, if instead you choose Paste Special from the Edit menu you will be offered some interesting choices.
There's lots to explore here, but for now it is the Values choice we want. Excel will then ignore the source formula, and associated formatting, and will pop in the values just as if you had typed them yourself. Isn't that handy?
Random variables. Approximate solution by numerical methods.. Probability distributions, expectation and variance. Theoretical probability. Conditional probability. Spreadsheets. Tree diagrams. Mathematical modelling. Experimental probability. Summation of series.
Published October 2002.
Copyright © 2007. University of Cambridge. All rights reserved.
NRICH is part of the family of activities in the Millennium Mathematics Project, which also includes the Plus and Motivate sites.
email: nrich@damtp.cam.ac.uk
