rt operations? How many keys (columns or elds) can be used when sorting a table? What are two business applications of database statistical functions?...

1. What are two business applications of the sort operations?
2. How many keys (columns or elds) can be used when sorting a table?
3. What are two business applications of database statistical functions?
4. What are some business applications of the Pivot table?
5. Construct the table below and sort it by gender (Z to A), income (A to Z), and age (Z to A).

9. In the above table (#5) using Conditional Formatting, highlight all the employees with incomes less

than $50,000.

10. In the above table (#5) using database statistical functions, count all the female engineers, calculate their average salary, and list the oldest and the youngest in four separate rows of the worksheet.

11. Go through the Pivot Table presented in Exhibit C.19 step-by-step and con rm the screens and the num- bers that have been generated. What are some other business applications of the Pivot Table?

12. To nalize the Frequency function you must press and hold down Ctrl, Shift, and Enter simultaneously. True or False?

13. In database statistical functions, Field indicates which row is selected in the function that you are using. True or False?

14. All of the following are examples of valid Excel database statistical functions except:

a. =DTOTAL b. =DCOUNT c. =DMAX

d. =DSUM

15. A table can be sorted by: a. One column

b. Two columns

c. As many columns as available in the table d. All of the above

FIRST LAST NAME NAME

Randy Smith Fay Brown Adam Mills Andrea Harris Moe Santos Bob Sakas Vicki Hashim Paula Schlosser Jack Negrete Mary Fisher Sue Hayward Jacky Chipres Lora Heredia

AGE GENDER OCCUPATION INCOME

6. In the above table (#5),

lter all female engineers.

7. In the above table (#5), making less than $40,000.

20 Appendix C

55 M 22 F 37 M 29 F 44 M 39 M 22 F 66 F 51 M 27 F 26 F 77 F 26 F

Professor Engineer Engineer Teacher Of cer Engineer Teacher Nurse Artist Teacher Engineer Engineer Nurse

$90,000 $75,000 $55,000 $31,000 $49,000 $72,000 $34,000 $56,000 $32,000 $33,000 $61,000 $52,000 $48,000

lter all employees who are

8. In the above table (#5) (using Advanced Filter), lter all employees who are male, under the age of 50, and have an income over $45,000.