11 which of the following tabs in microsoft excel contains the option to create a co 4312774

11 which of the following tabs in microsoft excel contains the option to create a co 4312774

11) Which of the following tabs in Microsoft Excel contains the option to create a column chart?

A) Data

B) Home

C) Insert

D) Tools

12) Which of the following shows the correct sequence of steps for creating a column chart in Microsoft Excel?

A) Diagrams → Illustrations → Column

B) Add-Ins → Charts → Column

C) Insert → Illustrations → Column

D) Insert → Charts → Column

13) 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

14) An organization stores the details of its employees using 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.

15) A school stores attendance records of its students on an Access database. The Attendance table has StudentName, StudentID, Grade, and DateAbsent columns. Each time a student is absent, an entry is made into the database. Which of the following statements is true?

A) To find the average number of days students of each grade are absent, Group By should be selected under Grade and Avg under StudentID.

B) To find the number of days each student is absent, Group By should be selected for StudentID and Count for DateAbsent.

C) To see which students were absent on a particular day, Group By should be selected for StudentName.

D) To see the number of students absent in a particular grade on a given day, Group By should be selected for both DateAbsent and StudentID.

16) Which of the following statements is true of queries?

A) In Access, a query can be based on the results of other queries that have been saved.

B) To inform Access that the fields of two tables are the same, select the Group By option for both fields.

C) The Group By option becomes available when Append is clicked under the Design tab.

D) When the results of a query are imported by Excel, they cannot be operated on.

17) Which of the following shows the correct sequence of steps for formatting the currency values in Microsoft Excel?

A) Home → Number → Currency

B) Data → Number → Currency

C) Home → Editing → Currency

D) Data → Editing → Currency

18) Data can be transferred from Excel to Access by creating a ________, which is a subset of the cells in a worksheet that has a unique name.

A) specified label

B) consolidation table

C) named range

D) calculated column

19) Which of the following procedures must be used to create a named range for data in Excel?

A) highlight the required data → click the Formulas tab → click Define Name in the Defined Names section → enter a suitable name

B) highlight the required data → click the Home tab → click Insert Name in the Cells section → enter a suitable name

C) highlight the required data → click the Data tab → click Connections in the Connections section → enter a suitable name

D) highlight the required data → click the Design tab → click Property Sheet in the Show/Hide section → enter a suitable name

Looking for a similar assignment? Get help from our qualified experts!

Order Now

Related Posts