Monthly Archives: June 2010
Named ranges
Named ranges are the names provided to a range of cells. Named ranges are helpful in referencing a cell or the range in any part of an Excel worksheet. Descriptive names can be given to represent a cell, a range, … Continue reading
Data validation
Data validation is a process through which restrictions are applied on the data to be entered in a cell. It is a simple rule, which is applied to a field or an attribute of a cell to validate the data … Continue reading
Automatically fill a formula downward in Excel 2007
You can automatically fill a formula downward, for all adjacent cells that it applies to, by double-clicking the fill handle of the first cell that contains the formula. For example, you have numbers in cells A1:A10 and B1:B10, and you … Continue reading
Get Exchange Server 2010 certified by using uCertify’s new Practice test
uCertify a leading practice test provider for IT certification exams, recently released a practice test for the 70-662 Microsoft Exchange Server 2010 exam. To download the free trial of the practice test go to the link: http://www.ucertify.com/exams/Microsoft/70-662.html Microsoft’s 70-662 exam … Continue reading
uCertify’s 50% discount Freedom Sale
Independence Day is a national holiday marked by patriotic displays. In the United States, Independence Day, commonly known as the Fourth of July, is a federal holiday commemorating the adoption of the Declaration of Independence on July 4, 1776, declaring … Continue reading
Get Project Server 2007 certified by using uCertify’s new Practice test
uCertify a leading practice test provider for IT certification exams, recently released a practice test for the 70-633: Microsoft Office Project Server 2007 exam. To download the free trial of the practice test go to the link: http://www.ucertify.com/exams/Microsoft/70-633.html Microsoft’s 70-633 … Continue reading
Signature
A signature is a collection of text and pictures that are used to emphasize specific information. It is used to add a block of information at the end of an e-mail. The block of information is added automatically to an … Continue reading
Navigation Pane
The Navigation Pane is a column that appears on the left side of the Outlook window. It comprises folders and panes such as contacts, tasks, etc. The contents of the Navigation Pane change according to the current view (such as … Continue reading
Reading Pane
Reading Pane is a window of Microsoft Outlook 2007. It is used to preview messages and attachments. It is also used to review information of a message. A user can turn off Reading Pane by using the View menu. It … Continue reading
Formula in Excel 2007
A formula in Excel is an expression to calculate values. It includes values, cell references, names, functions, or operators. Using a formula in a cell produces a new value. A formula always begins with an equal sign (=). For example, … Continue reading
