Tutorial_Assignment_StudentName_updated9_19_21

Enter your answer in the cell below each question. Q1. What are two business applications of the sort operations? enter your answer here… Q2. How many keys (columns or _x001F_ elds) can be used when so Q3. What are two business applications of database statistical func enter your answer here… Q4. What are some business applications of the Pivot table? enter your answer here… Q5. Sort the table by gender(Z to A), income (A to Z or Smallest to L FIRST NAME LAST NAME AGE GENDER OCCUPATION INCOME Randy Smith 55 M Professor $90,000 Fay Brown 22 F Engineer $75,000 Adam Mills 37 M Engineer $55,000 Andrea Harris 29 F Teacher $31,000 Moe Santos 44 M Officer $49,000 Bob Sakas 39 M Engineer $72,000 Vicki Hashim 22 F Teacher $34,000 Paula Schlosser 66 F Nurse $56,000 Jack Negrete 51 M Artist $32,000 Mary Fisher 27 F Teacher $33,000 Sue Hayward 26 F Engineer $61,000 Jacky Chipres 77 F Engineer $52,000 Lora Heredia 26 F Nurse $48,000 Q6. In the table below, filter all female engineers. FIRST NAME LAST NAME AGE GENDER OCCUPATION INCOME Randy Smith 55 M Professor $90,000 Fay Brown 22 F Engineer $75,000 Adam Mills 37 M Engineer $55,000

Andrea Harris 29 F Teacher $31,000 Moe Santos 44 M Officer $49,000 Bob Sakas 39 M Engineer $72,000 Vicki Hashim 22 F Teacher $34,000 Paula Schlosser 66 F Nurse $56,000 Jack Negrete 51 M Artist $32,000 Mary Fisher 27 F Teacher $33,000 Sue Hayward 26 F Engineer $61,000 Jacky Chipres 77 F Engineer $52,000 Lora Heredia 26 F Nurse $48,000

orting a table? ctions? Largest), and age (Z to A or Largest to Smallest)

Q7. In the above below, filter all employees who are making less th FIRST NAME LAST NAME AGE GENDER OCCUPATIONINCOME Randy Smith 55 M Professor $90,000 Fay Brown 22 F Engineer $75,000 Adam Mills 37 M Engineer $55,000 Andrea Harris 29 F Teacher $31,000 Moe Santos 44 M Officer $49,000 Bob Sakas 39 M Engineer $72,000 Vicki Hashim 22 F Teacher $34,000 Paula Schlosser 66 F Nurse $56,000 Jack Negrete 51 M Artist $32,000 Mary Fisher 27 F Teacher $33,000 Sue Hayward 26 F Engineer $61,000 Jacky Chipres 77 F Engineer $52,000 Lora Heredia 26 F Nurse $48,000

han $40,000.