Carmen Quiz 5 - Chapter 5 - Boolean 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
2024/1/12 18:51 Carmen Quiz 5 - Chapter 5 - Boolean Functions: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940019 1/6 Carmen Quiz 5 - Chapter 5 - Boolean Functions Due Sep 15, 2023 at 11:59pm Points 20 Questions 10 Available Sep 11, 2023 at 12am - Sep 15, 2023 at 11:59pm Time Limit 15 Minutes Instructions This quiz was locked Sep 15, 2023 at 11:59pm. Attempt History Attempt Time Score LATEST Attempt 1 12 minutes 20 out of 20 Correct answers are no longer available. Score for this quiz: 20 out of 20 Submitted Sep 15, 2023 at 6:26pm This attempt took 12 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 5 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 A1= TRUE, A2= FALSE, A3 = TRUE
2024/1/12 18:51 Carmen Quiz 5 - Chapter 5 - Boolean Functions: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940019 2/6 What is the result of =NOT(A1,A2,A3) None of the answers listed are correct. False True 2 / 2 pts Question 2 Which formula below equates to FALSE? ="Big" > "Apple" ="Dimple" >= "Crack" ="BIG" = "big" none of the formulas listed equate to FALSE ="Apple" > "Big" 2 / 2 pts Question 3 The formula =OR( D2:D6 <= C2:C6) is not valid syntax and will result in a #VALUE! error or an incorrect result from Excel. True
2024/1/12 18:51 Carmen Quiz 5 - Chapter 5 - Boolean Functions: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940019 3/6 False 2 / 2 pts Question 4 Evaluate this function: ="CSE" ="cse" False True 2 / 2 pts Question 5 Evaluate the following function: NOT(30<35) OR(NOT(A),NOT(B)) TRUE FALSE AND(TRUE) 2 / 2 pts Question 6
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
2024/1/12 18:51 Carmen Quiz 5 - Chapter 5 - Boolean Functions: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940019 4/6 Given the table: A B C D 1 Name Has Dog Has Cat Has Bird 2 Milo TRUE FALSE TRUE 3 Hina FALSE TRUE TRUE Answer the following question using an Excel formula: Do BOTH Milo and Hina NOT have cats? =NOT(OR(C2, C3)) =OR(NOT(C2, C3)) =NOT(C2, C3) =OR(NOT(C2), NOT(C3)) 2 / 2 pts Question 7 What types of questions do Boolean functions answer? Does the Boston trip cost more then the New York trip? Was last year's income greater than this year's income? all of the responses listed are the types of questions Boolean functions can answer Is travel the largest component of the total cost of the trip? Is the total cost of the trip within budget?
2024/1/12 18:51 Carmen Quiz 5 - Chapter 5 - Boolean Functions: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940019 5/6 2 / 2 pts Question 8 Given the table: A B C D 1 Name Has Dog Has Cat Has Bird 2 Milo TRUE FALSE TRUE 3 Hina FALSE TRUE TRUE Answer the following question using an Excel formula: Does Milo have a dog and a cat (T/F)? =AND(B2) + AND(C2) =AND(B2, C2) =NOT(B2 + C2) =OR(B2, C2) 2 / 2 pts Question 9 Arguments to the AND or OR functions many consist of any combination of cell references, values, and ranges such that each reduce to a single TRUE or FALSE value. True False
2024/1/12 18:51 Carmen Quiz 5 - Chapter 5 - Boolean Functions: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940019 6/6 2 / 2 pts Question 10 Which of the following keywords or phrases would NOT be used to indicate the use of an OR function in the answer? at least one all of the listed keywords or phrases would be used to indicate the use of the OR function or any all 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

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 6 - Chapter 6 - IF 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
lab6_support.py
Recommended textbooks for you
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
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
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
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
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning
SEE MORE TEXTBOOKS