Computer application II (use of packages) windows, msword, powerpoint, excel and internet table of content chapter One

• 
  Add Effect: This drop-down list provides various options that enable you to select the appropriate animation effect. The options are:
  
  • 
    Entrance:
    
    • 
      Consists of options, such as Blinds, Box, Fly In, Checkerboard, Diamond, and More Effects to define the mode of entry of the text or object in the presentation
      
  • 
    Emphasis:
    
    • 
      Consists of options, such as Change Font, Change Font Size, Grow/Shrink, and Spin to change the appearance of the selected objects in the presentation
      
  • 
    Exit:
    
    • 
      Consists of options, such as Blinds, Box, Diamond, Fly Out, Checkerboard and More Effects, to make the text or object disappear from the slide with an effect
      
  • 
    Motion Paths:
    
    • 
      Consists of options, such as Diagonal Down Right, Diagonal Up Right, Down, Left, Right, and Up to set the motion path of the text or the object according to your requirement
      
• 
  Start: This drop-down list provides options, such as On Click, With Previous, and After Previous that enable you to define the time when the animation will be applied to an object. Options include:
  
  • 
    Property:
    
    • 
      This drop-down list enables you to view the properties of the selected effect
      
  • 
    Speed:
    
    • 
      Drop-down list enables you to set the animation speed. It includes options, such as Very Slow, Slow, Medium, Fast, and Very Fast
      
  • 
    Play:
    
    • 
      This button enables you to preview a slide with the applied current animation effects
      
  • 
    Slide Show: This button begins the slide show starting with the first slide
    
  • 
    Re-Order: Option contains 2 buttons for moving the animation up and down in the order of occurrence
    
  • 
    AutoPreview: This option automatically shows the preview when you select an effect.
    

1. 
   Select the required options and then close the Custom Animation task pane.
   

• 
  If you want to revert back the selection of an animation effect, select the effect, and click the Remove button on the Custom Animation task pane.
  

PowerPoint enables you to control the visual effect of the text on slides by using the preset animation schemes. E.g., you can make text, spin, bounce, float, or fade gradually Steps to apply preset animation:

1. 
   Select the Slide Show à Animation Schemes command (Slide Design task pane with animation schemes is open). The Slide Design task pane options:
   
   • 
     Apply to selected slides:
     
   • 
     Apply to All slides:
     
2. 
   Select the desired animation scheme and close the Slide Design task pane
   

• 
  Apply to selected slides:
  
  • 
    Options includes various animation schemes under categories: Recently Used, No Animation, Subtle, Moderate, and Exciting
    
  • 
    Recently Used category contains the most recently used animation schemes
    
  • 
    Categories Subtle, Moderate, and Exciting contain a variety of animation schemes that can be applied on a slide
    
  • 
    You can select any of the animation schemes, such as Random bars, Wipe, Appear and dim, Bounce, Compress, Rise up, Zoom, and Float to enhance your presentation
    
  • 
    Apply to All Slides:
    
  • 
    This button enables you to apply the selected animation schemes to all the slides
    
  • 
    Play: This button enables you to preview the animation scheme applied to a slide
    
  • 
    Slide Show: This button helps you to start the slide show.
    

• 
  Introduction to Excel
  
  • 
    Definition of a Spreadsheet
    
  • 
    Advantages of a Spreadsheet
    
• 
  Components of Excel Window
  
• 
  Create a new workbook
  
• 
  Opening, creating, and saving a workbook
  

• 
  Enter and Edit data in a worksheet
  
• 
  Edit and format cells, rows and columns
  
• 
  Format numbers and apply style
  
• 
  Link data in the worksheet
  
• 
  Refer to cells in a formula
  
• 
  Importing and exporting data
  
• 
  Creating a web page
  
• 
  Placing interactive data on the web
  
• 
  View different sections of a worksheet
  
• 
  Insert a picture
  
• 
  Preview and print workbook/sheet
  
• 
  Creating and modifying graphics (charts)
  
• 
  Set a validation rule to enter data in a worksheet
  
• 
  Set a validation rule to enter data in a worksheet
  
• 
  Import data
  
• 
  Apply number formats
  
• 
  Apply a condition for formatting
  
• 
  Create names for ranges of cells
  
• 
  Apply the names in formulas
  
• 
  Locate the required data
  
• 
  Sort data
  
• 
  Calculate subtotals
  
• 
  Change the print settings of a workbook
  
• 
  Print a workbook
  
• 
  Perform what-if analysis
  
• 
  Create dynamic tables and charts to analyze data
  
• 
  Publish dynamic tables and charts in an interactive Web page
  

A spreadsheet is a program that manipulates number and string data in rows and columns

• 
  Advantages of a Spreadsheet
  
  • 
    Main advantage of using a spreadsheet program is that it enables you to perform simple row-and-column arithmetic
    

• 
  Excel is a spreadsheet program with various components
  
• 
  Rows-are referenced by the row number
  
  • 
    1:1 is the reference to the first row
    
• 
  Columns-are referenced by the column name such as “A”
  
• 
  Cell-is an intersection of a row and a column
  
  • 
    It can contain various types of data – numeric/character
    
  • 
    A cell is referenced by the combination of a column and row name. E.g., first cell A1 is in column A and row 1
    
• 
  Worksheet-contains rows and columns of cells. A sample worksheet is displayed
  
• 
  Components of the Excel Worksheet window is described in next slide