a) What actions or steps in Excel will arrange the given spreadsheet in alphabetical and ascending order of Surname?b) 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?c) Write the Excel function to determine the number of salespersons who had a Sales Total above the given “Average Sales Total”?d) Which type of graph will be suitable for representing the above sales revenue by regions?e) In which column(s) might replication have been used?f) What formula was used to arrive at the Company Sales Total? 123456789101112131411)ABсFirst NameAnnaAmalCharlesRickyAngelaRayanNancyDEWilliamsWilsonBronsonMartinLagardeIrshadBarraLast Name RegionNorthWestEastSouthSouth WestFNorth EastSouth EastGTechFast SolutionsSalesperson's Sales Book (in '000s)Q1Q2Q3H4000040000230002000032000 3100033000 3500055000 570004400043000350003700045000220003150037500510004200038000Q450000240002600034000540004100036000CompanySales ToAverage SalesTotalSales Total175000890001205001395002170001700001460001057000151000

Answer: We have written the command and output and also attached output and also our guide liens is…

Answered: a) What actions or steps in Excel will…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

a) What actions or steps in Excel will arrange the given spreadsheet in alphabetical and ascending order of Surname?

b) 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?

c) Write the Excel function to determine the number of salespersons who had a Sales Total above the given “Average Sales Total”?

d) Which type of graph will be suitable for representing the above sales revenue by regions?

e) In which column(s) might replication have been used?

f) What formula was used to arrive at the Company Sales Total?

12345
6789
10
11
12
13
14
11)
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
F
North East
South East
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
50000
24000
26000
34000
54000
41000
36000
Company
Sales To
Average Sales
Total
Sales Total
175000
89000
120500
139500
217000
170000
146000
1057000
151000

Expert Solution

Step by step

Solved in 4 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions