Deck 19: Using Excel and Access Together

Question 1

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

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

Answer 1

A

Question 2

Which of the following statements is true of delimited files?

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

Answer 2

D

Question 3

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

A) Diagrams → Illustrations → Column
B) Add-Ins → Charts → Column
C) Insert → Illustrations → Column
D) Insert → Charts → Column

Answer 3

D

Question 4

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

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

Question 5

An organization stores the details of its employees using Access: The Employee table has EmployeeName,EmployeeID,Department,and Salary columns: Which of the following statements is true?

A) To view the average salary drawn by the employees of each department, the Group By option should be selected in the Total row under Salary.
B) To count the number of employees in each department, the Group By option should be selected under EmployeeID and the Count option under Department.
C) To find the sum of salaries drawn by the employees of each department, the Group By option should be selected under Department and Sum under Salary.
D) To count the number of employees having the same salary, the Group By option should be selected under EmployeeID and Count under Salary.

Question 6

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

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 7

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

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

Question 8

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

A) HOME
B) CREATE
C) DATABASE TOOLS
D) EXTERNAL DATA

Question 9

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

A) Data
B) Home
C) Insert
D) Tools

Question 10

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

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

Question 11

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

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

Question 12

Which of the following statements is true of queries?

A) In Access, a query can be based on the results of other queries that have been saved.
B) To inform 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 Excel, they cannot be operated on.

Question 13

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

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

Question 14

Microsoft Access is a database management system.

Question 15

Which of the following is true of import/export of data from Access to Excel?

A) Data can only be transferred by exporting the data into a text file and then importing that text data.
B) Delimited text files cannot be imported into both Excel and Access.
C) The import/export process maintains an active connection to the source of the data.
D) If data in Access is changed, the data must be re-imported into Excel to be up-to-date.

Question 16

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

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 17

A school stores attendance records of its students on an 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?

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 18

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.

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

Question 19

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

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 20

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

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

Question 21

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

Question 22

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

Question 23

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

Question 24

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

Question 25

In Excel and Access,import/export maintains an active connection to the source of the data.

Question 26

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

Question 27

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

Question 28

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

Question 29

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

Question 30

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

Question 31

Access queries can be imported into Microsoft Excel.

Question 32

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.

Question 33

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

Question 34

A pie chart can be used to compare results of various data for two years or more.

Question 35

Microsoft Excel includes comprehensive tools for graphing data.

Question 36

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

Question 37

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

Question 38

If a column heading and the corresponding numerical data are highlighted and used to create a pie chart,the heading will appear as the chart title.

Question 39

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

Question 40

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

Question 41

Explain the procedure for creating graphs in Microsoft Excel.

Question 42

Sum and average functions cannot be used in Excel on imported data that have been created using group totals in Access.

Question 43

How can Excel be used to graph Access data?

Question 44

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

Question 45

Explain the significance of using Access and Excel together.

Question 46

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.

Question 47

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

Question 48

How are group totals created in Access?

Question 49

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

Question 50

What are delimited text files?