FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The so-called logic function below is____
A
If
B
Sumif
C
Countif
D
Logif
Explanation: 

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: -All digital systems can be constructed by only three basic logic gates. These basic gates are called the AND gate, the OR gate, and the NOT gate. Some textbooks also include the NAND gate, the NOR gate and the EOR gate as the members of the family of basic logic gates.

Detailed explanation-3: -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-4: -An inverter circuit outputs a voltage representing the opposite logic-level to its input. Its main function is to invert the input signal applied. If the applied input is low then the output becomes high and vice versa.

There is 1 question to complete.