USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Function
|
|
|
Cell Reference
|
|
|
Styles
|
|
|
SmartArt
|
Detailed explanation-1: -You can create a formula to calculate values in your worksheet by using a function. For example, the formulas =SUM(A1:A2) and SUM(A1, A2) both use the SUM function to add the values in cells A1 and A2. Formulas always start with an equal sign (=).
Detailed explanation-2: -Functions are generally represented as y = f(x) and it states the dependence of y on x, or we say that y is a function of x. Functions formulas define the mathematical rules to connect one set of elements to another set of elements.
Detailed explanation-3: -A function is a predefined formula that performs calculations using specific values in a particular order. All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and minimum value for a range of cells.