Question 1

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

Accepted Answer

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

Question 2

Which of the following is true for 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)  If data in Access is changed, the data imported to Excel changes automatically. 
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)  If data in Access is changed, the data imported to Excel changes automatically. 
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 3

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 4

Access queries can be imported to Microsoft Excel.

Accepted Answer

A) True 
 B)False

Question 5

Data can be transferred from Excel to Access by creating a(n)________,which is a subset of the cells in a worksheet that has a unique name.

Accepted Answer

A)  specified label 
B)  individual data 
C)  named range 
D)  unique path 
A)  specified label 
B)  individual data 
C)  named range 
D)  unique path

Question 6

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

Accepted Answer

A)  Excel is superior for tracking orders, inventory, and equipments. 
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 equipments. 
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.

Question 7

To use Excel to process data stored in Access,you have to rekey all of the Access data into Excel.

Accepted Answer

A) True 
 B)False

Question 8

In Microsoft Access,the Totals button is present in the ________.

Accepted Answer

A)  Results section of the Design tab 
B)  Show/Hide section of the Design tab 
C)  Query section of the Create tab 
D)  Query Setup section of the Design tab 
A)  Results section of the Design tab 
B)  Show/Hide section of the Design tab 
C)  Query section of the Create tab 
D)  Query Setup section of the Design tab

Question 9

________ is a superior software for tracking orders,inventory,equipment,people,and so forth.

Accepted Answer

A)  Microsoft Access 
B)  Adobe Illustrator 
C)  Microsoft PowerPoint 
D)  Microsoft Publisher 
A)  Microsoft Access 
B)  Adobe Illustrator 
C)  Microsoft PowerPoint 
D)  Microsoft Publisher

Question 10

Microsoft Access can be used to create graphs and illustrations of data patterns.

Accepted Answer

A) True 
 B)False

Question 11

Explain the significance of using Access and Excel together.

Accepted Answer

Excel is good at processing interrelated

Question 12

In delimited text files,the field values are always separated by commas.

Accepted Answer

A) True 
 B)False

Question 13

When the data in a text file contains commas,commas cannot be used to separate field data.In that case,some other character such as a tab is used to delimit the fields.In this case,the commas and tab characters are known as ________.

Accepted Answer

A)  alienators 
B)  identifiers 
C)  attributes 
D)  delimiters 
A)  alienators 
B)  identifiers 
C)  attributes 
D)  delimiters

Question 14

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

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 15

A pie chart cannot be used to represent various growth alternatives of different entities.

Accepted Answer

A) True 
 B)False

Question 16

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 17

Explain the procedure for creating graphs in Microsoft Excel.

Accepted Answer

Microsoft Excel includes comprehensive t

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Access queries cannot be used to calculate averages of table values.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 21: Using Excel and Access Together

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

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

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

Access queries can be imported to Microsoft Excel.

Data can be transferred from Excel to Access by creating a(n)________,which is a subset of the cells in a worksheet that has a unique name.

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

To use Excel to process data stored in Access,you have to rekey all of the Access data into Excel.

In Microsoft Access,the Totals button is present in the ________.

________ is a superior software for tracking orders,inventory,equipment,people,and so forth.

Microsoft Access can be used to create graphs and illustrations of data patterns.

Explain the significance of using Access and Excel together.

In delimited text files,the field values are always separated by commas.

When the data in a text file contains commas,commas cannot be used to separate field data.In that case,some other character such as a tab is used to delimit the fields.In this case,the commas and tab characters are known as ________.

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

A pie chart cannot be used to represent various growth alternatives of different entities.

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.

Explain the procedure for creating graphs in Microsoft Excel.

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

Access queries cannot be used to calculate averages of table values.

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

The Importance of MIS

Business Processes, Information, and Information Systems

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

Database Processing

Data Communications

Business Process Management

E-Commerce, Web 2.0, and Social Networking

Business Intelligence and Information Systems for Decision Making

Information Systems Development

Information Systems Management

Information Security Management

Improving Your Collaboration Skills

Using Collaboration Information Systems

Information Systems and Decision Making

Knowledge Management and Expert Systems

Introduction to Microsoft Excel

Preparing a Computer Budget Using Excel

Database Design

Using Microsoft Access 2010

Remote, Nomadic, and Mobile Systems

Functional Processes, Applications, and Systems

Enterprise Resource Planning (ERP)Systems

Supply Chain Management

Processing Social Capital: Facebook, Twitter, and User-Generated Content (UGC)

Database Marketing

Reporting Systems and OLAP

Geographic Information Systems

Business Process Management

Systems Development Project Management

Outsourcing

International MIS

Filters