Carmen Quiz 6 - Chapter 6 - IF Functions_ AU23 CSE 2111 - Spreadsheets & DBs (7288)

pdf

School

Ohio State University *

*We aren’t endorsed by this school

Course

2111

Subject

Computer Science

Date

Feb 20, 2024

Type

pdf

Pages

6

Uploaded by CaptainFlyPerson872

Report
2023/9/22 19:02 Carmen Quiz 6 - Chapter 6 - IF Functions: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940004 1/6 Carmen Quiz 6 - Chapter 6 - IF Functions Due Sep 22 at 11:59pm Points 20 Questions 10 Available Sep 18 at 12am - Sep 22 at 11:59pm Time Limit 15 Minutes Instructions Attempt History Attempt Time Score LATEST Attempt 1 5 minutes 20 out of 20 Correct answers will be available Sep 25 at 12am - Oct 2 at 12am. Score for this quiz: 20 out of 20 Submitted Sep 22 at 7:01pm This attempt took 5 minutes. Please select the appropriate answer to each True/False or Multiple Choice question. There are 10 questions total. Questions will be shown one at a time. You have one attempt at taking this quiz. The quiz is timed at 15 minutes . Correct responses will be available after the due date for the quiz. Materials for this quiz will be taken from the Course Notes Chapter 6 and all lecture materials covered to-date. IMPORTANT! Make sure you read the Course Notes PRIOR to taking this quiz. You will NOT have enough time to read the Course Notes as you progress through the quiz. It is expected that you read the Course Notes PRIOR to taking this quiz. No credit will be given for late submissions. No late submissions or makeups will be allowed. The lowest quiz grade will be dropped. Therefore, if you miss a quiz, this will be the one that is dropped. 2 / 2 pts Question 1 In this nested IF function example, =IF(C4<1000,0,IF(C4<2000,2,1))*C$1 if the value in C4 is 1200, the result is 1*C$1.
2023/9/22 19:02 Carmen Quiz 6 - Chapter 6 - IF Functions: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940004 2/6 False True 2 / 2 pts Question 2 What is wrong with the following formula if cell C4 contains the logical value of TRUE, cell C1 contains the text string eligible and cell C2 contains the text string ineligible ? =IF(C4="TRUE", C1, C2) cell C1 and C2 cannot be referenced in an IF function since "TRUE" with quotes is a label or text string and not a logical value, it could lead to an incorrect result since C2 equates to the text string "ineligible", the function will return incorrect results nothing ; the formula works as expected with no errors 2 / 2 pts Question 3 The IF function evaluates a certain condition and returns the value you specify if the condition is TRUE, and another value if the condition is FALSE. True False
2023/9/22 19:02 Carmen Quiz 6 - Chapter 6 - IF Functions: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940004 3/6 2 / 2 pts Question 4 Does this IF function return the value of 20? A1= FALSE (a boolean value) =IF(A1="False",20,5) False True 2 / 2 pts Question 5 Which of the following is true about the IF function in Excel? the first argument is the logical_test and this test needs to result in a Boolean value - a TRUE or a FALSE the first argument, the logical_test argument, can either be the result of a Boolean function, relational expression, or a reference to a cell containing a Boolean value. all of the listed answers are correct in contrast to the Boolean functions, which result in a TRUE or FALSE value, the IF function can display a variety of results, such as displaying a text message, performing a calculation, or displaying a Boolean value.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2023/9/22 19:02 Carmen Quiz 6 - Chapter 6 - IF Functions: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940004 4/6 you can perform a corresponding math operation in the if_value_true or if_value_false arguments by using arithmetic operators or other Excel functions 2 / 2 pts Question 6 Constructing a decision tree to visually represent the logic in a multi- outcome IF problem is often recommended before translating it into Excel pseudo code and then the nested IF function. True False 2 / 2 pts Question 7 Aaron will only go outside if the temperature is between 62 and 78 degrees inclusive. If cell B2 contains the current temperature, write a formula that will display "may go outside" if the temperature is within the range; otherwise, it will display "will not go outside". =IF(B2>=62, IF(NOT(B2<=78), "may go outside"), "will not go outside") =IF(OR(B2>=62, B2<=78), "may go outside", "will not go outside") =IF(AND(B2<=62, B2>=78), "may go outside", "will not go outside") =IF(AND(B2>=62, B2<=78), "may go outside", "will not go outside") 2 / 2 pts Question 8
2023/9/22 19:02 Carmen Quiz 6 - Chapter 6 - IF Functions: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940004 5/6 The logical value TRUE is treated the same as the text string "TRUE". True False 2 / 2 pts Question 9 Elina has a GPA given in cell G6. If Elina has a GPA greater than 3.0, then she is in Good Standing. If Elina has a GPA less than or equal to 3.0, but greater than 2.0, then she is in OK Standing. Otherwise, she is in Bad Standing. The result should ONLY SHOW either "Good Standing", "OK Standing" or "Bad Standing". Which formula correctly shows this? None of the choices listed are correct. =IF(G6 > 3.0, "Good Standing", IF(G6 > 2.0, "OK Standing", "Bad Standing")) =IF(G6 > 3.0, IF(G6 > 2.0, "OK Standing", "Bad Standing"), "Good Standing") =IF(G6 > 3.0, "Good Standing"), IF(G6 > 2.0, "OK Standing", "Bad Standing") 2 / 2 pts Question 10 If Jane Smith (Employee 1) works on a holiday, then she receives a bonus (cell B5) in addition to her regular pay (cell B4). Otherwise, she
2023/9/22 19:02 Carmen Quiz 6 - Chapter 6 - IF Functions: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940004 6/6 only receives her regular pay (cell B4). Which formula correctly calculates her regular pay plus her holiday pay? A B 1 Employee Worked Holiday 2 1 TRUE 3 4 PAY $500 5 BONUS $100 =IF(B2, B5, B4 + B5) =IF(B2, B5, 0) - B4 =B4 + IF(B2, B5, 0) =IF(B2, B5, B4) Quiz Score: 20 out of 20
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

5-1 Module Five Assignment_ Impact of Cybercrime-2.pdf
Lab04.pdf
hw1.docx
Chicka chicka boom boom lesson plan 5:23.docx
Understanding Alpha-Beta Pruning Enhancing Game Tree Search Efficiency.docx
Carmen Quiz 4 - Chapter 4 - Countif(s)_Sumif(s)_Averageif(s)_Large_Small_Rank_ AU23 CSE 2111 - Sprea
Carmen Quiz 5 - Chapter 5 - Boolean Functions_ AU23 CSE 2111 - Spreadsheets & DBs (7288).pdf
Carmen Quiz 3 - Chapter 3 - Spreadsheet Design_ AU23 CSE 2111 - Spreadsheets & DBs (7288).pdf
Carmen Quiz 1 - Chapter 1 - Spreadsheet Basics_ AU23 CSE 2111 - Spreadsheets & DBs (7288).pdf
WireShark-Lab8_ CS.4310.001.pdf
lab02.py
Week7Algorithms and Decision MakingNelsonDanietta (1).docx
Recommended textbooks for you
Text book image
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
Text book image
Operations Research : Applications and Algorithms
Computer Science
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Brooks Cole
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
Text book image
Operations Research : Applications and Algorithms
Computer Science
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Brooks Cole
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
SEE MORE TEXTBOOKS