Question

Complete the following tasks then compare your work to the attached solution file. 1. Increase the width of columns B and C to 16 characters 2. Merge and Center the title from Cell A1 to G1 3. Format the title in cells B3 & C3 as bold and 12 point Times New Roman 4. Format the numbers with commas and remove all decimal places 5. Apply cell style Accent 1 to title in cell A1 6. Use wrap text for cells B3 & C3 7. Name the sheet as Surnames 8. In cell B19 type ""Total:"" and right align the text 9. Create a formula or function in Cell C19 to add all the numbers 10. Apply a thick bottom border to cells B3 and C3 11. Change the Page Layout Orientation to Landscape 12. Create a 3D clustered chart for the data. Do NOT include the totals in your chart! 13. Chart should include a chart title 14. Position the chart below these instructions 15. Save your worksheet - use your lastname as the file name

          Complete the following tasks then compare your
work to the attached solution file.
1. Increase the width of columns B and C to 16
characters
2. Merge and Center the title from Cell A1 to G1
3. Format the title in cells B3 & C3 as bold and
12 point Times New Roman
4. Format the numbers with commas and remove
all decimal places
5. Apply cell style Accent 1 to title in cell A1
6. Use wrap text for cells B3 & C3
7. Name the sheet as Surnames
8. In cell B19 type ""Total:"" and right align the text
9. Create a formula or function in Cell C19 to
add all the numbers
10. Apply a thick bottom border to cells B3 and
C3
11. Change the Page Layout Orientation to
Landscape
12. Create a 3D clustered chart for the data. Do
NOT include the totals in your chart!
13. Chart should include a chart title
14. Position the chart below these instructions
15. Save your worksheet - use your lastname as
the file name

Complete the following tasks then compare your
work to the attached solution file.
1. Increase the width of columns B and C to 16
characters
2. Merge and Center the title from Cell A1 to G1
3. Format the title in cells B3 C3 as bold and
12 point Times New Roman
4. Format the numbers with commas and remove
all decimal places
5. Apply cell style Accent 1 to title in cell A1
6. Use wrap text for cells B3 C3
7. Name the sheet as Surnames
8. In cell B19 type ""Total:"" and right align the text
9. Create a formula or function in Cell C19 to
add all the numbers
10. Apply a thick bottom border to cells B3 and
C3
11. Change the Page Layout Orientation to
Landscape
12. Create a 3D clustered chart for the data. Do
NOT include the totals in your chart!
13. Chart should include a chart title
14. Position the chart below these instructions
15. Save your worksheet - use your lastname as
the file name

Added by William H.

Question

Please give Ace some feedback