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

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