Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Question 3

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

Question 4

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 5

Which of the following Excel diagrams is the best to compare various growth alternatives of different employees?

Accepted Answer

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

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 9

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 10

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

Question 11

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 12

How can you use Excel to graph Access data?

Accepted Answer

The answer of How can you use Excel to graph...

Question 13

Microsoft Access is a database management system.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Question 16

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

Accepted Answer

A) Results 
B) Show/Hide 
C) Query Type 
D) Query Setup

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Microsoft Excel includes comprehensive tools for graphing data.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

Which of the following shows the correct 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

Exam 18: Using Excel and Access Together

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

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

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

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

Which of the following Excel diagrams is the best to compare various growth alternatives of different employees?

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

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

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.

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

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

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

How can you use Excel to graph Access data?

Microsoft Access is a database management system.

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

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.

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

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

Microsoft Excel includes comprehensive tools for graphing data.

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

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