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



Download 9.57 Mb.
Page52/66
Date20.04.2018
Size9.57 Mb.
1   ...   48   49   50   51   52   53   54   55   ...   66

Task 1: Identify the type of data to be inserted in the worksheet

  • Before you decide the type of data to be inserted in the worksheet you should know about the methods of representing information in a worksheet

  • You can represent information in the following manner in a worksheet:

    • Data - includes normal text, numbers and date

    • Charts - graphically represent data in a worksheet

    • Pictures - pictorially represent data in a worksheet

  • Task 2: Determine the type of data manipulation required

    • You can perform the following types of data manipulation:

      • Generate a series of data

      • Perform calculations on data

  • Task 3: Determine whether you have to generate a series of data, e.g.,

    • Text - includes series like Product'1, Product2, Products

    • Number - includes series like 1, 2, 3

    • Date - includes series like Monday, Tuesday, Wednesday and January, February, March

  • Task 4: Determine whether you have to perform calculations on data

    • Types of calculations include:

    • You can use formulas and functions to perform calculations in a worksheet (more later)

  • To create a workbook, perform the following steps:

    • Select the File à New command (New Workbook task pane is displayed on the right-hand side of the screen)

  • The New Workbook task pane displays the following sections:

    • Open a workbook: Enables you to open an existing workbook.

    • New: Enables you to create a workbook.

    • New from existing workbook: Creates a new workbook with the same contents as the existing workbook, but with a different name.

    • New from template: Enables you to create a new workbook from an existing template.





    Share with your friends:
  • 1   ...   48   49   50   51   52   53   54   55   ...   66


    The database is protected by copyright ©ininet.org 2019
    send message

        Main page