Question 1

A pie chart can be created by selecting the Charts option from the Data tab in Microsoft Excel.

Accepted Answer

A pie chart in Microsoft Excel is typically created by selecting the desired data and then choosing the pie chart option from the Insert tab, not the Data tab.

Question 2

A school stores attendance records of its students in a Microsoft 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.

Accepted Answer

To find the number of days each student is absent, we need to Group By for StudentID and use Count for DateAbsent. This will give us the total number of absences for each student. Grouping by Grade and using Avg for StudentID would give us the average number of absences for each grade, which is not what is being asked for. Grouping by StudentName would not give us the desired result, as it would only show us which students were absent on a particular day, but not the total number of absences for each student. Grouping by both DateAbsent and StudentID would also not give us the desired result, as it would only show us the number of students absent on a particular day, but not the total number of absences for each student.

Question 3

Microsoft Excel includes comprehensive tools for graphing data.

Accepted Answer

Microsoft Excel offers a range of chart and graph types to help you visually represent your data. It includes comprehensive tools for formatting and customizing charts and graphs to suit your needs.

Question 4

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

Accepted Answer

The Totals button is present in the Show/Hide section of the Design tab in Microsoft Access. Clicking on this button allows you to add aggregate functions like Sum, Count, Avg, etc. to your query results.

Question 5

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.

Accepted Answer

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. This will group the data by department and show the total salary for each department. Option A is incorrect because selecting the Group By option under Salary will not give the average salary by department. Option B is incorrect because selecting the Count option under Department will only count the number of times each department appears, not the number of employees in each department. Option D is incorrect because selecting the Group By option under EmployeeID and Count under Salary will only count the number of employees with a specific salary.

Question 6

If a user clicks on a graph in Microsoft Excel, it will show a special tab called Chart Tools that can be used to customize the graph.

Accepted Answer

When a user clicks on a graph in Microsoft Excel, the special tab called Chart Tools will appear, providing customization options for the graph.

Question 7

To create a column chart, the data is highlighted and the Column option in the Charts section of the Insert tab is selected.

Accepted Answer

This is correct, to create a column chart in Microsoft Excel, the data must be highlighted and the Column option in the Charts section of the Insert tab must be selected.

Question 8

How can Microsoft Excel be used to graph Microsoft Access data?

Accepted Answer

The answer of How can Microsoft Excel be used to...

Question 9

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

Accepted Answer

To create a column chart in Microsoft Excel, one needs to first click on the "Insert" tab, then click on "Charts" and select "Column" from the options.

Question 10

Which of the following statements is TRUE of queries?
A) In Microsoft Access, a query can be based on the results of other queries that have been saved.
B) To inform Microsoft 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 Microsoft Excel, they cannot be operated on.

Accepted Answer

In Microsoft Access, a query can be based on the results of other queries that have been saved. Option B is incorrect because selecting the Group By option for both fields wouldn't inform Access that the fields of two tables are the same. Option C is also incorrect because the Group By option is not connected to Append. Option D is incorrect because the results of a query can be operated on in Excel.

Question 11

What are delimited text files?

Accepted Answer

The answer of What are delimited text files?...

Question 12

A pie chart can be used to compare results of various data for two years or more.

Accepted Answer

A pie chart is best suited for showing the proportions of a whole at one point in time, not for comparing changes over multiple years.

Question 13

Explain the procedure for creating graphs in Microsoft Excel.

Accepted Answer

The answer of Explain the procedure for creating graphs in...

Question 14

The Totals button is present in the Results section of the Design tab.

Accepted Answer

The Totals button is actually found in the Table Tools Design tab, specifically within the Table Style Options group, not in the Results section.

Question 15

Which of the following tabs in Microsoft Excel contains the option to create a column chart?
A) Data
B) Home
C) Insert
D) Tools

Accepted Answer

The Insert tab contains the option to create charts, including a column chart.

Question 16

What is import/export of data? Why is it necessary to refresh the import/export data in Microsoft Excel and Microsoft Access on a timely basis?

Accepted Answer

The answer of What is import/export of data? Why is...

Question 17

The Average function and Group By cannot be used in the same query.

Accepted Answer

The Average function and Group By can be used together in the same query to perform calculations in groupings.

Question 18

Joan works for Human Resources at a content development firm. She recruits candidates from multiple fields of study. As a result, the firm is a pool of talent from different disciplines. To depict this diversity, Joan wants to calculate the percentage of employees in each discipline and represent the number on a pie chart using Excel. Which of the following sequence of steps should Joan follow to create her chart?
A) Add → Charts → Pie
B) Insert → Illustrations → Pie
C) Diagrams → Illustrations → Pie
D) Insert → Charts → Pie

Accepted Answer

The correct sequence of steps to create a pie chart in Excel is to first click on the "Insert" tab, then select "Charts" and choose "Pie Chart." Option D follows this sequence correctly. Option A is incorrect because "Add" is not a tab in Excel. Option B is incorrect because "Illustrations" do not include charts. Option C is incorrect because "Diagrams" is not a tab or option in Excel.

Question 19

Matthew, the head of the sales department, has noticed a significant decline in performance in one of his sales teams over the years. He wants to compare the team's performance data over the last five years to study the exact decline percentage. Which of the following Microsoft Excel diagrams should Matthew use for this purpose?
A) pie charts
B) column charts
C) doughnut charts
D) Venn diagrams

Accepted Answer

Column charts are ideal for comparing data over a period of time, such as the sales team's performance data over the last five years. They allow for easy comparison of values and can show trends and changes in performance. Pie charts and doughnut charts are more appropriate for displaying percentages or proportions of a whole, while Venn diagrams are used for comparing relationships between different sets of data.

Question 20

How are group totals created in Microsoft Access?

Accepted Answer

The answer of How are group totals created in Microsoft...

Quiz 19: Using Excel and Access Together

A pie chart can be created by selecting the Charts option from the Data tab in Microsoft Excel.

A school stores attendance records of its students in a Microsoft 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?

Microsoft Excel includes comprehensive tools for graphing data.

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

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?