8. Select cell A7 and make the text bold 9. In cell B7 a formula that will calculate the total amount of calories in your chosen meal (use a SUM formula) If you don’t know how to do this watch the video (although this video is for Excel 2007 it is applicable for Excel 2010): http://www.teach-ict.net/software/excel_2007/formula/functions/sum_formula.htm 10. Replicate (autofil) the formula across to cells C7:E7 11. Highlight cells B6:E6. Format them with a single underline 12. Highlight cells B7:E7. Format them with a double underline 13. Select row 1 and insert a new row On the tab go to the section and find ‘Home’ ‘Cells’ ‘Insert’ From the drop-down menu choose Sheet Rows’ ‘Insert 14. In cell A1 write Favourite Meal’ ‘My 15. Highlight cells A1:E1. Use the and Centre’ icon on the title. (Home tab) ‘Merge Use the drop-down on the and centre’ icon and choose & Centre’ ‘merge ‘Merge 16a. Change the font to size 14 16b. Format the font so that it is italic 16c. Choose a suitable colour for the
8. Select cell A7 and make the text bold 9. In cell B7 a formula that will calculate the total amount of calories in your chosen meal (use a SUM formula) If you don’t know how to do this watch the video (although this video is for Excel 2007 it is applicable for Excel 2010): http://www.teach-ict.net/software/excel_2007/formula/functions/sum_formula.htm 10. Replicate (autofil) the formula across to cells C7:E7 11. Highlight cells B6:E6. Format them with a single underline 12. Highlight cells B7:E7. Format them with a double underline 13. Select row 1 and insert a new row On the ‘Home’ tab go to the ‘Cells’ section and find ‘Insert’ From the drop-down menu choose ‘Insert Sheet Rows’ 14. In cell A1 write ‘My Favourite Meal’ 15. Highlight cells A1:E1. Use the ‘Merge and Centre’ icon on the title. (Home tab) Use the drop-down on the ‘merge and centre’ icon and choose ‘Merge & Centre’ 16a. Change the font to size 14 16b. Format the font so that it is italic 16c. Choose a suitable colour for the
spreadsheet%20booklet.docx