An organization stores the details of its employees using Microsoft Access. The Employee table has EmployeeName, EmployeeID, Department, and Salary columns. Which of the following 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.
C
You might also like to view...
A segment must pass all of the tests in order for it to be considered a reportable segment. These tests include the revenue, profit, and asset tests
Indicate whether the statement is true or false
Reba Company received $60,000 in cash and used equipment with a fair value of $160,000 from Fargo Corporation in exchange for Reba's existing equipment, which had a fair value of $210,000 and an undepreciated cost of $170,000 recorded on its books. The transaction was undertaken because Reba was revising its market strategy and planned to reduce the use of this type of equipment in its
production. How much gain should Reba recognize on this exchange and at what value should the acquired equipment be recorded, respectively? A) Gain - $10,000 and Equipment - $150,000 B) Gain - $10,000 and Equipment - $160,000 C) Gain - $40,000 and Equipment - $150,000 D) Gain - $40,000 and Equipment - $160,000
Stock X has a beta of 0.7 and Stock Y has a beta of 1.7. Which of the following statements must be true, according to the CAPM?
A. Stock Y's realized return during the coming year will be higher than Stock X's return. B. If the expected rate of inflation increases but the market risk premium is unchanged, the required returns on the two stocks should increase by the same amount. C. Stock Y's return has a higher standard deviation than Stock X. D. If the market risk premium declines, but the risk-free rate is unchanged, Stock X will have a larger decline in its required return than will Stock Y. E. If you invest $50,000 in Stock X and $50,000 in Stock Y, your 2-stock portfolio would have a beta significantly lower than 1.0, provided the returns on the two stocks are not perfectly correlated.
As worldwide Internet use expands exponentially, public relations professionals can rest easy, as they are already technology experts
Indicate whether the statement is true or false