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?
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...
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?

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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps

Recommended textbooks for you

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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science

Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning

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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science

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
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning

Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education

Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY