## Year 7 homework # 1

Excel basics

This is image A for question 1. The area outlined in red is called what?

This is image B for question 2. The area outlined in red is called what?

This is image C for question 3. The area outlined by both red boxes is called what?

This is image D for question 4. The formula to add up the 5 numbers on the screen is what?

This is image E for question 5. The formula to add up the 5 numbers in the right hand column is what?

This is image F for question 6. The formula to add up the blue shaded numbers and put the answer in D9 is what?

This is image G for question 7. The formula to add up the orange shaded numbers and put the answer in F5 is what?

This is image H for question 8. The formula to add up 9, 53, 3 and 59 on this spreadsheet is what?

This is image I for question 9. The formula to subtract 3 from 27 and put the answer in cell E3 is what?

This is image J for question 10. The formula to subtract 9 from 43 and put the answer in cell E7 is what?

Back to the top.

## Year 7 homework # 2

Tables and charts

To do some of these homework tasks you will need to have access to Excel. You can access Excel through the school website. Select the mail icon.

When prompted, log in with your normal school credentials – the username is your full school email address (school login name that has the date in it @sirharrysmith.cambs.sch.uk) and the password is the one that you use in school.

There are files associated with some of the exercises, you can download them to your own device and then upload them to office365.

You may wish to use Excel to try these questions out.

Here is the Excel spreadhseet for these homework questions.

This is image A for question 1. What is the best way of making the column wide enough to fit all of the text in cell A1?

This is image B for question 2. The text in cell B2 needs to be spread over 4 cells, B2 to E2 and then centred; what is the best way of doing this?

This is image C for question 3. Which formula is the best way of adding up the total number of hats in cell F3?

This is image D for question 4. I want to copy the formula in cell F3 to the 4 cells underneath; which is the best way of doing this?

This is image E for question 5. How do I add the borders in cells B8 to F8?

This is image F for question 6. I want to copy the formula in cell F3 to the 4 cells underneath; which is the best way of doing this?

This is image G for question 7. Which method is the best way of adding up the sales for weeks 2 to 4 and the total?

This is image H for question 8. How do I select the data for the chart that I want to draw?

This is image I for question 9. I have selected my data but what do I do to draw a pie chart?

This is image J for question 10. Which of these methods is the best way to change the background of the pie chart?

Back to the top.

## Year 7 homework # 3

Excel calculations

To do some of these homework tasks you will need to have access to Excel. You can access Excel through the school website. Select the mail icon.

When prompted, log in with your normal school credentials – the username is your full school email address (school login name that has the date in it @sirharrysmith.cambs.sch.uk) and the password is the one that you use in school.

There are files associated with some of the exercises, you can download them to your own device and then upload them to office365.

You may wish to use Excel to try these questions out.

Here is the Excel spreadhseet for these homework questions.

This is image A for question 1. I have written "January" in cell B2, what is the easiest way to get the other months of the year in cells C2 to M2?

This is image B for question 2. How do I centre the words "Sixth Month Visitor Numbers" across cells B1 to G1?

This is image C for question 3. What is the best formula that I should use to find the average number of visitors to the liaons?

This is image D for question 4. I have used fill down to copy the formula for average but how do I make the cells so that they only show the average to two places of decimals?

This is image E for question 5. What is the formula to use in cell B8 that will find the maximum number of animals visited in January?

This is image F for question 6. There are three ways that I can fill in the formula that finds the max for all of the other months. Which of these ways does not fill in the formula?

This is image G for question 7. How did I select the animals in cells A2 to A7 and the averages in cells H2 to H7?

This is image H for question 8. I have managed to change the layout of the chart so that the bars have images, Which if these statements is true?

This is image I for question 9. What sort of chart is this?

This is image J for question 10. What steps have I taken to draw this line chart?

Back to the top.

## Year 7 homework # 4

Youth Club

To do some of these homework tasks you will need to have access to Excel. You can access Excel through the school website. Select the mail icon.

