Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

When a chart is created in Excel, the first cell contains the default title for the chart.

Accepted Answer

A) True 
 B)False  False

Question 3

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

Question 4

A user can readily create data entry forms, queries, and sophisticated and professional reports with the help of ________.

Accepted Answer

A)  Microsoft Publisher 
B)  Microsoft Access 
C)  Microsoft Word 
D)  Microsoft Excel 
A)  Microsoft Publisher 
B)  Microsoft Access 
C)  Microsoft Word 
D)  Microsoft Excel

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

To use Microsoft Excel to process data stored in Microsoft Access, it is recommended to rekey all of the Access data into Excel.

Accepted Answer

A) True 
 B)False

Question 8

In Microsoft Excel, a single space is used to separate the words in range names.

Accepted Answer

A) True 
 B)False

Question 9

Microsoft Access is a database management system.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

What are delimited text files?

Accepted Answer

Delimited text files are files that have

Question 12

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

Accepted Answer

A)  Microsoft Excel is superior for tracking orders, inventory, and equipment. 
B)  Microsoft Excel is superior for tracking people, such as employees and customers. 
C)  Microsoft Excel is superb at processing interrelated formulas and creating stylish graphics. 
D)  Microsoft Excel is better at creating data entry forms, queries, and professional reports. 
A)  Microsoft Excel is superior for tracking orders, inventory, and equipment. 
B)  Microsoft Excel is superior for tracking people, such as employees and customers. 
C)  Microsoft Excel is superb at processing interrelated formulas and creating stylish graphics. 
D)  Microsoft Excel is better at creating data entry forms, queries, and professional reports.

Question 13

Excel can request Access to run queries.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Question 16

Explain the significance of using Microsoft Access and Microsoft Excel together.

Accepted Answer

Microsoft Excel is good at processing in

Question 17

A user can import and export data between Access and Excel.

Accepted Answer

A) True 
 B)False

Question 18

Once data is imported from Access to Excel it automatically stays updated.

Accepted Answer

A) True 
 B)False

Question 19

Matthew, the head of the sales department, has noticed a significant decline in performance in one of his sales teams over the years. He wants to compare the team's performance data over the last five years to study the exact decline percentage. Which of the following Microsoft Excel diagrams should Matthew use for this purpose?

Accepted Answer

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

Question 20

While saving data in text files, commas cannot be used to separate field data if the data itself contains commas.

Accepted Answer

A) True 
 B)False

Exam 19: Using Excel and Access Together

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

When a chart is created in Excel, the first cell contains the default title for the chart.

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

A user can readily create data entry forms, queries, and sophisticated and professional reports with the help of ________.

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

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

To use Microsoft Excel to process data stored in Microsoft Access, it is recommended to rekey all of the Access data into Excel.

In Microsoft Excel, a single space is used to separate the words in range names.

Microsoft Access is a database management system.

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

What are delimited text files?

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

Excel can request Access to run queries.

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

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

Explain the significance of using Microsoft Access and Microsoft Excel together.

A user can import and export data between Access and Excel.

Once data is imported from Access to Excel it automatically stays updated.

While saving data in text files, commas cannot be used to separate field data if the data itself contains commas.

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