Lecture-4

 

  1. header and Footer FileàPage setupàHeader/Footer
  2. Custom header and footer FileàPage setupàHeader/Footer
  3. Why using Page Break is helpful in Excel? It allows us to view the printing area. ToolsàOptionàView tab
  4. Purpose of the Pie chart. Why do we use it? What range of data should be used for a Pie chart?
  5. Using example1 create a Pie Chart
  6. Do the following in that Pie Chart:
    1. Labels
    2. Add and Remove legend
    3. Take a Pie out
    4. Change Font type and Font size of the Label
    5. Make some arrows
    6. Add an annotation –Means make a text box and add some text
    7. Move titles so that they see the annotations
    8. Change the size of the pie—Resize
    9. Move the Pie
    10. How to just print the pie
    11. How to print with sheet
  7. Do the Bar Chart
  8. Do following:
    1. Labels
    2. Add and Remove legend
    3. Change Font type and Font size of the Label
    4. Label Axis
    5. Change color of the Bar