USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
IF
|
|
|
SUM
|
|
|
SUMIF
|
|
|
AVERAGE
|
Detailed explanation-1: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10.
Detailed explanation-2: -In a worksheet, tap the first empty cell after a range of cells that has numbers, or tap and drag to select the range of cells you want to calculate. Tap AutoSum. Tap Sum. Tap the check mark.
Detailed explanation-3: -Excel SUM is a math and trig function that adds values. The syntax of the SUM function is as follows: SUM(number1, [number2], …) The first argument is required, other numbers are optional, and you can supply up to 255 numbers in a single formula.
Detailed explanation-4: -SUM: This function adds all the values of the cells in the argument. AVERAGE: This function determines the average of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument.
Detailed explanation-5: -A function in a spreadsheet program that inserts a formula in the selected cell that adds the numbers in the column above it. It sets the range of cells by looking for numeric data above the selected cell.