Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Data can be exchanged between Microsoft Excel and Microsoft Access by exporting the data into a text file and then importing that text data.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A)  Data can only be transferred by exporting the data into a text file and then importing that text data. 
B)  Delimited text files cannot be imported into both Microsoft Excel and Microsoft Access. 
C)  The import/export process in both Microsoft Access to Microsoft Excel maintains an active connection to the source of the data. 
D)  Data must be reimported to Microsoft Excel in order to remain up-to-date if the source data in Microsoft Access is modified. 
A)  Data can only be transferred by exporting the data into a text file and then importing that text data. 
B)  Delimited text files cannot be imported into both Microsoft Excel and Microsoft Access. 
C)  The import/export process in both Microsoft Access to Microsoft Excel maintains an active connection to the source of the data. 
D)  Data must be reimported to Microsoft Excel in order to remain up-to-date if the source data in Microsoft Access is modified.

Question 4

Roy is in charge of logistics at a courier company. He inputs data into the company's database and imports it from there onto an Excel sheet whenever required. Given that he transfers the data using text files, which of the following sequence of steps is he most likely to follow to import the data?

Accepted Answer

A)  Insert tab → Get External Data → From Access 
B)  Edit tab → Get External Data → From Access 
C)  File tab → Get External Data → From Text 
D)  Data tab → Get External Data → From Text 
A)  Insert tab → Get External Data → From Access 
B)  Edit tab → Get External Data → From Access 
C)  File tab → Get External Data → From Text 
D)  Data tab → Get External Data → From Text

Question 5

You can do all of the following in the total row EXCEPT ________.

Accepted Answer

A)  Import/Export 
B)  Average values 
C)  Count data values 
D)  Print data 
A)  Import/Export 
B)  Average values 
C)  Count data values 
D)  Print data

Question 6

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.

Accepted Answer

A) True 
 B)False

Question 7

Peter requires data from the company's database to create a report on the attrition rate for the year. He transfers the required numbers from the database onto an Excel sheet where he can tabulate them. This process is an example of ________.

Accepted Answer

A)  auto transfer 
B)  import/export 
C)  buffer overrun 
D)  reallocation 
A)  auto transfer 
B)  import/export 
C)  buffer overrun 
D)  reallocation

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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?

Accepted Answer

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

Question 10

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?

Accepted Answer

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

Question 11

Debbie works for an automobile manufacturing plant. Her job profile comprises tracking orders, inventory, and equipment. Which of the following is best suited to assist Debbie with her duties?

Accepted Answer

A)  Microsoft Access 
B)  Microsoft Word 
C)  Microsoft PowerPoint 
D)  Microsoft Publisher 
A)  Microsoft Access 
B)  Microsoft Word 
C)  Microsoft PowerPoint 
D)  Microsoft Publisher

Question 12

A ________, which is a subset of the cells in a worksheet that has a unique name, enables data to be transferred from Microsoft Excel to Microsoft Access.

Accepted Answer

A)  specified label 
B)  consolidation table 
C)  named range 
D)  calculated column 
A)  specified label 
B)  consolidation table 
C)  named range 
D)  calculated column

Question 13

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

A) True 
 B)False

Question 14

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.

Accepted Answer

A) True 
 B)False

Question 15

Microsoft Excel is superior to Microsoft Access for tracking orders, inventory, equipment, and people.

Accepted Answer

A) True 
 B)False

Exam 19: Using Excel and Access Together

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

Data can be exchanged between Microsoft Excel and Microsoft Access by exporting the data into a text file and then importing that text data.

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

Roy is in charge of logistics at a courier company. He inputs data into the company's database and imports it from there onto an Excel sheet whenever required. Given that he transfers the data using text files, which of the following sequence of steps is he most likely to follow to import the data?

You can do all of the following in the total row EXCEPT ________.

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.

Peter requires data from the company's database to create a report on the attrition rate for the year. He transfers the required numbers from the database onto an Excel sheet where he can tabulate them. This process is an example of ________.

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

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?

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?

Debbie works for an automobile manufacturing plant. Her job profile comprises tracking orders, inventory, and equipment. Which of the following is best suited to assist Debbie with her duties?

A ________, which is a subset of the cells in a worksheet that has a unique name, enables data to be transferred from Microsoft Excel to Microsoft Access.

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.

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.

Microsoft Excel is superior to Microsoft Access for tracking orders, inventory, equipment, and people.

The Importance of Mis

Business Processes, Information Systems, and Information

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Processes, Organizations, and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

Collaboration Information Systems for Decision Making, Problem Solving, and Project Management

Collaborative Information Systems for Student Projects

Mobile Systems

Introduction to Microsoft Excel 2016

Database Design

Using Microsoft Access 2016

Network and Cloud Technology

Enterprise Resource Planning Erp Systems

Supply Chain Management

Enterprise Social Networks and Knowledge Management

Database Marketing

Reporting Systems and Olap

Artificial Intelligence and Automation

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters