Category Archives: 77-602

A View is a useful feature in Microsoft PowerPoint that shows the real presentation format of a slide. This is used to edit, print and deliver a presentation. It provides the real presentation format of a slide. View shows all … Continue reading →

Excel provides a column chart facility to display data that is arranged in columns or rows on a worksheet. Line charts are used to display continuous data over time, set against a common scale. In a line chart, category data … Continue reading →

The Watch Window is a toolbar available in Excel 2007 to monitor the value in a cell, regardless of its location in a workbook. The Watch Window can be moved or docked like other toolbars available. It keeps track of … Continue reading →

The NOW() function, in Excel, returns the time when the workbook was last opened. It means, if this function is used in a workbook, its value will change every time the workbook is opened. The NOW() function is not updated … Continue reading →

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 →

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 →

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 →

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 →