Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

Which of the following shows the correct sequence of steps for importing Access data that has been stored in a text file into Excel?

Accepted Answer

A) Data tab → Get External Data → From Text 
B) File tab → Get External Data → From Text 
C) Insert tab → Get External Data → From Access 
D) Edit tab → Get External Data → From Access 
A) Data tab → Get External Data → From Text 
B) File tab → Get External Data → From Text 
C) Insert tab → Get External Data → From Access 
D) Edit tab → Get External Data → From Access A

Question 4

Microsoft Excel includes comprehensive tools for graphing data.

Accepted Answer

A) True 
 B)False

Question 5

To import data into Excel,open Excel,click the Data tab,and in the Get External Data section of that ribbon click From Text.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) The import/export process maintains an active connection to the source of the data. 
B) If data in Access is changed,the data must be re-imported into Excel to be up-to-date. 
C) Data can only be transferred by exporting the data into a text file and then importing that text data. 
D) Delimited text files cannot be imported into both Excel and Access. 
A) The import/export process maintains an active connection to the source of the data. 
B) If data in Access is changed,the data must be re-imported into Excel to be up-to-date. 
C) Data can only be transferred by exporting the data into a text file and then importing that text data. 
D) Delimited text files cannot be imported into both Excel and Access.

Question 7

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) Insert → Illustrations → Column 
C) Add-Ins → Charts → Column 
D) Insert → Charts → Column 
A) Diagrams → Illustrations → Column 
B) Insert → Illustrations → Column 
C) Add-Ins → Charts → Column 
D) Insert → Charts → Column

Question 8

Access queries can be imported into Microsoft Excel.

Accepted Answer

A) True 
 B)False

Question 9

Importing data from Access to 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 10

A user can produce two different reports from a single set of Excel data,by importing this data into Access and using the Access report generator.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) Excel can be used to create better data entry forms,queries,and professional reports. 
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 is superior for tracking orders,inventory,and equipment. 
A) Excel can be used to create better data entry forms,queries,and professional reports. 
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 is superior for tracking orders,inventory,and equipment.

Question 12

Which of the following Excel diagrams is the best to compare performance data over many years of different employees?

Accepted Answer

A) doughnut charts 
B) pie charts 
C) column charts 
D) Venn diagrams 
A) doughnut charts 
B) pie charts 
C) column charts 
D) Venn diagrams

Question 13

Which of the following statements is true of queries?

Accepted Answer

A) When the results of a query are imported by Excel,they cannot be operated on. 
B) To inform Access that the fields of two tables are the same,select the Group By option for both fields. 
C) In Access,a query can be based on the results of other queries that have been saved. 
D) The Group By option becomes available when Append is clicked under the Design tab. 
A) When the results of a query are imported by Excel,they cannot be operated on. 
B) To inform Access that the fields of two tables are the same,select the Group By option for both fields. 
C) In Access,a query can be based on the results of other queries that have been saved. 
D) The Group By option becomes available when Append is clicked under the Design tab.

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) auto transfer 
B) buffer overrun 
C) reallocation 
D) import/export 
A) auto transfer 
B) buffer overrun 
C) reallocation 
D) import/export

Question 16

Explain the significance of using Access and Excel together.

Accepted Answer

Excel is good at processing interrelated

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

How can Excel be used to graph Access data?

Accepted Answer

Access data,including queries,can be imp

Question 19

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

Question 20

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

Exam 19: Using Excel and Access Together

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

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 importing Access data that has been stored in a text file into Excel?

Microsoft Excel includes comprehensive tools for graphing data.

To import data into Excel,open Excel,click the Data tab,and in the Get External Data section of that ribbon click From Text.

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

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

Access queries can be imported into Microsoft Excel.

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

A user can produce two different reports from a single set of Excel data,by importing this data into Access and using the Access report generator.

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

Which of the following Excel diagrams is the best to compare performance data over many years of different employees?

Which of the following statements is true of queries?

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

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

Explain the significance of using Access and Excel together.

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

How can Excel be used to graph Access data?

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

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

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