MS Office Excel

Comments

Post a Comment

Popular posts from this blog

Data Manipulation in MS Excel

Image
Data Manipulation   Data manipulation involves entering, editing and formating data. Different formulae and functions can also be applied to manipulate data. User should enter some  data before manipulation. Figure 3.10 Entering Data Both side  Entering Data: To enter data:  . Click a cell to select it. As user selects a cell, the cell address appear in the Name Box. . Enter text into the cell using the keyboard. The text appears in the cell and in the formula     bar as shown in the figure 3.10 . Two buttons also appear in the Formula Bar, the cancel button. . When the user has completed typing data, it can be entered permanently into the active       cell by pressing "ENTER" or by clicking the mark in the Formula Bar or  by pressing the TAB key on the keyboard. . User can enter data anywhere in the worksheet by moving to the required cell, using the mouse or arrow keys, and typing the text. Editing Data: Editi...
Keep reading

Basic Elements of Worksheet

Image
Basic Elements of Worksheet:   The following are basic elements of a worksheet.   Columns:       Columns in a worksheet are arranged vertically. They are identified by alphabet in the column header from A to Z, AA, AB, AC, to XFD, as shown in figure 3.8a. Figure 3.8a Columns   Rows:   Rows are arranged horizontally in a worksheet. They are identified by numbers in the row header(1,2,3,4,...), as shown in figure 3.8b. Figure 3.8b Rows   Cell:      The intersection of row and column in a worksheet is called the cell. The cell is the basic unit in the worksheet where the user can enter data, function or formula. The "active cell" is the cell which is currently selected. It can be identified by the black border around it, or by its cell address in the Name Box. Figure 3.8c shown cell and active cell(C6).  Figure 3.8c Active Cell Cell Address or Cell Reference:     Cell Address or C...
Keep reading

Excel Application Window

Image
Excel Application Window: User can start Excel program as follows: 1. Click Start 2. Select All Programs 3. Point to Microsoft Office Excel 2007 4. Excel window appears as shown in Figure 3.1 Figure: 3.1 Components of Excel Window:   The excel 2007 window is made up of the several components discussed as follows: Office Button:  The Office Button is at the top left of the Excel window. Clicking this button opens  a menu of commands.   Recent documents can be seen on the right of the Office Button Menu. Figure 3.2 Shows Office Button menu with commands. Figure 3.2    Quick Access Toolbar:  Next to the Microsoft Office Button is the Quick Access Toolbar. The quick Access Toolbar gives access to frequently used commands.   By default, Save, Undo and Redo appear on the Quick Access Toolbar. Quick Access Toolbar Title Bar:   It is located at the top of the Excel window. On the Title bar, M...
Keep reading