DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Multiple arguments must be separated by a comma. For example, the function =SUM(A1:A3, C1:C2, E2) will add the values of all cells in the three arguments.
Detailed explanation-2: -IF is one of the Logical functions in Microsoft Excel, and there are 3 parts (arguments) to the IF function syntax: logical test: TEST something, such as the value in a cell. value if true: Specify what should happen if the test result is TRUE. value if false: Specify what should happen if the test result is FALSE.
Detailed explanation-3: -A range of cells is described in terms of the top left cell and the bottom right cell references separated by a colon. Comma (, )-This is used to define non adjacent cells (e.g. “A1", “B2"). The comma is also known as the union operator.