LCD

A liquid crystal display (LCD) is a thin, flat electronic visual display that uses the light modulating properties of liquid crystals (LCs). ...

Networking

Networking in the field of computer is the practice of linking computer devices together to support digital communication among them.

What is chart?

The graphical representation of numerical data is known as Chart or Graph. It makes easy to compare and to understand the numerical data. A chart is created with a range of data stored into the worksheet cells.

What is function?

To built in tool predefined formula that is used to perform specific calculations and return a value in a call where it is written is called function. The function is written in a cell of worksheet as formula. Every function returns a value and may accept one or more arguments. Arguments are passed to the functions within parenthesis.

What is absolute referencing?

The cell references used in formula that do not change when you copy formula to another cell in the worksheet are called the absolute references. An absolute reference is specified in the formula by using $(Dollar) sign before column letter and row number that used as cell reference in formula.

What is relative referencing ?

Calling a cell with the reference of its address (such as A1) is called relative referencing. When a formula contains relative referencing and it is copies from one cell to another, the spreadsheet does not create an exact copy of the formula.

What is cell reference?

The cell address is also known as cell reference and value of call is used in formula through its cell reference. For example the cell reference A12 represents the column A and row 12.

What is formula?

A formula is a mathematical expression that is combination of numbers, cell addresses or cell references and arithmetic operators. In excel, mostly the formula is build by using cell references along with arithmetic operators. Formula is entered in the worksheet cell and must begin with an equal sign “=”. The cell in which formula is written, display the result of formula only.

What is active and passive cell?

There are two states of a cell, i.e. active and passive. The currently selected cell where data can be entered or edited is called the active cell. When another cell is selected or cell pointer is moved to another cell, that cell becomes the active cell. Actually, at a time a single is active and other cells of worksheet are inactive. The inactive cells are known as passive cells.

What is Microsoft Excel?

Microsoft Excel is most popular spreadsheet program that allows you to perform various calculations on numeric data, creating charts etc. it also allows you to format the text in cells and printing text etc.

What is workbook?

In MS-Excel the document or file in which data is permanently stored on the disk is called workbook. It is a collection of worksheets.

What is a worksheet?

A spreadsheet program used worksheets and workbooks. A worksheet is divided into a grid of columns and rows. In excel, a worksheet consists of 256 columns and 65536 rows. The columns are labeled with letters A,B,C…etc and rows are labeled with numbers 1,2,3 etc.

What is a cell?

The spreadsheet is a grid of rows and columns the columns are labeled with letters A,B,C….. and rows are labeled with numbers 1,2,3 ete. The intersection of row and column forms a cell.

What is spreadsheet program?

A spreadsheet program is a software tool for entering, calculating, manipulating and analyzing sets of numbers. It can hold large amount of data arranged in rows and columns just like a table. Ms-Excel is an example of spreadsheet program.

What is word art?

Word art in a work of art, which can be done in word document to transform text into an image. It means that word art feature of word processor is used to turn ordinary text into graphics objects. The text can be converted into variety of shapes, by rotating, adding shades, colors, borders, shadows etc.

What are headers and footers?

Header is the information that is added to the top margin of every page such as a document title. Footer is the information that is added to the bottom margin of each page of the document.

What is meant by page formatting?

The layout of the page when it is printed on the printer is called page formatting. It refers to the size of the page, its orientation, and headers and footers. There are many other features that can be applied to page formatting.

What is meant by indent?

The space or distance between the page margin and the text in paragraph is called indent. You may indent some text in the document to highlight it. For this purpose, select the paragraph (or paragraphs) that you want to indent and use the ruler to set the indent.

What is meant by paragraph formatting?

Formatting applied on a paragraph is called paragraph formatting. Paragraph formatting includes line spacing, paragraph spacing, indents, alignment, tab stops, borders and shadings etc. most of the paragraph formatting is done using paragraph dialog box, horizontal and vertical ruler elements.

What is meant by formatting document?

The formatting of a document includes changing the appearance of the text, adding pictures and graphics and controlling the layout of the text on the page. There are different ways to format the document. The formatting toolbar is the easiest way to change any attribute.

What is redo command?

This command is used to cancel an undo command action. Each time the redo command is applied, the last undo command action is cancelled.

What is undo command?

The command that is used to cancel an action is called undo command. Each time the undo command is applied, the last action is cancelled.

What is over type mode?

In overtype mode, existing text toward the right cursor is overwritten when new text is typed.
To change from insert mode to overtype mode, press the inset key on the keyboard. The OVR indicator on the status bar will be highlighted. Similarly, to change to inset mode from overtype mode, press the insert key again.

What is insertion mode?

In insertion mode, the newly entered text is placed at the current position of the cursor. When the text is typed at the insertion point, existing text at the right of cursor moves forward to make the space for the new text. It is the default mode of Microsoft word.

What is meant by word wrap?

During text entering process into document, the cursor automatically shifts to the next line when it reaches to the right margin. It means that text wraps around to the next line. The user does not have to hit enter key after typing one line. The word processor will also re adjust text if you change the margins.

What is word processor?

Word processor is an application software that provides facility for creating and editing all kinds of documents. Word processor also enables you to add images, charts and graphics in your document.

What is print queue?

When multiple documents are sent to the printer for printing, they are added in a queue in an order in which they are sent to the printer. This list of documents waiting to be printer on the printer is called printer queue. The documents in print queue are handled one by one in the same order in which they are received.

What is extended partitioned?

Extended partition refers to a portion of a disk that can contain other partitions. In windows, maximum for primary partitions can be created on hard disk. However, a hard disk can have only one extended partition. This type of partition can further be divided into sub partitions.

What is primary partition?

A primary partition is one that can be used as system partition. Windows 2000 and other operating systems can start from a primary partition. You can create maximum four primary partitions on a hard disk, or three primary partitions and extended partition. Primary partitions can be create only one hard disk and cannot be sub partitioned.

What is plug and play?

Some operating systems automatically detect and configure new when they are connected to the computer. This capability of an operating system is referred to as plug and play.