DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
*? NAME #
|
|
|
DIV / 0 #
|
|
|
! NUM #
|
|
|
VALUE #
|
Detailed explanation-1: -If you enter a number too small or too large you will get the #NUM! error. For example, the formula =1000^500 (1000 multiplied by itself 500 times) would calculate a number too large for Excel, resulting in the #NUM! error.
Detailed explanation-2: -=LARGE(array, k) The formula uses the following arguments: Array (required argument) – This is the array or range of data for which we wish to determine the largest value. K (required argument) – This is an integer that specifies the position from the largest value in the array or range of cells of data to return.
Detailed explanation-3: -#NUM! error – If the results of RATE do not converge to within 0.0000001 after 20 iterations, RATE returns the #NUM! error value. This may be caused by failure to use the negative or positive sign with regards to cash flow conventions.