What are functions in Excel? Name any four functions with its uses and syntax?
Answers
Answer:
To help you get started, here are 5 important Excel functions you should learn today.
The SUM Function. The sum function is the most used function when it comes to computing data on Excel. ...
The TEXT Function. ...
The VLOOKUP Function. ...
The AVERAGE Function. ...
The CONCATENATE Function
Answer:
FUNCTION IN EXCEL is a predefined formula that is used for specific values in a particular order. Function is used for quick tasks like finding the sum, count, average, maximum value, and minimum values for a range of cells. For example, cell A3 below contains the SUM function which calculates the sum of the range A1:A2.
1.SUM for summation of a range of numbers
2.AVERAGE for calculating the average of a given range of numbers
3.COUNT for counting the number of items in a given range
Explanation:
The importance of functions
Functions increase user productivity when working with excel. Let's say you would like to get the grand total for the above home supplies budget. To make it simpler, you can use a formula to get the grand total. Using a formula, you would have to reference the cells E4 through to E8 one by one. You would have to use the following formula.
= E4 + E5 + E6 + E7 + E8
With a function, you would write the above formula as
=SUM (E4:E8)
As you can see from the above function used to get the sum of a range of cells, it is much more efficient to use a function to get the sum than using the formula which will have to reference a lot of cells.