Examine the following spreadsheet: A C Clerk Hours Sales Flags 1 Jim 18 126 2 3 Kate 20 189 Judy 21 4 105 Aaron 32 270 3 If a manager typed "=INDEX(A2:D5, 3, 3)" into cell A6, what value would be returned?

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 25PPS
icon
Related questions
icon
Concept explainers
Question

7. See picture 

Examine the following spreadsheet:
A
C
Clerk
Hours
Sales
Flags
1
Jim
18
126
3.
Kate
20
189
1
4
Judy
21
105
5
Aaron
32
270
3.
If a manager typed "=INDEX(A2:D5, 3, 3)" into cell A6, what value would be
returned?
Your Answer:
2.
Transcribed Image Text:Examine the following spreadsheet: A C Clerk Hours Sales Flags 1 Jim 18 126 3. Kate 20 189 1 4 Judy 21 105 5 Aaron 32 270 3. If a manager typed "=INDEX(A2:D5, 3, 3)" into cell A6, what value would be returned? Your Answer: 2.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Points, Lines and Planes
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,