USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
If
|
|
Sumif
|
|
Countif
|
|
Logif
|
Detailed explanation-1: -A logic function can be a top-level design entity, which is a logic function that is the root of a design hierarchy, or a lower-level logic function (or, subdesign). A logic function can instantiate any number of lower-level logic functions, and is the parent for the lower-level logic functions.
Detailed explanation-2: -Logic gates are used to make decisions so that electrical outputs only ‘turn on’ when the correct logic sequence has been applied. Each logic gate has a name that helps to describe how different inputs will determine the possible outputs .
Detailed explanation-3: -A logic gate is a device that acts as a building block for digital circuits. They perform basic logical functions that are fundamental to digital circuits. Most electronic devices we use today will have some form of logic gates in them.