When prompted, log in with your normal school credentials – the username is your full school email address (school login name that has the date in it @sirharrysmith.cambs.sch.uk) and the password is the one that you use in school.

There are files associated with some of the exercises, you can download them to your own device and then upload them to office365.

You may wish to use Excel to try these questions out.

Here is the Excel spreadhseet for these homework questions.

This is the image A for question 1. The area outlined in red is called what?

This is the image B for question 2. The area outlined in red is called what?

This is the image C for question 3. The area outlined by both red boxes is called what?

This is the image D for question 4. The formula to add up the 5 numbers on the screen is what?

This is the image E for question 5. The formula to add up the 5 numbers in the right hand column is what?

This is the image F for question 6. The formula to add up the blue shaded numbers and put the answer in D9 is what?

This is the image G for question 7. The formula to add up the orange shaded numbers and put the answer in F5 is what?

This is the image H for question 8. The formula to add up 9, 53, 3 and 59 on this spreadsheet is what

This is the image I for question 9. The formula to subtract 3 from 27 and put the answer in cell E3 is what?

This is the image J for question 10. The formula to subtract 9 from 43 and put the answer in cell E7 is what?

Back to the top.

## Year 7 homework # 5

Excel charts

To do some of these homework tasks you will need to have access to Excel. You can access Excel through the school website. Select the mail icon.

When prompted, log in with your normal school credentials – the username is your full school email address (school login name that has the date in it @sirharrysmith.cambs.sch.uk) and the password is the one that you use in school.

There are files associated with some of the exercises, you can download them to your own device and then upload them to office365.

You may wish to use Excel to try these questions out.

Here is the Excel spreadhseet for these homework questions.

This is the image A for question 1. What do you have to do to make column D wide enough to see the text?

This is the image B for question 2. If 120 children over 15 visit the youth club what is the formula in cell E32 that works out how much is made?

This is the image C for question 3. If 138 children between 12 and 15 visit the youth club what is the formula in cell E33 that works out how much is made?

This is the image D for question 4. What formula should be typed into cell E25 to work out the total ticket sales?

This is the image E for question 5. What do you have to do to select the shaded cells?

This is the image F for question 6. In which menu are the chart types from which you would have selected the 3D column chart to draw this chart?

This is the image G for question 7. I have selected a part of the chart, which part?

This is the image H for question 8. TheWhat steps did I go through to make this chart?

This is the image I for question 9. Which is these instructions is not necessary when making this chart?

This is the image J for question 10. What is wrong with this chart?

Back to the top.

## Year 7 homework # 6

Excel challenge

To do some of these homework tasks you will need to have access to Excel. You can access Excel through the school website. Select the mail icon.

When prompted, log in with your normal school credentials – the username is your full school email address (school login name that has the date in it @sirharrysmith.cambs.sch.uk) and the password is the one that you use in school.

There are files associated with some of the exercises, you can download them to your own device and then upload them to office365.

You may wish to use Excel to try these questions out.

Here is the Excel spreadsheet for these homework questions.

This is the image A for question 1. The area outlined in red is called what?

This is the image B for question 2. The area outlined in red is called what?

This is the image C for question 3. The area outlined by both red boxes is called what?

This is the image D for question 4. The formula to add up the 5 numbers on the screen is what?

This is the image E for question 5. The formula to add up the 5 numbers in the right hand column is what?

This is the image F for question 6. The formula to add up the blue shaded numbers and put the answer in D9 is what?

This is the image G for question 7. The formula to add up the orange shaded numbers and put the answer in F5 is what?

This is the image H for question 8. The formula to add up 9, 53, 3 and 59 on this spreadsheet is what

This is the image I for question 9. The formula to subtract 3 from 27 and put the answer in cell E3 is what?

This is the image J for question 10. The formula to subtract 9 from 43 and put the answer in cell E7 is what?

Back to the top.