Question 1

In Excel,a single space character is used to separate the words in a name range.

Accepted Answer

A) True 
 B)False

Question 2

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 3

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 4

A data table is a subset of the cells in a worksheet that has a unique name and is used to transfer data from Excel to Access.

Accepted Answer

A) True 
 B)False

Question 5

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

Explain the procedure for creating graphs in Microsoft Excel.

Accepted Answer

The answer of Explain the procedure for creating graphs in...

Question 9

________ is well-suited for tracking orders,inventory,equipment,people,and so forth.

Accepted Answer

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

Question 10

Access queries can be imported into Microsoft Excel.

Accepted Answer

A) True 
 B)False

Question 11

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)  Insert tab → Get External Data → From Access 
B)  Edit tab → Get External Data → From Access 
C)  File tab → Get External Data → From Text 
D)  Data tab → Get External Data → From Text

Question 12

What are delimited text files?

Accepted Answer

The answer of What are delimited text files?...

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

Microsoft Excel includes comprehensive tools for graphing data.

Accepted Answer

A) True 
 B)False

Exam 19: Using Excel and Access Together

In Excel,a single space character is used to separate the words in a name range.

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

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 data table is a subset of the cells in a worksheet that has a unique name and is used to transfer data from Excel to Access.

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

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

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

Explain the procedure for creating graphs in Microsoft Excel.

________ is well-suited for tracking orders,inventory,equipment,people,and so forth.

Access queries can be imported into Microsoft Excel.

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

What are delimited text files?

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

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

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

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

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

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

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

Microsoft Excel includes comprehensive tools for graphing data.