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

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

How to install XAMPP Server On Window 10 - PHP PDO training 2

Image
PHP and MySQLi video tutorial for beginners with complete projects, examples, help and practical script assingments.  In this brand new we'll be learning how we can learn PHP and MySQL from scratch using PDO and OOP methods. In this video we'll be able to setup and install XAMPP local server on your window 7, 8 and 10 with complete guides and help. This series makes the beginners an advance level web developer using the best examples and easy code and script learning method. We'll be using modern and advance web development best-practices throughout this series to ensure that our course and web development sites are secure, easy-to-maintain and efficiently uses resources. This video series is a presentation for our viewers where they will be able to get notify about our php complete web development projects and course contents. You can find that how you can learn programming using PHP, PDO, MYSQL, HTML, css, Bootstrap, jQuery, dom, phpmyadmin, xampp install...
Keep reading