Question 1

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

Accepted Answer

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

Question 2

Which of the following statements is true of queries?

Accepted Answer

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

Question 3

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?

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

Question 4

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

Accepted Answer

A)  Import/Export 
B)  Show/Hide 
C)  Query Type 
D)  Query Setup 
A)  Import/Export 
B)  Show/Hide 
C)  Query Type 
D)  Query Setup

Question 5

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

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Which of the following is true of import/export of data from Access to 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 Excel and Access. 
C)  The import/export process maintains an active connection to the source of the data. 
D)  If data in Access is changed, the data must be re-imported into Excel to be up-to-date. 
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 Excel and Access. 
C)  The import/export process maintains an active connection to the source of the data. 
D)  If data in Access is changed, the data must be re-imported into Excel to be up-to-date.

Question 8

Microsoft Access is a database management system.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A)  Home → Number → Currency 
B)  Data → Number → Currency 
C)  Home → Editing → Currency 
D)  Data → Editing → Currency 
A)  Home → Number → Currency 
B)  Data → Number → Currency 
C)  Home → Editing → Currency 
D)  Data → Editing → Currency

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A)  Data 
B)  Home 
C)  Insert 
D)  Tools 
A)  Data 
B)  Home 
C)  Insert 
D)  Tools

Question 15

The process of transferring data from one computer system to another is referred to as ________.

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 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Explain the significance of using Access and Excel together.

Accepted Answer

Excel is good at processing interrelated

Question 19

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

Accepted Answer

A)  Add → Charts → Pie 
B)  Insert → Illustrations → Pie 
C)  Diagrams → Illustrations → Pie 
D)  Insert → Charts → Pie 
A)  Add → Charts → Pie 
B)  Insert → Illustrations → Pie 
C)  Diagrams → Illustrations → Pie 
D)  Insert → Charts → Pie

Question 20

Data can be exchanged between Excel and 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

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

Which of the following statements is true of queries?

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?

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

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

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

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

Microsoft Access is a database management system.

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

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

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

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

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

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

The process of transferring data from one computer system to another is referred to as ________.

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

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

Explain the significance of using Access and Excel together.

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

Data can be exchanged between Excel and 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 and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Organizations and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Development

Information Systems Management

Information Security Management

Collaboration Information Systems for Decision Making problem Solving and Project Management

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 ERP Systems

Supply Chain Management

Hyper-Social Organizations and Knowledge Management

Database Marketing

Reporting Systems and OLAP

Geographic Information Systems GIS

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters