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

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

Accepted Answer

A) Diagrams → Illustrations → Column 
B) Add-Ins → Charts → Column 
C) Insert → Illustrations → Column 
D) Insert → Charts → Column 
A) Diagrams → Illustrations → Column 
B) Add-Ins → Charts → Column 
C) Insert → Illustrations → Column 
D) Insert → Charts → Column

Question 3

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 4

In Microsoft Excel, a single space is used to separate the words in range names.

Accepted Answer

A) True 
 B)False

Question 5

In Microsoft Excel and Microsoft Access, import/export maintains an active connection to the source of the data.

Accepted Answer

A) True 
 B)False

Question 6

Microsoft Excel cannot be used to perform calculations on data imported from 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

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 9

To exchange data between Microsoft Excel and Microsoft Access, the data must be imported into a text file and then exported.

Accepted Answer

A) True 
 B)False

Question 10

Microsoft Access is a database management system.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Which of the following statements is true of queries?

Accepted Answer

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

Question 13

Delimited text files can be imported to Microsoft Access by selecting the ________ tab.

Accepted Answer

A) Home 
B) Create 
C) Database Tools 
D) External Data 
A) Home 
B) Create 
C) Database Tools 
D) External Data

Question 14

Microsoft Excel includes comprehensive tools for graphing data.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is an advantage of Microsoft Excel over Microsoft Access?

Accepted Answer

A) Microsoft Excel is superior for tracking orders, inventory, and equipment. 
B) Microsoft Excel is superior for tracking people, such as employees and customers. 
C) Microsoft Excel is superb at processing interrelated formulas and creating stylish graphics. 
D) Microsoft Excel is better at creating data entry forms, queries, and professional reports. 
A) Microsoft Excel is superior for tracking orders, inventory, and equipment. 
B) Microsoft Excel is superior for tracking people, such as employees and customers. 
C) Microsoft Excel is superb at processing interrelated formulas and creating stylish graphics. 
D) Microsoft Excel is better at creating data entry forms, queries, and professional reports.

Question 16

Which of the following statements is true of delimited files?

Accepted Answer

A) Microsoft Access can import only tab-delimited files. 
B) Delimited files cannot be imported by Microsoft Excel. 
C) A comma-delimited file has data that contains commas. 
D) Field values in a tab-delimited file are separated by tabs. 
A) Microsoft Access can import only tab-delimited files. 
B) Delimited files cannot be imported by Microsoft Excel. 
C) A comma-delimited file has data that contains commas. 
D) Field values in a tab-delimited file are separated by tabs.

Question 17

Import/export is the process of transferring data from one computer system to another.

Accepted Answer

A) True 
 B)False

Question 18

Delimited text files cannot be imported into either Microsoft Excel or Microsoft Access.

Accepted Answer

A) True 
 B)False

Question 19

Importing data from Microsoft Access to Microsoft Excel is easily achieved by clicking the Data tab and directing Excel to get the external data from Access.

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 19: Using Excel and Access Together

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

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

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.

In Microsoft Excel, a single space is used to separate the words in range names.

In Microsoft Excel and Microsoft Access, import/export maintains an active connection to the source of the data.

Microsoft Excel cannot be used to perform calculations on data imported from 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 ________.

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?

To exchange data between Microsoft Excel and Microsoft Access, the data must be imported into a text file and then exported.

Microsoft Access is a database management system.

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

Which of the following statements is true of queries?

Delimited text files can be imported to Microsoft Access by selecting the ________ tab.

Microsoft Excel includes comprehensive tools for graphing data.

Which of the following is an advantage of Microsoft Excel over Microsoft Access?

Which of the following statements is true of delimited files?

Import/export is the process of transferring data from one computer system to another.

Delimited text files cannot be imported into either Microsoft Excel or Microsoft Access.

Importing data from Microsoft Access to Microsoft Excel is easily achieved by clicking the Data tab and directing Excel to get the external data from Access.

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

The Importance of Mis

Business Processes, Information Systems, and Information

Organizational Strategy, Information Systems

Hardware and Software

Database Processing

The Cloud

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

Collaborative Information Systems for Student Projects

Mobile Systems

Introduction to Microsoft Excel 2013

Database Design

Using Microsoft Access 2013

Network and Cloud Technology

Enterprise Resource Planning Erpsystems

Supply Chain Management

Enterprise Social Networks and Knowledge Management

Database Marketing

Reporting Systems and Olap

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters