Question 1

In Excel,a single space character is used to separate the words in a name range.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 Data tab → click Connections in the Connections section → enter a suitable name 
B) highlight the required data → click the Design tab → click Property Sheet in the Show/Hide section → enter a suitable name 
C) highlight the required data → click the Formulas tab → click Define Name in the Defined Names section → enter a suitable name 
D) highlight the required data → click the Home tab → click Insert Name in the Cells section → enter a suitable name 
A) highlight the required data → click the Data tab → click Connections in the Connections section → enter a suitable name 
B) highlight the required data → click the Design tab → click Property Sheet in the Show/Hide section → enter a suitable name 
C) highlight the required data → click the Formulas tab → click Define Name in the Defined Names section → enter a suitable name 
D) highlight the required data → click the Home tab → click Insert Name in the Cells section → enter a suitable name

Question 6

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 7

Commas cannot be used to separate field data if the data itself contains commas.

Accepted Answer

A) True 
 B)False

Question 8

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 9

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

Accepted Answer

A) True 
 B)False

Question 10

What are delimited text files?

Accepted Answer

Delimited text files are files that have

In Excel,a single space character is used to separate the words in a name range.

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

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 procedures must be used to create a named range for data in Excel?

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

Commas cannot be used to separate field data if the data itself contains commas.

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

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

What are delimited text files?

The Importance of Mis

Business Processes, Information Systems and Information

Organisational Strategy, Information Systems and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Organisations 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

Collaboration 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 Organisations and Knowledge Management

Database Marketing

Reporting Systems and Olap

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters

Exam 19: Using Excel and Access Together

In Excel,a single space character is used to separate the words in a name range.

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

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 procedures must be used to create a named range for data in Excel?

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

Commas cannot be used to separate field data if the data itself contains commas.

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

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

What are delimited text files?

The Importance of Mis

Business Processes, Information Systems and Information

Organisational Strategy, Information Systems and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Organisations 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

Collaboration 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 Organisations and Knowledge Management

Database Marketing

Reporting Systems and Olap

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters