Q6.Write a logical if statement that will test for the following conditions:(a) If the cell value in A1 is larger than the cell value in A2 then write in cellA3–"Al beats A2", otherwise write “A2 beats Al". Test this with values of:Al=20 and A2=10; (2) A1 =15 and A2=30; (3) A1 =15 and A2=15.What happens with (3) and can you suggest how you can modify the if statement to deal withties?(b) If the content of cell A1 is between 0 and 50 write “Class A"; If the content of Al is between51 and 100 write “"Class B"; If neither then write "Class C". Place the function in cell A2 andtest with 23, 56, and 94.(c) If the content of cell A1 is between 34 and 76 or 145 and 453 write “In Range", otherwisewrite “Out of Range". Place the function in A2 and test with 12, 36, 87, 243, and 564. Hint:this will require you to use other logical functions (OR, AND, etc.).(d) If the contents of cell Al > 23 and the contents of cell A2 < 56 then write"Houston we have a problem" in cell A3. Otherwise write “Onward through the fog" in cellАЗ.

ANSWER: In the event that the cell A1 contains 10 and the B1 contains the 5, the recipe "=A1+B1*23''…

Q6. Write a logical if statement that will test for the following conditions: (a) If the cell value in Al is larger than the cell value in A2 then write in cell A3–“Al beats A2", otherwise write “A2 beats Al". Test this with values of: Al-20 and A2=10; (2) A1 =15 and A2=30; (3) Al =15 and A2=15. What happens with (3) and can you suggest how you can modify the if statement to deal with ties? (b) If the content of cell Al is between 0 and 50 write “Class A"; If the content of Al is betweer 51 and 100 write “Class B"; If neither then write "Class C". Place the function in cell A2 and test with 23, 56, and 94. (c) If the content of cell Al is between 34 and 76 or 145 and 453 write “In Range", otherwise write “Out of Range". Place the function in A2 and test with 12, 36, 87, 243, and 564. Hint: this will require you to use other logical functions (OR, AND, etc.). (d) If the contents of cell A1 > 23 and the contents of cell A2 < 56 then write "Houston we have a problem" in cell A3. Otherwise write “Onward through the fog" in cell

Q6. Write a logical if statement that will test for the following conditions: (a) If the cell value in Al is larger than the cell value in A2 then write in cell A3–“Al beats A2", otherwise write “A2 beats Al". Test this with values of: Al-20 and A2=10; (2) A1 =15 and A2=30; (3) Al =15 and A2=15. What happens with (3) and can you suggest how you can modify the if statement to deal with ties? (b) If the content of cell Al is between 0 and 50 write “Class A"; If the content of Al is betweer 51 and 100 write “Class B"; If neither then write "Class C". Place the function in cell A2 and test with 23, 56, and 94. (c) If the content of cell Al is between 34 and 76 or 145 and 453 write “In Range", otherwise write “Out of Range". Place the function in A2 and test with 12, 36, 87, 243, and 564. Hint: this will require you to use other logical functions (OR, AND, etc.). (d) If the contents of cell A1 > 23 and the contents of cell A2 < 56 then write "Houston we have a problem" in cell A3. Otherwise write “Onward through the fog" in cell

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Please answer in matlab code.
An argument is expressed in English below. Rhys will go to the beach. If Rhys is excited; then Rhys will go to the beach. Rhys is excited. Variable names are assigned to each English phrase as follows: p: Rhys is excited •q: Rhys will go to the beach Is the argument valid? If valid, then indicate which rule is used for the argument. If invalid, then give truth assignments to the variables that prove the argument is invalid. Pick 4. Check Next
1. Determine if the expression: (!( a>=b) || !( a==c )) is True or False. Given the value of a is 2, b is 10 and c is -5. 2. Determine if the expression: ! (!(a>b) && ( a==c) || ( a>=b ) ) is True or False. Given the value of a is 2, b is 10 and c is -5. 3. Determine if the expression: !( b>c ) || ( c<5 ) is True or False. Given the value of b is 10 and c is -5.
true or false 1. Determine if the expression: ! (!(a>b) || ( a==c) || ( a>=b ) ) is True or False. Given the value of a is 2, b is 10 and c is -5. 2. Determine if the expression: ! (!(a>b) || ( a==c) || ( a>=b ) ) is True or False. Given the value of a is 2, b is 10 and c is -5.
QUESTION 1 Implement the decision structure in the following: Print "spring" if a is equal to b, print "fall" if a is greater than b, otherwise print "break". Use the variables given below: a = 24.0 || b = 24
Write an if-else statement with multiple branches. If givenYear is 2101 or greater, print "Distant future" (without quotes). Else, if givenYear is 2001 or greater (2001- 2100), print "21st century". Else, if givenYear is 1901 or greater (1901-2000), print "20th century". Else (1900 or earlier), print "Long ago". Do NOT end with newline.
Write an expression that prints "Eligible" if userAge is between 18 and 25 inclusive.Ex: 17 prints "Ineligible", 18 prints "Eligible".
Write an expression that prints "Eligible" if userAge is between 18 and 25 inclusive. Ex: 17 prints "Ineligible", 18 prints "Eligible".
Write a if-elif-else statement that distinguishes between a negative number or 0, a number between 0 and 50, and a number greater than or equal 50 by printing one of these three statements: {"It's negative or zero", "It's between 0 and 50", "It's greater than or equal to 50"}.
Write out an IF-THEN-ELSE statement for the following conditions: 1. A person has credit card points and if the number of points entered > 4,999 then output “Enough points for Selection” otherwise output “Not Enough points for Selection” using Variable Points Available. 4. A customer is buying a car for $20,000 and wants to upgrade the stereo speakers for an additional $100. However, if the customer gets the extended stereo package for $250 which includes the upgraded speakers, XM radio, and upgraded visual display. Use variables CarPrice, UpgradedSpeakers and ExtendedStereo for the IF statement. Show the calculation for the total cost of the car depending on options selected.
Q17: Given that A and B are real variables with values 1.5, and 2.5 respectively, and C is integer variable with value 3, evaluate the following: NOT (A < 0) AND (B/C <= 0).
Answer the following question TRUE or False 1. The condition is evaluated first before executing any statement inside the body of If. 2. The statements inside the body of “if” only execute if the given condition returns true. 3. If statement is always used with a condition