Features of Ms Excel 2003

Worksheet - Features of Ms Excel 2003

Hi friends. Today, I learned all about Worksheet - Features of Ms Excel 2003. Which may be very helpful if you ask me so you. Features of Ms Excel 2003

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:

What I said. It isn't in conclusion that the true about Worksheet. You check this out article for facts about that wish to know is Worksheet.

Worksheet

Workbooks: A document in Ms Excel is called a workbook. Each workbook contains sixteen worksheets by default. A user can convert this estimate by resetting the default options. Worksheets within workbooks make it easy to bind files of associated information. When a user opens a workbook, he can use all the worksheets to achieve a task. To originate a workbook, a user will have to elect the New command from the File menu. To open an existing workbook, a user will have to elect the Open option from the File menu. A user can insert a worksheet between two worksheets by selecting the Worksheet option from the Insert menu.

Using keyboard: The following table provides distinct keyboard shortcuts for selecting a row, column, current cell, worksheet, etc.

To elect Keyboard Shortcuts

Current Cell Enter

Entire Column Ctrl+Spacebar

Entire Row hift+Spacebar

Entire Worksheet Ctrl+Shift+Spacebar

A user can achieve varied kinds of entries in a cell. He can enter text, number, data, and time in a cell. He can also enter some extra characters such as $ % + - / ( ). He can also enter date and time in a cell. He can elect distinct formats for date and time according to his own requirements.

Entering Data in Series: A user can fill a range of cells either with the same value or with the series of values. This can be done using the Autofill cope (small quadrilateral on the bottom-right projection of the active cell).

Cell References: Ms Excel provides three types of cell references: relative, absolute, and mixed. Relative references refer to the cell relative to the given position. Absolute references refer to the exact cell irrespective of the position of the formula. The '$' sign is used to denote an absolute reference. Mixed references are a aggregate of both relative and absolute references. It has one absolute co-ordinate and one relative co-ordinate. $Ci and C are both examples of mixed references.

Ms Excel allows fast searching and instant replacing of data. To crusade or replace the data entered by a user, he can use the Find or Replace command from the Edit menu.

Inserting or Deleting Rows and Columns:

Ms Excel provides the factory to insert rows or columns into the existing worksheet. Inserting a row of data shifts the rest of the rows down and removes the last row of the worksheet. Similarly, inserting a column shifts the rest of the columns to the right and deletes the rightmost column. This occurs because the total estimate of rows and columns remain the same in any case.

Ms Excel provides some formatting features that improve the appearance of the data, which is presented in the worksheets. Some of them are described as follows: Ms Excel allows setting up a page before printing. To set up a page, a user will have to open the File menu and click on the Page Setup. The Page Setup dialog box will appear that will allow the user to set the paper size, orientation of the data, scaling of the area, set the left, right, bottom, and top margin, set the header and the footer, etc.

Ms Excel provides the autofit option that adjusts the width of the column according to the widest entry in that column. A user can hide or unhide obvious rows or columns. He can also furnish the default column thorough width.

Ms Excel allows a user to align the characters in distinct ways by using the Alignment tab page of the Format Cells dialog box. The dialog box provides a estimate of alignment options.

Horizontal Alignment options:

General: The text is left aligned and the numbers are right aligned. This is the default status.

Left: Aligns the contents to the left of the cell.

Center: Aligns the cell contents to the town of the cell.

Right: Aligns the contents to the right of the cell.

Fill: Fills the superior cells with the singular character.

Justify: This option is superior with complicated lines of text as it wraps the contents from left to right.

Vertical Alignment options:

Top: Aligns the text at the top of the cell.

Center: Places the text in the town of the cell.

Bottom: Aligns the text on the bottom of the cell.

Justify: Wraps the text from top to bottom.

Ms Excel provides a factory of viewing the same worksheet simultaneously in more than one window. This is concluded by selecting the New Window command in the Windows menu. A user can also originate more than one window to arrange the workspace to abruptly access the facts needed. Using Ms Excel, a window can be arranged in distinct ways by using the arrange command from the Windows menu.

If a user wants to move between distinct windows, he can do so by pressing Ctrl+F6 to go to the next window or by pressing Ctrl+Shift+F6 to go to the former window. He can temporarily hide or unhide windows by selecting the Hide command in Window menu to hide the active window or by selecting the Unhide command in the Window menu to unhide the private window.

When a user works on a very large worksheet with row and column headings, the row headings scroll off to the left when he moves towards the right. Similarly, when he moves down to see the data, the column headings scroll up. To overcome this problem, he can split the active window into two, with row or column headings in one window and the data on the other window.

Controls: The controls are the extra objects, which improve user interface and facilitate user input. Ms Excel provides some convention controls such as list boxes, check boxes, and dialog boxes, etc. A large estimate of toolbars are found in the View menu. Users can add a toolbar or a estimate of toolbars into the working document depending upon the work complicated and use distinct controls in their documents.

Functions and formulas: The built-in formulas are called functions. Ms Excel provides analyzing data and manipulating text by using distinct functions. Users can surely suspect percentage, interest, average, etc. By using built-in functions. This can be done either by typing in the function-based formulas or by using function wizards. Formulas are widely used in simple computing (such as addition, subtraction, multiplication and division) and developed computing. They furnish the power to analyze data extensively.

Auto-calculation: Ms Excel spreadsheet allows a user to automatically recalculate the whole worksheet every time a convert is made in a singular cell. There are basically two kinds of recalculations.

Automatic: In this type of calculation, the convert in the value of the cell automatically recalculates the whole worksheet.

Manual: In this type of calculation, the recalculation of the unblemished worksheet is performed by pressing the F9 key. This option can be superior on the Calculation tab page of the Options dialog box, which is opened by selecting Options from the Tools menu.

Charts: One of the most important features of Ms Excel is a chart. Ms Excel allows users to view data entered as tables in a graphical form as charts, which helps a user to surely understand, analyze, and collate data. Excel allows its users to originate either two-dimensional charts or three-dimensional charts. A user can improve the chart by adding chart items, such as data labels, a legend, titles, text, and gridlines. He can also do formatting on these items by using colors, alignment, fonts, and other formatting attributes. Ms Excel also allows users to view charts along with the data by using embedded charts. These charts are included in the worksheet and can be copied, moved, and resized in the same way as can be done with any other graphical object.

Database: Data are raw facts, facts is processed data, and a database is an organized range of information. Every club heavily depends upon databases to store, retrieve, and mouth distinct kinds of data. Ms Excel provides all this in the form of its database feature. In Ms Excel, database can be created in two ways:
Enter the data in the form of table in the worksheet.

Use the Data Form command

Records can be inserted, deleted, and sorted by using the Data menu.

With the above-described features of Ms Excel, users can achieve approximately all the operations they want in a very sufficient and easy way. Its developed features have made it the first option for professionals working in a financial club to achieve their lengthy tasks in an easy way and in a quick manner. Therefore, Ms Excel has come to be the most beloved option for most of the users as well as professionals throughout the world.

I hope you have new knowledge about Worksheet. Where you may put to use in your day-to-day life. And just remember, your reaction is passed about Worksheet.