Question: 1 . Enter numbers in the first column from 1 to 1 0 0 using autofill: - add initial data ( the first 2 numbers

1. Enter numbers in the first column from 1 to 100 using autofill: - add initial data (the first 2 numbers) - select the 2 cells - place your cursor over the square in the bottom right corner of the cell. When it turns to a cross, drag the square down to the 100th cell 2. Fill Column2 using the same approach as you used to fill Column1 3. Fill Column3 using a formula based on the numbers in Column1 or Column2 - hint: enter a formula in cell D6 and copy it down into the 100 cells below it 4. Fill Column4 using the =RAND function - format this column to 3 decimal points 5. Fill Column5 using the =RAND function or a formula based on a previous column 6. Fill Column6 using the =RANDBETWEEN function

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!