Any combination of numbers or words can be entered in the cell
A cell range can be referred to in a formula as well. In a spreadsheet, a cell range is defined by the reference of the upper left cell (minimum value) of the range and the reference of the lower right cell (maximum value) of the range. Eventually separate cells can be added to this selection, then the range is called an irregular cell range.
In Microsoft Excel, a fill handle is a feature to extend (and fill) a series of numbers, dates, or even text to a desired number of cells. In the active cell of the spreadsheet, the fill handle is a small black box at the bottom right corner
Workbook. Also called a spreadsheet, the workbook is a unique file created by Excel XP.
On the Home tab, in the Front group, click the arrrow next Borders Button, and then
click No Border Button.
OR
Click Home -> the Border arrow -> erase Border, and then select the cells with the border you want to erase.
The formatting and Drawing toolbar is a toolbar in Microsoft Office 2003 and earlier applications that gives the user the ability to change the formatting of selected text or cell.
A condition format changes the appearance oc cell on the basis of conditions that you specofy.If the conditions are true, the cell range is formatted; if the condition are flase, the cell range is not formatted.
There is no option to set page border in Excel
In Conditional Formatting we cannot set condition to look for Bold and apply Italics on them.
The width of a row and specified manually or fit automatically is invalid statement.
Formula palette is used to create and edit formula.
It is also possible to type a function directly into a cell, however, as there are over 300 functions built into Microsoft Excel, some of which are quite complex, excel provides the Formula Palette to simplify the process.
To go to previous cell we can use Go to function Ctrl + G
In 2003 and earlier versions - From Format Cells dialog box click on Merge Cells check box.
In 2007 and subsequent version - Merge & Center icon on the Home ribbon.
On the button left of the Worksheet, we find the Sheet Tab Scroll Buttons to move to the First sheet, Previous sheet, and Last sheet. They are followed by the tabs for the worksheets in our workbook and the Insert Worksheet button or tab, depending on the version of Excel we are using.
Name Box refers to an input box directly to the left of the formula bar. The Name Box normally displays the address of the "active cell" on the worksheet. You can also use the name box to quickly create a name range.
Data sheet can not be a sheet in workbook.
