Posts

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

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

MS Office Excel

Free Microsoft Excel Tutorial Complete

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

HTML Table

HTML Table: Html tables can arrange data like text, images, links and other tables etc, in rows and columns of cells. An html table defines with table tag. Table row is defined with the <tr> tag. <tr> tag is used to create table rows. Table header is defined with the <th> tag. <th> tag si used to represent table headings. By default table headings are bold and centered. A data cell is defined with the <td> tag. <td> cell is used to create data cells. <!DOCTYPE html> <html> <head><title>HTML Table</title></head> <body> <table width="500px">    <tr>    <th>Name</th>    <th>Ph. NO</th>    <th>Salary</th>    </tr>    <tr>    <td>Saleem</td>    <td>5649532</td>    <td>500$</td>    </tr...

HTML Introduction

Image
HTML Basic to advance What is Html or HTML5??? HTML stands for (HyperText Markup Language). It is used to make web pages and websites.  Tim Berners Lee is the inventer of HTML.

Welcome to my blog

Image
Online Tutorials in Urdu/Hindi & English Learn HTML, CSS, JAVASCRIPT, JQUERY, AJAX, PHP MYSQLi, JAVA, C++, YouTube Optimization, Google Adsence, Computer Short Courses, Courses Graphic Designing, and Animation Tutorials in Urdu Hindi English Languages.