How to Learn

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...

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...

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...

Spreadsheets in Microsoft Office Excel 2007; After Completing this course, students will be able to: 1. Define spreadsheet. 2. Know the purpose of worksheet 3. Recognize spreadsheet software-Excel 4. Explain workbook and worksheet 5. Get familiar with excel application window 6. Identity             Columns    . Rows      . Cells     . Cell address 7. Manipulate data(numeric and non-numeric) into a cell/range of cells by            Entering data          Editing data             Auto filling data 8. Enter a formula 9. Insert functions   . SUM     . PRODUCT    . AVERAGE     . POWER   . SQRT       . MAX         . MIN 10. Create a spreadsheet such as the monthly report of expenses, students result from sheet and salary report etc.     ...