+ X Take Test: ENGR 101 FinG Jsp?course-assessment-id--168711-1&courseJd--101807
ID: 3907661 • Letter: #
Question
+ X Take Test: ENGR 101 FinG Jsp?course-assessment-id--168711-1&courseJd--101807;, Iacontent/d--4918147-18step= null ? | a) ? ? Remaining Time: 1 hour, 57 minutes, 54 seconds. s Question Completion Status: QUESTION 16 3 points Save Answer Select all of the true statements about the table below "Note the frst row and first column are the Cel Callouts from Excel" 1Timel Number of Finishers people 87 When you type in -count B3:812) you get the answer 10 ? When you type in-count(B3:B12) you get the answer 522. When you type in max(B8:B12) you get the answer 80 When you type in -min B8 B12) you get the answer 10. Cick Save ard Submit to save and subit. Click Save All Answers to save ail amsweTS Save All Answers Save and Submit 6 22/2018Explanation / Answer
Statements True :
1.
when you type in = count(B3:B12) you get the answer 10
The count of 10 values from B3 to B12 are 10,26,41,90,87,80,64,56,43 and 25
3.
when you type in = max(B8:B12) you get the answer 80
The maximum value from 80,64,56,43 and 25 is 80
Statements 2 and 4 are false
2. The function is count for the number of values not their sum, 522 is sum not count
4. the minimum value from 80,64,56,43 and 25 is 25 not 10.
Do ask if any doubt. Please upvote.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.