What actions or steps in Excel will produce a list/display of those who had a sales revenue of £138,500 or more in the year?

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

 What actions or steps in Excel will produce a list/display of those who had a sales revenue of £138,500 or more in the year?   

1
2
3
4
5
6
7
8
9
10
11
12
13
14
A
B
с
First Name
Anna
Amal
Charles
Ricky
Angela
Rayan
Nancy
D
E
Williams
Wilson
Bronson
Martin
Lagarde
Irshad
Barra
Last Name Region
North
West
East
South
South West
North East
South East
F
G
TechFast Solutions
Salesperson's Sales Book (in '000s)
Q1
Q2
Q3
H
40000 40000
23000
20000
32000
31000
33000 35000
55000 57000
44000 43000
35000 37000
45000
22000
31500
37500
51000
42000
38000
Q4
I
50000
24000
26000
34000
54000
41000
36000
Company
Sales Total
Average Sales
Total
Sales Total
175000
89000
120500
139500
217000
170000
146000
1057000
151000
Transcribed Image Text:1 2 3 4 5 6 7 8 9 10 11 12 13 14 A B с First Name Anna Amal Charles Ricky Angela Rayan Nancy D E Williams Wilson Bronson Martin Lagarde Irshad Barra Last Name Region North West East South South West North East South East F G TechFast Solutions Salesperson's Sales Book (in '000s) Q1 Q2 Q3 H 40000 40000 23000 20000 32000 31000 33000 35000 55000 57000 44000 43000 35000 37000 45000 22000 31500 37500 51000 42000 38000 Q4 I 50000 24000 26000 34000 54000 41000 36000 Company Sales Total Average Sales Total Sales Total 175000 89000 120500 139500 217000 170000 146000 1057000 151000
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY