Features of MS Excel 2003
MS Excel can be customized to fit a user's goals. And 'widespread in financial institutions. The features of MS Excel are as follows:
Workbooks: A document is an MS Excel workbook. Each workbook contains sixteen worksheets by default. A user can change this number to reset the default settings. Worksheets in workbooks make it easy to bind files of related information. When a user with a class, he can use all the sheetsperform a task. To create a workbook, a user of the new command in the File menu. To open an existing workbook, a user selects Open from the menu. A user can insert a worksheet between two worksheets, select Worksheet from the Insert menu.
Using the keyboard: The following table provides numerous links to select a row, column, current cell, spreadsheets, etc.
You can choose shortcuts
Current CellExport
All columns CTRL + Space
The full range hift + Spacebar
All Ctrl + Shift + Spacebar Worksheet
A user can perform different types of elements in a cell. You can enter text, numbers, dates and time in a cell. He may also have some special characters like $% + – / (). He is also the time and date in a cell. You can choose different formats date and time to suit your needs.
Entering data into a series, a user can fill a variety of cells orwith the same value or range of values. This can be done using the Autofill handle (small square at the bottom right of the active cell).
Cell references: MS Excel provides three types of cell references: relative, absolute and mixed. The references refer to cells than the particular situation. Absolute references refer to the specific cell irrespective of the formula. The '$' characters are used to indicate an absolute reference. Mixed references are acombination of both relative and absolute references. Has a coordinate in absolute and relative coordinate. CI and C $ 1 $ are both examples of mixed references.
Excel offers a quick search and direct exchange of data. To check or change the information entered by a user can use the search or replace command from the Edit menu.
Insert or delete rows and columns:
MS Excel allows you to insert rows or columns in the existing worksheet. Insertion of a sequencedata moved the rest of the lines and remove the last row of the spreadsheet. Similarly, insert a column, the rest of the columns to the right and the rightmost column. This occurs because the total number of rows and columns remain the same in every case.
MS Excel provides several formatting features that enhance the appearance of the data presented in the spreadsheet. Some of them are as follows: MS Excel, you can create a page for printing. Acreating a page, a user in the File menu, click Page Setup. The dialog box that allows the user the size, location data, scaling of the area, left, right, bottom and top of the head and feet, etc.
Excel offers automatic selection of control to adjust the column width in the widest entry in this column. A user can display or hide some rows or columns. He may alsocolumn width default standard.
MS Excel allows users to adapt the characters in different ways using the Alignment tab of the Format Cells dialog box. The box contains a number of customization options.
Horizontal alignment options:
General: The text is left-aligned and numbers right in line. This is the default state.
Left: shows the contents on the left side of the cell.
Centre: Allow cell contents to the center of the cell.
Right:Allow the contents to the right of the cell.
Filling: Fill the selected cell with a single character.
Justify: This option has several lines in the text wraps as content from left to right.
Vertical alignment options:
Top: shows the text at the top of the cell.
Centre places text at the center of cells.
Bottom: shows the text at the bottom of the cell.
Justify: wraps the text from top to bottom.
MS Excel offersopportunity to see the same spreadsheet simultaneously in more than one window. This is achieved by selecting the New Window command in the Windows menu. A user can also work as a window to quickly access the information needed to make. Using MS Excel, a window can be arranged in different ways using the Arrange command from the Windows menu.
If a user wants to move between different windows, you can do this by pressing Ctrl + F6 to move to the next screen orCtrl + Shift + F6 to go to the previous window. He can temporarily hide or show the ability to hide the Windows menu command window to hide the active window or choose View in the Window menu hidden window visible.
When a user is working on a large spreadsheet with row and column headers, row headers scroll left when it moves to the right. Also, if you move down to the data to see the column headers to go. To overcomeproblem, divide the active window into two parts with the row or column headers and data in a window at the second window.
Controls: are special objects that improves and facilitates user input from the user. Excel offers a series of custom controls such as lists, check boxes and dialog boxes, etc. Many of the toolbars in the View menu. Users can use a toolbar or a set of toolbars added in the working paper which provided work andthe use of different ministries in their documents.
Functions and Formulas: Formulas of built-in functions are called. MS Excel provides analyzing data and manipulate text using various functions. Users can easily calculate percentages, interest, media, etc., through built-in functions. This can be done either by writing formulas based on function or using the wizards. The formulas are widely used in simple machines (such as addition, subtraction, multiplication and division) andadvanced computers. They provide the analytical skills combined.
Auto-calculation: Microsoft Excel spreadsheet automatically recalculates the entire spreadsheet every time changes are made in a single cell. There are basically two types of calculations.
Auto: In this type of calculation, the change in value of the cell automatically calculates the entire worksheet.
Guide: In this type of calculation, the recalculation of the entire worksheetperformed by pressing F9. These options can be selected on the Calculation tab of the Options dialog box, click Options on the menu is opened.
Figure: A key feature of MS Excel is a chart. MS Excel allows users access to data entered as tables in a graphical form as charts that help you to understand easily see and analyze data comparison. Excel offers users the option of two-dimensional graphics and three-dimensional graphics to create. A usergraph can be improved by adding graphic elements, such as data labels, a legend, titles, text and video. It can also markup on these items using colors, alignment, fonts and other formatting features. Excel users can also view the maps using the data tables included. These maps are included in the spreadsheet and can be copied, moved, and the same amount as can be done with any other graphic object.
Database: raw data are facts, information,processed data, and a database is an organized collection of information. Every organization depends heavily on databases to store, retrieve and manage different data types. Excel has all these in the form of database function. In MS Excel, database can be created in two ways:
Enter information in the form of a table in the spreadsheet.
Using data from the command module
Records can add, delete and sort through the Data menu.
With the abovefunctions in MS Excel, users can perform almost all operations as they see fit in a very effective and convenient. The advanced features, has the first choice for professional work in a bank in Their tasks along easily and quickly. Therefore, MS Excel is the preferred choice for most users, and training in the world.
Related posts:
- Excel Tutorial – How to Construct a Compounding Interest Financial Calculator periods
- Weighted average calculations in Microsoft Excel
- Confidence Interval Calculations with Microsoft Excel
- Using Quicken Calculator
- As a free calculator in Microsoft Excel to build!
- Concrete Calculator
- Poker Calculator Wars Part 3 – Edge vs. Poker Tournament Indicator
- Piggybacking appeared in Life Insurance Calculator
- Loan Payment Calculator
- The IPAD – ideal for the book Lover
