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…

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?

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?

Principles of Information Systems (MindTap Course List)

13th Edition

ISBN:9781305971776

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter14: Ethical, Legal, And Social Issues Of Information Systems

Section: Chapter Questions

Problem 16SAT

See similar textbooks

Similar questions

brainwash briefcivilize coach cultivatedevelop discipline drilledify enlighten exercise explainfosterimprove indoctrinate inform instructmaturenurturerearschooltrain tutor objective blessed blest blissfulcheerful contenteddelightedecstatic elatedgladjoyful joyous jubilantlivelymerryoverjoyedpeaceful pleasant pleasedthrilledupbeat import java.util.Scanner;import java.io.FileInputStream;import java.io.IOException; public class LabProgram { public static void main(String[] args) throws IOException { Scanner scnr = new Scanner(System.in); int NUM_CHARACTERS = 26; // Maximum number of letters int MAX_WORDS = 10; // Maximum number of synonyms per starting letter String[][] synonyms = new String[NUM_CHARACTERS][MAX_WORDS]; // Declare 2D array for all synonyms String[] words = new String[MAX_WORDS]; // The words of each input line /* Type your code here. */ }}
Special Instructions: a. Refer Internet, Elibrary, Library Books & Handouts. (Wikipedia reference is not considered as a valid reference)b. Mention the Books and websites referred.c. Explanation should be neatly hand written (either in blue or black colour pen) with neat sketches in pencil. Name and ID should be mentioned on each sheet.d. Neatness and referencing- carry 1 mark eache. Assignments should be uploaded in PDF form.Academic Integrity & Plagiarism Policy: The student should be ready to prove the authenticity of the work done. If any forms of plagiarism/reproduction of answers are discovered, student will be asked to repeat the assignment, if first offence; otherwise will be awarded zero marks.To my Lecturer Mr. Darsan R S, I certify that all of this work is done by my self as in accordance with the Academic Integrity / Plagiarism policies.I am responsible for any violations with regard to this.
question atatched
Brieflydescribeinformationsystemactivitiesandgivepracticalexamplesaboutthe informationsystemactivitiesinyourorganizationoranyorganizationyouarefamiliar with.
Please written by computer source Question 3 Solve the equation. Show your work on your work document. 81^(x)=((1)/(9))^(x+3)
Demonistratrw what the codes
Boston AmericansNew York GiantsChicago White SoxChicago CubsChicago CubsPittsburgh PiratesPhiladelphia AthleticsPhiladelphia AthleticsBoston Red SoxPhiladelphia AthleticsBoston BravesBoston Red SoxBoston Red SoxChicago White SoxBoston Red SoxCincinnati RedsCleveland IndiansNew York GiantsNew York GiantsNew York YankeesWashington SenatorsPittsburgh PiratesSt. Louis CardinalsNew York YankeesNew York YankeesPhiladelphia AthleticsPhiladelphia AthleticsSt. Louis CardinalsNew York YankeesNew York GiantsSt. Louis CardinalsDetroit TigersNew York YankeesNew York YankeesNew York YankeesNew York YankeesCincinnati RedsNew York YankeesSt. Louis CardinalsNew York YankeesSt. Louis CardinalsDetroit TigersSt. Louis CardinalsNew York YankeesCleveland IndiansNew York YankeesNew York YankeesNew York YankeesNew York YankeesNew York YankeesNew York GiantsBrooklyn DodgersNew York YankeesMilwaukee BravesNew York YankeesLos Angeles DodgersPittsburgh PiratesNew York YankeesNew York YankeesLos Angeles DodgersSt.…
1. Moving images or pictures are represented by _____________. A. Alphanumeric data B. Video data C. Image data D. Audio data 2. Which of the following is not the types of organizational structures? A. Traditional B. Team C. Leader D. Virtual 3. Which of the following components performs arithmetic/logic unit, the control unit, and the register areas? A. ALU B. Control unit C. CPU D. Memory 4. A __________ requires text commands to the computer to perform basic activities. A. Menu driven interfaces B. Natural user interfaces C. Graphical languages interfaces D. Command-based interfaces 5. A basic building block of information, consisting of uppercase letters, lowercase letters, numeric digits, or special symbols are represented by _____________. A. Field B. Character C. Record D. File 6. Which of the following frequency range is a signals in the 300 GHz-400 THz frequency range sent through air as light waves? A. Radio B. RFID C. Infrared D. Microwave…
Mary and Jane have joint authorship for their book “Cooking 101”. Mary passed away before Jane. The term for their copyright will end when?
dont post irrelevant and existing code dislike for sure answer only u know
1Define intellectual property. 2Explain copyright using an example. 3 When is your intellectual property copyright protected? 4 A patent protects an invention. An invention may be a process, amethod, a machine, a device, a new material, a chemical compoundor chemical composition. In South Africa, in order to be patentable,an invention must meet certain criteria. What 3 criteria must bemet.
Prepare and submit a comprehensive report that includes all necessary citations. Here are the six tiers of our computer science hierarchical structure: research in computational theory and the design of computer components. The last link in the chain is the computer. Among the offerings: The fifth level In the fourth grade, students learn about global issues. What problems does social computing have at the sixth level?