MS Excel is a widely used software program nowadays. It is very helpful and it saves a lot of time. It is particularly used in business software terms. It is a processing program which is used for writing letters, making result, making a home budget. It is a spreadsheet program that is used for calculations, making charts and recording data.
Excel and Financial Data:
Financial data included the sets of information which are related to the financial state of the business. Its main purpose is to analyse business performance.
Spreadsheets are often used to store financial data. Most commonly used formulas and functions include:
• Performing basic mathematical operations such as adding columns or rows of numbers.
• Find values such as loss or profit
The function of MS Excel
The most important function of MS Excel is to perform calculations with the help of specific values in a particular order. For this purpose, excel includes many common but important functions that is used to find the sum, average, count, maximum, and minimum value for a range of cells.
Some main and important functions of MS Excel are:
The SUM Function
The sum function is the most used function in MS Excel. The basic syntax for this function is the equals sign (=) and it contains one or more arguments. For example, this function can be used to add these two values A1: A6 as
=SUM (A1: A6)
In this example, ‘=’ is the equal sign, ‘SUM’ is the function name and ‘(A1: A6)’ is the argument.
The AVERAGE Function
It contains the average of the value given in the argument. Its function is to calculate the sum of the cells and then divides that value by the number of cells in the argument.
=AVERAGE (A1: A6)
The COUNT Function
The COUNT function counts the number of cells with the numerical data in the argument. It is helpful in quickly counting items in a cell range.
=COUNT (A1: A6)
The MAX Function
This function determines the highest value in the argument.
MAX (number1, [number2],…)
The MIN Function
This function determines the lowest value in the argument.
MIN ([number1], number2)