32) Explain the procedure for creating graphs in Microsoft Excel. 33) In Microsoft Access, the Totals button is present in the ________ section of the Design tab. A) Import/Export B) Show/Hide ...





32) Explain the procedure for creating graphs in Microsoft Excel.



33) In Microsoft Access, the Totals button is present in the ________ section of the Design tab.



A) Import/Export



B) Show/Hide



C) Query Type



D) Query Setup



34) 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.







May 15, 2022
SOLUTION.PDF

Get Answer To This Question

Submit New Assignment

Copy and Paste Your Assignment Here