Question: please solve this exercise on excel here is the excel sheet - In column M, type in the functions displayed in column N and check


- In column M, type in the functions displayed in column N and check what kind of error they will return (if any). 3. In the table entitled Logical Functions: - Test A and Test B are two logical values. Insert in columns H,I,J,K, and L the corresponding functions to get respectively the answers of the following (for all the possible combinations of Test A and Test B): (Try to guess the answers first before writing the functions, and compare your answers to the functions output) - Test A AND Test B - Test A OR Test B - NOT (A AND B) - NOT A OR NOTB - NOT A AND NOT B Lotical Fenctiens - In column M, type in the functions displayed in column N and check what kind of error they will return (if any). 3. In the table entitled Logical Functions: - Test A and Test B are two logical values. Insert in columns H,I,J,K, and L the corresponding functions to get respectively the answers of the following (for all the possible combinations of Test A and Test B): (Try to guess the answers first before writing the functions, and compare your answers to the functions output) - Test A AND Test B - Test A OR Test B - NOT (A AND B) - NOT A OR NOTB - NOT A AND NOT B Lotical Fenctiens
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
