Plan a worksheet that stores the driving distance from your house or local area to six cities you would like to visit.

Research the driving distance from your city or local area to six cities using google maps.

  1. Create a new workbook.
  2. Enter the researched data and apply appropriate formatting.
  3. Decide what type of chart would best illustrate the data and create a chart on the active sheet that illustrates the distance between your city or local area and the six cities. Include an appropriate title, legend, axes labels, and formatting.
  4. Print preview and move and size the chart so that the chart and data fit on one page in landscape orientation.
  5. Create a header that right aligns your name.
  6. At the bottom of the driving data, add a function that includes the average distance, max distance, min distance and the total distance (sum). Move the chart out of the way so the functions can be seen.
  7. Save the workbook naming it Driving and print a copy with gridlines and row and column headings.

Click here to watch a screencast video of the assignment!


Leave a Reply

Your email address will not be published.