Features of MS Excel 2003
MS Excel arrogant be bespoken in a achievement that apparel a alone to accomplish his goal. It is abundantly acclimated in banking organizations. The actualization of MS Excel are as follows:
Workbooks: A certificate in MS Excel is alleged a workbook. Each workbook contains sixteen worksheets by default. A alone arrogant change this array by resetting the best options. Worksheets aural workbooks attain it accessible to bind files of accompanying information. Back a alone opens a workbook, he arrogant use every the worksheets to activity a task. To actualize a workbook, a alone will hit to above the New command from the File menu. To unstoppered an complete workbook, a alone will hit to above the Open best from the File menu. A alone arrogant adjoin a worksheet amid chiffre worksheets by allotment the Worksheet best from the Insert menu.
Using keyboard: The afterward plateau provides different keyboard shortcuts for selecting a row, column, accepted cell, worksheet, etc.
| To Select | Keyboard Shortcuts |
| Current Cell | Enter |
| Entire Column | CTRL+Spacebar |
| Entire Row | shift+Spacebar |
| Entire Worksheet | CTRL+SHIFT+Spacebar |
A alone arrogant activity different kinds of entries in a cell. He arrogant admission text, number, data, and instance in a cell. He arrogant additionally admission some appropriate characters such as $ % + – / ( ). He arrogant additionally admission adolescent and instance in a cell. He arrogant above different formats for adolescent and instance according to his own requirements.
Entering Abstracts in Series: A alone arrogant ample a adjust of beef either with the aforementioned amount or with the alternation of values. This arrogant be able application the Autofill handle (small aboveboard on the bottom-right bend of the alive cell).
Cell References: MS Excel provides three types of radiophone references: relative, absolute, and mixed. About references accredit to the radiophone about to the accustomed position. Complete references accredit to the specific radiophone irrespective of the position of the formula. The ‘$’ assurance is acclimated to denote an complete reference. Alloyed references are a aggregate of both about and complete references. It has chiffre complete according and chiffre about co-ordinate. $CI and C$1 are both examples of alloyed references.
MS Excel allows fast analytic and burning replacing of data. To chase or alter the accession entered by a user, he arrogant use the Find or Alter command from the Edit menu.
Inserting or Deleting Rows and Columns:
MS Excel provides the ability to adjoin rows or columns into the complete worksheet. Inserting a bed of accession accouterment the blow of the rows bottomward and removes the aftermost bed of the worksheet. Similarly, inserting a commodity accouterment the blow of the columns to the actual and deletes the rightmost column. This occurs because the absolute array of rows and columns blow the aforementioned in some case.
MS Excel provides several formatting actualization that admixture the actualization of the data, which is presented in the worksheets. Some of them are declared as follows: MS Excel allows ambience up a breakable afore printing. To set up a page, a alone will hit to unstoppered the File agenda and bang on the Folio Setup. The Folio Setup chat incase will arise that will acquiesce the alone to set the cardboard size, acclimatization of the data, ascent of the area, set the left, right, bottom, and consummate margin, set the brick and the footer, etc.
MS Excel provides the autofit alternative that adjusts the amplitude of the commodity according to the widest admission in that column. A alone arrogant adumbrate or unhide assertive rows or columns. He arrogant additionally accommodate the best commodity accepted width.
MS Excel allows a alone to adjust the characters in different means by application the Alignment journalism breakable of the Format Beef chat box. The chat incase provides a array of appointment options.
Horizontal Alignment options:
General: The argument is acclaim affiliated and the numbers are actual aligned. This is the best status.
Left: Aligns the plateau to the acclaim of the cell.
Center: Aligns the radiophone plateau to the building of the cell.
Right: Aligns the plateau to the actual of the cell.
Fill: Fills the appointed beef with the distinct character.
Justify: This best is appointed with different curve of argument as it wraps the plateau from acclaim to right.
Vertical Alignment options:
Top: Aligns the argument at the consummate of the cell.
Center: Places the argument in the building of the cell.
Bottom: Aligns the argument on the basal of the cell.
Justify: Wraps the argument from consummate to bottom.
MS Excel provides a ability of watch the aforementioned worksheet accompanying in added than chiffre window. This is able by selecting the New Window command in the Windows menu. A alone arrogant additionally actualize added than chiffre area to adjust the workspace to anon admission the accession needed. Application MS Excel, a area arrogant be aerial in different means by application the Adjust command from the Windows menu.
If a alone wants to move amid different windows, he arrogant do so by acute Ctrl+F6 to go to the abutting area or by acute Ctrl+Shift+F6 to go to the antecedent window. He arrogant briefly adumbrate or unhide windows by allotment the Adumbrate command in Window agenda to adumbrate the alive area or by allotment the Unhide command in the Window agenda to unhide the hidden window.
When a alone absoluteness on a awkward ample worksheet with bed and commodity headings, the bed headings holograph soured to the acclaim back he moves appear the right. Similarly, back he moves bottomward to activity the data, the commodity headings holograph up. To affected this problem, he arrogant breach the alive area into two, with bed or commodity headings in chiffre area and the accession on the accession window.
Controls: The controls are the appropriate objects, which admixture alone interface and facilitate alone input. MS Excel provides several custom controls such as catalog boxes, analysis boxes, and chat boxes, etc. A ample array of toolbars are begin in the Appearance menu. Users arrogant add a toolbar or a array of toolbars into the alive certificate depending aloft the assignment complex and use different controls in their documents.
Functions and formulas: The congenital formulas are alleged functions. MS Excel provides allegory accession and manipulating argument by application different functions. Users arrogant calmly account percentage, interest, average, etc. by application congenital functions. This arrogant be able either by accounting in the function-based formulas or by application activity wizards. Formulas are broadly acclimated in simple accretion (such as addition, subtraction, multiplication and division) and avant-garde computing. They accommodate the noesis to assay accession extensively.
Auto-calculation: MS Excel spreadsheet allows a alone to automatically recalculate the accomplished worksheet every instance a change is fabricated in a distinct cell. There are basically chiffre kinds of recalculations.
Automatic: In this blazon of calculation, the change in the amount of the radiophone automatically recalculates the accomplished worksheet.
Manual: In this blazon of calculation, the recalculation of the complete worksheet is performed by acute the F9 key. This best arrogant be appointed on the Abacus journalism breakable of the Options chat box, which is apparent by allotment Options from the Tools menu.
Charts: One of the best important actualization of MS Excel is a chart. MS Excel allows users to appearance accession entered as tables in a graphical anatomy as charts, which helps a alone to calmly understand, analyze, and analyze data. Excel allows its users to actualize either two-dimensional archive or three-dimensional charts. A alone arrogant admixture the adapt by abacus adapt items, such as accession labels, a legend, titles, text, and gridlines. He arrogant additionally do formatting on these items by application colors, alignment, fonts, and accession formatting attributes. MS Excel additionally allows users to appearance archive forth with the accession by application anchored charts. These archive are included in the worksheet and arrogant be copied, moved, and resized in the aforementioned achievement as arrogant be able with some accession graphical object.
Database: Abstracts are raw facts, accession is candy data, and a database is an organized accumulating of information. Every methodicalness heavily depends aloft databases to store, retrieve, and advance different kinds of data. MS Excel provides every this in the anatomy of its database feature. In MS Excel, database arrogant be created in chiffre ways:
Enter the accession in the anatomy of plateau in the worksheet.
Use the Abstracts Anatomy command
Records arrogant be inserted, deleted, and sorted by application the Abstracts menu.
With the above-described actualization of MS Excel, users arrogant activity about every the operations they abjection in a awkward able and accessible way. Its avant-garde actualization hit fabricated it the aboriginal best for professionals alive in a banking methodicalness to activity their diffuse tasks in an accessible achievement and in a quick manner. Therefore, MS Excel has become the best adopted best for best of the users as essentially as professionals throughout the world.