Smart MS Excel

A name can be given to a single cell or a range of cells ( e.g.B3:F9). The range name can be used in place Of these cel…

T here are 16384 rows and 256 columns in one worksheet .The first cell is labelled as A1 (column as A and Row number as…

Create a Custom List . 1. Enter the given list starting from cell L5 to L8 .      *Left       *Right       *UP      *Do…

The various kinds of entries that can be made in a cell are : Text - First select the cell in which the data has to be …

Open the workbook to start your work on a worksheet .At times , you might required name to insert or Delete a workshee…

MS-Excel document is called as a workbook. Each workbook contains 16 worksheets by default. This number can by changed…

Menu Bar -Different options for selection . Standard Toolbar -It is displayed by default and provides shortcuts for …

B efore you start working on the worksheet ,the knowledge of the concepts and movement on the workbook is necessary. TO…

M icrosoft Excel is a Windows based application package that can be used to automate tasks such as Calculation and ana…