DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To display only those records where temperature is below 0 degree you will ____
|
|
Manually extract the data
|
|
|
Sort the data
|
|
|
Filter the data
|
|
|
Use Goto option
|
Explanation:
Detailed explanation-1: -Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2, "Over Budget", "OK") =IF(A2=B2, B4-A4, "")
Detailed explanation-2: -Description. Returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December).
There is 1 question to complete.