Excel Functions and Purposes

Running Head: EXCEL FUNCTIONS. 1
EXCEL FUNCTIONS AND PURPOSE
Name:
Institution:
Date:

EXCEL FUNCTIONS. 2
Excel functions and purposes.
An Excel function is a known formula that executes calculations by means of
particular values in a certain direction. Excel comprises of several collective functions that
can be used to immediately determine the median, means, mode, summations or total,
maximum and minimum value for an array of cells. Excel is used for storing, consolidating,
manipulating numbers and data. It is also used to assemble data into graph and tables
(Moriarty, 2018).
The purposes of excel functions.
Excel worksheets is very useful tool in storing financial data. The Excel worksheet
has functions and formulas that are very important in carrying out simple mathematical
processes such as finding totals in columns and rows of various figures, determining profit or
loss values in a worksheet, computing repayment schedule for loans or mortgages in a
worksheet and determining the mean, median, mode, summations or total, maximum and
minimum value for an array of cells.
Excel is an important tool in data analysis, it permits operators to analyse data in a
worksheet by means of numerous diverse formulas. The use of formulae in excel worksheet
enable the users to determine particular data information, stringing the data together,
appraising the data or conversion of data. The excel worksheet also execute complicated
calculations and financial analysis (Moriarty, 2018).
Excel spreadsheet has the capacity of analysing data into graphs by row, column or
group. Data can also be temporarily organised to allocate characteristics such as a colour to
cells within a specific range or specific value. Data can also be immediately organised and
filtered to give information of particular set of values or bring into line data in a particular
direction (Moriarty, 2018).