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

Download 9.57 Mb.
Size9.57 Mb.
1   ...   49   50   51   52   53   54   55   56   ...   66
Select the Blank Workbook option from the New section. This opens a new workbook, as shown:

  • Alternatively, you can hold down the Ctrl key and press the N key to create a workbook.

  • By default, the first cell A1 in a new worksheet is active when you create a new workbook.

Opening a Workbook

When you start Excel, it opens a blank workbook. To open an existing workbook, perform the following steps:

    1. Select the File à Open command from Microsoft Excel Window to display the Open dialog box

    2. From the Look in drop-down list, select the folder that contains the file you want to open

An alternative way to browse to the required location of the file is to click the Up one level icon ()

    1. Select the required file(s) from the list of files displayed in the dialog box

    2. Click the Open button to open the selected file(s)

To open multiple adjacent files, select the first file in the block from the Open dialog box, press the Shift key, and select the last file

Creating a Workbook Using Templates

Excel provides many pre-defined template files to store data such as Invoice information, Expense statements, Purchase orders, etc. Template files have the extension .xlt. Steps to create Microsoft Excel files using a template:

    1. Select General Templates option from the New from template section of the New Workbook task pane, as shown

      • The Templates dialog box is displayed (not shown)

Options are:

    • General: Displays the general template and is selected by default.

    • Spreadsheet Solutions: Displays various types of spreadsheet samples, such as Balance Sheet, Expense Statement, Loan Amortization, Purchase Order, Sales Invoice, and Timecard

  1. Select the required template and click the OK button

Saving the Workbook

Saving a workbook is similar as in saving any file in microsoft office (word, power point, etc). After adding data to a workbook, you need to save it for future use. Steps to save a workbook

    1. Select the File à Save command from the Microsoft Excel Window (Save As dialog box is displayed)

    2. From the Save in list, select the folder in which you want to save the workbook

    3. Enter a file name in the File name text box of the Save As dialog box

    4. Select the type of file that has to be saved from the Save as type drop-down list

    5. Click the Save button to save the workbook

Alternatively, you can hold down the Ctrl key and press the S key to save a workbook
Closing the Workbook

You need to close a workbook after you finish working on it. To close a workbook, perform the following steps:

    1. Select the File à Close command.

If the workbook has any unsaved changes, the Microsoft Excel message box appears as shown in the following figure:

    1. Click the Yes button to save the changes before closing the workbook. Click the No button to close the workbook without saving the changes. Click the Cancel button to return to the active worksheet without saving the workbook.

Performing Operations on Data

You can perform the following operations on the data in worksheets and workbooks:

    • Entering data

    • Moving and Copying data

    • Deleting data

You can enter text, numbers, and date and time entries in a worksheet
1   ...   49   50   51   52   53   54   55   56   ...   66

The database is protected by copyright © 2020
send message

    Main page