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.