USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
This error means that you used an incorrect type of data as a formula input.
|
|
*? NAME #
|
|
|
DIV / 0 #
|
|
|
! REF #
|
|
|
VALUE #
|
Explanation:
Detailed explanation-1: -Explanation: excel formula error occurs when the formula used incorrectly.
Detailed explanation-2: -#NUM! The #NUM! error occurs when your formula contains invalid numeric values.
Detailed explanation-3: -Try using functions instead of operations In this case, try using a function instead. Functions will often ignore text values and calculate everything as numbers, eliminating the #VALUE! error. For example, instead of =A2+B2+C2, type =SUM(A2:C2).
There is 1 question to complete.