Question 1

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

Import/export is the process of transfer

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

Microsoft Access data, including queries

Question 4

Microsoft Excel includes comprehensive tools for graphing data.

Accepted Answer

A) True 
 B)False

Question 5

Explain the procedure for creating graphs in Microsoft Excel.

Accepted Answer

Microsoft Excel includes comprehensive t

Question 6

Microsoft Excel cannot be used to perform calculations on data imported from Microsoft Access.

Accepted Answer

A) True 
 B)False

Question 7

How are group totals created in Microsoft Access?

Accepted Answer

Open the relevant database, click the Cr

Question 8

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 9

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 10

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 11

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?

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Microsoft Access queries can be imported into Microsoft Excel.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following procedures must be used to create a named range for data in Microsoft 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

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

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 20

Which of the following shows the correct sequence of steps for formatting 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

Exam 19: Using Excel and Access Together

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?

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

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

Microsoft Excel includes comprehensive tools for graphing data.

Explain the procedure for creating graphs in Microsoft Excel.

Microsoft Excel cannot be used to perform calculations on data imported from Microsoft Access.

How are group totals created in Microsoft Access?

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

Which of the following statements is TRUE of queries?

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

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

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

Microsoft Access queries can be imported into Microsoft Excel.

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

Which of the following statements is TRUE of delimited files?

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

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

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

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

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