Question 1

What is import/export of data? Why is it necessary to refresh the import/export data in Microsoft Excel and Microsoft Access on a timely basis?

Accepted Answer

The answer of What is import/export of data? Why is...

Question 2

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 3

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

Accepted Answer

The answer of How can Microsoft Excel be used to...

Question 4

Microsoft Excel includes comprehensive tools for graphing data.

Accepted Answer

A) True 
 B)False

Question 5

Explain the procedure for creating graphs in Microsoft Excel.

Accepted Answer

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

How are group totals created in Microsoft Access?

Accepted Answer

The answer of How are group totals created in Microsoft...

Question 8

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

Question 9

Which of the following statements is TRUE of queries?

Accepted Answer

A)  In Microsoft Access, a query can be based on the results of other queries that have been saved. 
B)  To inform Microsoft Access that the fields of two tables are the same, select the Group By option for both fields. 
C)  The Group By option becomes available when Append is clicked under the Design tab. 
D)  When the results of a query are imported by Microsoft Excel, they cannot be operated on.

Question 10

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 11

Joan works for Human Resources at a content development firm. She recruits candidates from multiple fields of study. As a result, the firm is a pool of talent from different disciplines. To depict this diversity, Joan wants to calculate the percentage of employees in each discipline and represent the number on a pie chart using Excel. Which of the following sequence of steps should Joan follow to create her chart?

Accepted Answer

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

Question 12

If users change the Microsoft Access data, the imported data in Microsoft Excel will be out-of-date until it is reimported.

Accepted Answer

A) True 
 B)False

Question 13

The Average function and Group By cannot be used in the same query.

Accepted Answer

A) True 
 B)False

Question 14

Microsoft Access queries can be imported into Microsoft Excel.

Accepted Answer

A) True 
 B)False

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

Question 16

Which of the following statements is TRUE of delimited files?

Accepted Answer

A)  Microsoft Access can import only tab-delimited files. 
B)  Delimited files cannot be imported by Microsoft Excel. 
C)  A comma-delimited file has data that contains commas. 
D)  Field values in a tab-delimited file are separated by tabs.

Question 17

To create a column chart, the data is highlighted and the Column option in the Charts section of the Insert tab is selected.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Question 20

Which of the following shows the correct sequence of steps for formatting currency values in Microsoft Excel?

Accepted Answer

A)  Home → Number → Currency 
B)  Data → Number → Currency 
C)  Home → Editing → Currency 
D)  Data → Editing → Currency

Exam 19: Using Excel and Access Together

What is import/export of data? Why is it necessary to refresh the import/export data in Microsoft Excel and Microsoft Access on a timely basis?

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

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

Microsoft Excel includes comprehensive tools for graphing data.

Explain the procedure for creating graphs in Microsoft Excel.

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

How are group totals created in Microsoft Access?

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

Which of the following statements is TRUE of queries?

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

If users change the Microsoft Access data, the imported data in Microsoft Excel will be out-of-date until it is reimported.

The Average function and Group By cannot be used in the same query.

Microsoft Access queries can be imported into Microsoft Excel.

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

Which of the following statements is TRUE of delimited files?

To create a column chart, the data is highlighted and the Column option in the Charts section of the Insert tab is selected.

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

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

Which of the following shows the correct sequence of steps for formatting currency values in Microsoft Excel?