Computer application II (use of packages) windows, msword, powerpoint, excel and internet table of content chapter One
Download 9.57 Mb.
|
- Navigate this page:
- File à New
- New from template
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: Mathematical - includes addition, subtraction, multiplication, and division Statistical - includes finding average, maximum and minimum values Financial 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. 
Directory: files files -> Answer True False 2 points Question 2 files -> Integer programming and game theory files -> 4 Integer Programming files -> Bpa vehicle Window Repair Scenario #1 task: Procure vehicle window relacement. Objective files -> Pop Warner History files -> North Carolina Inclusion Initiative Mapping Where Children with ieps are Being Served Purpose files -> Fall 2013 Spring 2014 Program Data: Standard 1 Exhibit 4d files -> Hanban – asia society confucius classrooms network 2010 request for proposal files -> Northern England’s set-jetting locations Download 9.57 Mb. Share with your friends:
|