Question 1

To import data into Microsoft 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 2

A ________,which is a subset of the cells in a worksheet that has a unique name,enables data to be transferred from Microsoft Excel to Microsoft Access.

Accepted Answer

A) specified label 
B) consolidation table 
C) named range 
D) calculated column 
A) specified label 
B) consolidation table 
C) named range 
D) calculated column

Question 3

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 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Microsoft Access queries can be imported into Microsoft Excel.

Accepted Answer

A) True 
 B)False

Question 10

A school stores attendance records of its students in a Microsoft Access database.The Attendance table has StudentName,StudentID,Grade,and DateAbsent columns.Each time a student is absent,an entry is made into the database.Which of the following statements is true?

Accepted Answer

A) To find the average number of days students of each grade are absent,Group By should be selected under Grade and Avg under StudentID. 
B) To find the number of days each student is absent,Group By should be selected for StudentID,and Count for DateAbsent. 
C) To see which students were absent on a particular day,Group By should be selected for StudentName. 
D) To see the number of students absent in a particular grade on a given day,Group By should be selected for both DateAbsent and StudentID. 
A) To find the average number of days students of each grade are absent,Group By should be selected under Grade and Avg under StudentID. 
B) To find the number of days each student is absent,Group By should be selected for StudentID,and Count for DateAbsent. 
C) To see which students were absent on a particular day,Group By should be selected for StudentName. 
D) To see the number of students absent in a particular grade on a given day,Group By should be selected for both DateAbsent and StudentID.

Question 11

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 12

If a user clicks on a graph in Microsoft Excel,it will show a special tab called Chart Tools that can be used to customize the graph.

Accepted Answer

A) True 
 B)False

Question 13

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 14

How can Microsoft Excel be used to graph Microsoft Access data?

Accepted Answer

Microsoft Access data,including queries,

Question 15

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

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 16

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 17

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

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 18

In Microsoft Access,the Totals button is present in the ________ section of the Design tab.

Accepted Answer

A) Import/Export 
B) Show/Hide 
C) Query Type 
D) Query Setup 
A) Import/Export 
B) Show/Hide 
C) Query Type 
D) Query Setup

Question 19

Import/export is the process of transferring data from one computer system to another.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 19: Using Excel and Access Together

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

A ________,which is a subset of the cells in a worksheet that has a unique name,enables data to be transferred from Microsoft Excel to Microsoft Access.

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

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

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

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

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

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

Microsoft Access queries can be imported into Microsoft Excel.

A school stores attendance records of its students in a Microsoft Access database.The Attendance table has StudentName,StudentID,Grade,and DateAbsent columns.Each time a student is absent,an entry is made into the database.Which of the following statements is true?

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

If a user clicks on a graph in Microsoft Excel,it will show a special tab called Chart Tools that can be used to customize the graph.

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

How can Microsoft Excel be used to graph Microsoft Access data?

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

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

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

In Microsoft Access,the Totals button is present in the ________ section of the Design tab.

Import/export is the process of transferring data from one computer system to another.

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

The Importance of MIS

Business Processes, information Systems, and Information

Organizational Strategy, information Systems, and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

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 2013

Database Design

Using Microsoft Access 2013

Network and Cloud Technology

Enterprise Resource Planning ERP Systems

Supply Chain Management

Enterprise Social Networks and Knowledge Management

Database Marketing

Reporting Systems and OLAP

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters