Exam 19: Using Excel and Access Together

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?

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

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?

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

To import data into Microsoft Excel, open Excel, click the Data tab, and in the Get External Data section of that ribbon, click From Text.

Explain the procedure for creating graphs in Microsoft Excel.

To use Microsoft Excel to process data stored in Microsoft Access, it is recommended to rekey all of the Access data into Excel.

Microsoft Access queries can be imported into Microsoft Excel.

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?

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?

If users change the Microsoft Access data, the imported data in Microsoft Excel will be out-of-date until it is reimported.

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

Which of the following is true about the import/export of data from Microsoft Access to Microsoft Excel?

A data table is a subset of the cells in a worksheet that has a unique name and is used to transfer data from Microsoft Excel to Microsoft Access.

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

Sum and average functions cannot be used in Microsoft Excel on imported data that have been created using group totals in Microsoft Access.

Explain the significance of using Microsoft Access and Microsoft Excel together.

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

A user can produce two different reports from a single set of Microsoft Excel data, by importing this data into Microsoft Access and using the Access report generator.

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