Explain Different Uses of Excel in Business and Commerce

Microsoft Excel is very useful in Business and Commerce. Following is a list of the uses of Microsoft Excel in Business and Commerce:

Explain different uses of MS Excel in Business and Commerce

1. Creating Computerized Worksheets

Microsoft Excel is a computer software with electronic worksheets. You can easily input, edit, format your business data in computerized worksheets provided by MS Excel. You can manipulate business data easily and efficiently.

2. Recording Business Data

Microsoft Excel can be used in business and commerce for recording the daily transaction records of your business. It provides the facility to store and maintain large amounts of records easily and quickly.

3. Use of Excel in Accounts Department

a) Accounting System

Microsoft Excel can be used to manage the accounting system of your business organization.It records daily transactions of the organization.

b) Prepare Accounting Documents

Microsoft Excel can be used to prepare balance sheet, trial balance, ledger and other accounting sheets.

4. Maintaining Stock System

Microsoft Excel can be used to record the stock of products and materials for a business organization. In addition Excel provides many functions to perform quick calculations for stock records.

5. Graphical Representation of Data

Microsoft Excel provide rich facilities to represent data graphically. Excel uses its Charts feature to represent data in interesting and colorful way so that the users can understand the facts and figures easily and quickly.

uses-of-microsoft-excel-in-business-organizations-charts-graph

Explain Different Uses of Excel in Business and Commerce

6. Predefined Functions

Microsoft provides a feature rich set of built-in functions including mathematical functions, statistical functions, logical functions, text functions and date and time functions etc. These functions make the large and complex calculations very easy and quick.

How to Use Predefined Functions of Microsoft Excel

7. Quick Calculations

Microsoft Excel provides different mathematical and other operators and predefined functions to apply different formulas on data.

Quicker Calculations in Microsoft Excel

8. Automatic Recalculation

Microsoft provides the popular Automatic Recalculation feature. If you change the data then the results of the formulas will be automatically recalculated.

Comments

Explain Different Types Of Output Devices

Output devices Out put devices are used to display results of processing to the user. They perform the following functions: Receive results from memory Convert data into human readable form Display results to the user Examples include: Monitor, printer, plotter, speaker, and multimedia projector. Different Types of Output Devices 1. Monitor LCD Monitor CTR Monitor Monitor is the most commonly used output device used to display results of processing. It has a TV like shape. Pictures on monitor are formed with picture elements called PIXEL. Monitors may be Monochrome that will display results in Black & White. Color Monitors are also available. They display results in multi colors. Monitor produces soft copy output. 2. Printers Printers are used to produce hard copy out put. They print processing results on paper. Printers are divided into two main categories: · ...

What are Different Pointing Input Devices

Topic: What are Different Pointing Input Devices A Pointing input device is an input device which is used to control the movement of the pointer to select items on a display screen. Examples of pointing input devices include: Mouse, Track ball, Joystick, Pointing Stick, Graphic Tablet, Touch pad or Track pad, Touch Screen and Light pen etc. 1. Mouse Explain different Pointing input devices - Mouse Mouse is an input device used to control motion of pointer on screen. A mouse has two or three buttons called Left, Right and Middle button. Buttons are used to perform different functions. 2. Track Ball Track Ball is an input device like a mouse. It is used in Lap top computers to control motion of pointer on screen. It is a pointing device like upside down mouse. It has a ball on its upper side. This ball is moved by fingers or thumb and the pointer moves accordingly on screen. 3. Joystick Joystick is an input device...

Explain different types of storage devices

Topic: Explain different types of storage devices in Computer systems Storage Devices Storage devices are used to store data and instructions permanently. Storage devices are also called secondary storage devices / backing storage devices / external storage devices or auxiliary storage devices. Examples of storage devices include Hard Disk, CD and DVD etc. Why Secondary Storage Devices are Used? Secondary storage devices are used because: Primary memory(RAM) is volatile and temporary. When computer is switched off, all data in ram is erased. Storage devices can store large amounts of data and instructions permanently whereas Primary memory has less capacity of storing data. Types Of Storage Devices There are three main types of storage devices: Magnetic Tape Magnetic Disk Optical Disk Flash Memory storage devices 1. Magnetic Tape Magnetic tape is the oldest storage device. It is made of plastic coated with m...

Perfect Computer Notes

Search This Blog