This is the final tutorial of Max Ms-Excel 2010
Now that we have collected all the data for the group on your data collection Form. You need to enter it onto your Spreadsheet to analyse.
*** Open the measurements Spreadsheet and make sure your Fruit and Veg sheet is selected.
*** Enter all the data collected.
Your spreadsheet should look like this now;
Copying formula from another sheet
You have already entered Formula for the total, Average, Maximum and Minimum on your Measurements worksheet. You can copy the formula onto the Fruit and Veg worksheet.
*** Click on the Measurements worksheet.
*** Select Cells B12 to B18
*** Click on the copy button
*** Click on the Fruit and Veg sheet tab
*** Click in cell B14 on the Fruit and Veg sheet.
*** Click the paste button and notice the new values.
*** Copying using the Fill handle
In the last chapter you used the Fill handle to fill in the days of the week. Excel entered the days of the week from Tuesday to Friday automatically. This fill handle can also be used to quickly copy test, numbers and formula. You can copy them into adjacent cells, instead of using the copy and paste button.
*** Make sure cells B14 to B20 are selected.
*** Drag the fill handle from the bottom right-hand corner of cell B20 across to cell F20
*** It should now look like this
If you make a mistake and it goes wrong, use the undo button and try again. The pointer should be a cross, not an arrow when you drag the Fill handle.
Moving cell contents
Now you are going to move some cells in Row 3
*** Click in cell D3
*** Drag its left hand border to cell C3
*** Select F3 and G3. Drag the left hand-border of F3 to cell E3 to move your name.
Using the shortcut menu to copy and paste
As part of the data analysis it would be useful to find out the average number of fruit and vegetables
eaten by each member of the group.
*** Right click cell A16.
*** Select copy
*** Right click cell G5
*** Select Paste
*** Make the heading AVERAGE bold and right-align it. You may need to widen the columns a little and put a border around the cells in column G.
*** Select column headers B to G.
*** Drag the boundary between the column headers D and E. Make them wide enough to hold the longest day WEDNESDAY.
*** Use the borders tool to put borders around the cells in column G.
Entering the formula for Average
*** Click in cell G6
*** Type =average(
*** Drag across cells B6 to F6.
*** Type ) and press Enter.
*** Click in cell G6 and drag the Fill handle down to cell G12 to copy the formula to the other cells.
*** Copy the formula from F18 to G18 and from F20 to G20
*** Save your spreadsheet.
Printing the Results.
*** Click on the File tab and select Print.
You will be able to see the Print preview. You may not be able to see all of the worksheet. If you need to change the print area, you will need to;
*** Click on the Page Layout Tab.
*** Highlight all the cells from A1 to G20.
*** Select the Print area button on the ribbon.
*** Select Set Print Area from the menu that will appear.
*** Now click on the file tab and select the print option to view the print preview.
*** Save and close the Spreadsheet.
Well done – you now have cracked the basics of a Microsoft Excel 2010. 🙂