pdf

School

Ohio State University *

*We aren’t endorsed by this school

Course

2111

Subject

Computer Science

Date

Feb 20, 2024

Type

pdf

Pages

5

Uploaded by CaptainFlyPerson872

Report
2024/1/12 18:47 Carmen Quiz 4 - Chapter 4 - Countif(s)/Sumif(s)/Averageif(s)/Large/Small/Rank: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940016 1/5 Carmen Quiz 4 - Chapter 4 - Countif(s)/Sumif(s)/Averageif(s)/Large/Small/Rank Due Sep 8, 2023 at 11:59pm Points 20 Questions 10 Available Sep 4, 2023 at 12am - Sep 8, 2023 at 11:59pm Time Limit 15 Minutes Instructions This quiz was locked Sep 8, 2023 at 11:59pm. Attempt History Attempt Time Score LATEST Attempt 1 14 minutes 20 out of 20 Correct answers are no longer available. Score for this quiz: 20 out of 20 Submitted Sep 7, 2023 at 10:12pm This attempt took 14 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 4 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
2024/1/12 18:47 Carmen Quiz 4 - Chapter 4 - Countif(s)/Sumif(s)/Averageif(s)/Large/Small/Rank: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940016 2/5 One major difference between the SUMIF( ) and the SUMIFS( ) functions is that the sum_range argument comes last in the SUMIFS( ) function. False True 2 / 2 pts Question 2 In the SUMIF( ) function, if the sum range is the same as the criteria range, then it may be omitted as the last argument. True False 2 / 2 pts Question 3 Which is the correct formula to determine the rank of the number in cell B2 within the list of numbers in range B2:B10 with respect to a descending order (we want the largest number to be the top rank: 1)? =RANK.EQ(B2, B2:B10, 1) =RANK.EQ(B2, B2:B10, 0) =RANK.EQ(B2:B10, B2, 0) =RANK.EQ(B2:B10, B2, 1) 2 / 2 pts Question 4
2024/1/12 18:47 Carmen Quiz 4 - Chapter 4 - Countif(s)/Sumif(s)/Averageif(s)/Large/Small/Rank: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940016 3/5 When using TRUE or FALSE as criteria in a function, they are considered to be boolean values and therefore should not be put in quotes. True False 2 / 2 pts Question 5 The syntax rules for the criteria in a SUMIF( ) function and AVERAGEIF( ) function are the same as the syntax rules for the COUNTIF( ) function. True False 2 / 2 pts Question 6 Excel treats capital and small letters as the same, so specifying "USA" is the same as specifying "usa", "Usa", etc. True False 2 / 2 pts Question 7 In the COUNTIFS( ) function, every optional argument is treated as an "OR" scenario, meaning only one criteria must be evaluated to true in order for the item to be counted.
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:47 Carmen Quiz 4 - Chapter 4 - Countif(s)/Sumif(s)/Averageif(s)/Large/Small/Rank: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940016 4/5 True False 2 / 2 pts Question 8 Which of the following is true for the SUMIFS( ) and AVERAGEIFS( ) functions? optional arguments are treated as an "AND" scenario meaning every criteria must be evaluated to true in order for the item to be included mixed or absolute cell referencing often applies criteria using a relational expression (>, <, >=, <=, <>) must be in quotes all of the answers listed are true the criteria ranges must all be the same array size (i.e., the same number of cells) 2 / 2 pts Question 9 Given a list of a finishing times at a marathon, which function should you use to rank each runner's place based on these finishing times? MAX SMALL LARGE
2024/1/12 18:47 Carmen Quiz 4 - Chapter 4 - Countif(s)/Sumif(s)/Averageif(s)/Large/Small/Rank: AU23 CSE 2111 - Spreadsheets & DBs (7288) https://osu.instructure.com/courses/151434/quizzes/940016 5/5 RANK.EQ 2 / 2 pts Question 10 What function should be used to count the number of items in a list that meet one and only one specified criterion? COUNTIF( ) COUNT( ) COUNTA( ) all of the answers listed will provide a count of items that meet a specific criterion SUMIF( ) Quiz Score: 20 out of 20

Related Documents

Midterm Exam-103-code2-solution.pdf
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 6 - Chapter 6 - IF Functions_ AU23 CSE 2111 - Spreadsheets & DBs (7288).pdf
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
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
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
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
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
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
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
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