An organization stores the details of its employees using ...

[littleanan]

An organization stores the details of its employees using Microsoft Access. The Employeetable has EmployeeName, EmployeeID, Department, and Salary columns. Which of thefollowing statements is true?
 
  A) To view the average salary drawn by the employees of each department, the Group By option
  should be selected in the Total row under Salary.
  B) To count the number of employees in each department, the Group By option should be
  selected under EmployeeID, and the Count option under Department.
  C) To find the sum of salaries drawn by the employees of each department, the Group By option
  should be selected under Department and Sum under Salary.
  D) To count the number of employees having the same salary, the Group By option should be
  selected under EmployeeID, and Count under Salary.

Question 2

A market-basket analysis is used to explore cross-selling opportunities.
 
  Indicate whether the statement is true or false

[TINA]

Answer to Question 1

C

Answer to Question 2

TRUE

[littleanan]

TYSM

[lindahyatt42]

Thanks for the timely response, appreciate it