MS Excel can be customized in a way that suits a user to achieve his goal. It is extensively used in financial organizations. The features of MS Excel are as follows:
Workbooks: A document in MS Excel is called a workbook. Each workbook contains sixteen worksheets by default. A user can change this number by resetting the default options. Worksheets within workbooks make it easy to bind files of related information. When a user opens a workbook, he can use all the worksheets to perform a task. To create a workbook, a user will have to select the New command from the File menu. To open an existing workbook, a user will have to select the Open option from the File menu. A user can insert a worksheet between two worksheets by choosing the Worksheet option from the Insert menu.
Using keyboard: The following table provides different keyboard shortcuts for selecting a row, column, current cell, worksheet, etc.
To Select Keyboard Shortcuts
Current Cell Enter
Entire Column CTRL+Spacebar
EntireRow shift+Spacebar
Entire Worksheet CTRL+SHIFT+Spacebar
A user can perform various kinds of entries in a cell. He can enter text, number,...