Question 1

If users subsequently 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  True

Question 2

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  True

Question 3

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

Accepted Answer

A) Excel is superior for tracking orders,inventory,and equipment. 
B) Excel is superior for tracking people,such as employees and customers. 
C) Excel can be used to create better graphs and visual demonstrations. 
D) Excel can be used to create better data entry forms and professional reports. 
A) Excel is superior for tracking orders,inventory,and equipment. 
B) Excel is superior for tracking people,such as employees and customers. 
C) Excel can be used to create better graphs and visual demonstrations. 
D) Excel can be used to create better data entry forms and professional reports. C

Question 4

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 5

Which of the following shows the correct 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 6

Explain the significance of using Access and Excel together.

Accepted Answer

Excel is good at processing interrelated

Question 7

What are delimited text files?

Accepted Answer

Delimited text files are files that have

Question 8

The Totals button is present in the Results section of the Design tab.

Accepted Answer

A) True 
 B)False

Question 9

Explain the procedure for creating graphs in Microsoft Excel.

Accepted Answer

Microsoft Excel includes comprehensive t

Question 10

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 11

What is import/export of data? Why is it necessary to refresh the import/export data in Excel and Access on a timely basis?

Accepted Answer

Import/export is the process of transfer

Question 12

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

Accepted Answer

A) True 
 B)False

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

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

Accepted Answer

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

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Access queries can be imported into Microsoft Excel.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following shows the correct steps for importing data into Excel from Access?

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 18

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 19

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

Accepted Answer

A) auto transfer 
B) import/export 
C) data shift 
D) reallocation 
A) auto transfer 
B) import/export 
C) data shift 
D) reallocation

Question 20

In Excel,the underscore character is used to connect the words in a name range.

Accepted Answer

A) True 
 B)False

Exam 18: Using Excel and Access Together

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

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

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

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

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

Explain the significance of using Access and Excel together.

What are delimited text files?

The Totals button is present in the Results section of the Design tab.

Explain the procedure for creating graphs in Microsoft Excel.

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

What is import/export of data? Why is it necessary to refresh the import/export data in Excel and Access on a timely basis?

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

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

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

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

Access queries can be imported into Microsoft Excel.

Which of the following shows the correct steps for importing data into Excel from Access?

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

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

In Excel,the underscore character is used to connect the words in a name range.

The Importance of Mis

Business Processes information Systems and Information

Organizational Strategy information Systems and Competitive Advantage

Hardware and Software

Database Processing

Data Communication and 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

Introduction to Microsoft Excel 2010

Database Design

Using Microsoft Access 2010

Mobile Systems

Functional Applications

Enterprise Resource Planning ERP systems

Supply Chain Management

Hyper-Social Organizations and Knowledge Management

Database Marketing

Reporting Systems and OLAP

Geographic Information Systems

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters