Deck 19: Using Excel and Access Together

Question 1

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

Answer 1

False

Question 2

Roy is in charge of logistics at a courier company. He inputs data into the company's database and imports it from there onto an Excel sheet whenever required. Given that he transfers the data using text files, which of the following sequence of steps is he most likely to follow to import the data?

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

Answer 2

D

Question 3

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

Answer 3

False

Question 4

Which of the following statements is TRUE of delimited files?

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 5

While saving data in text files, commas cannot be used to separate field data if the data itself contains commas.

Question 6

Explain the significance of using Microsoft Access and Microsoft Excel together.

Question 7

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

A) Home
B) Create
C) Database Tools
D) External Data

Question 8

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

Question 9

Peter requires data from the company's database to create a report on the attrition rate for the year. He transfers the required numbers from the database onto an Excel sheet where he can tabulate them. This process is an example of ________.

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

Question 10

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

Question 11

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

Question 12

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

A) Microsoft Excel is superior for tracking orders, inventory, and equipment.
B) Microsoft Excel is superior for tracking people, such as employees and customers.
C) Microsoft Excel is superb at processing interrelated formulas and creating stylish graphics.
D) Microsoft Excel is better at creating data entry forms, queries, and professional reports.

Question 13

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

Question 14

Debbie works for an automobile manufacturing plant. Her job profile comprises tracking orders, inventory, and equipment. Which of the following is best suited to assist Debbie with her duties?

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

Question 15

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

Question 16

Which of the following is TRUE about the import/export of data from Microsoft Access to Microsoft 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 Microsoft Excel and Microsoft Access.
C) The import/export process in both Microsoft Access to Microsoft Excel maintains an active connection to the source of the data.
D) Data must be reimported to Microsoft Excel in order to remain up-to-date if the source data in Microsoft Access is modified.

Question 17

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

Question 18

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

Question 19

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 20

Microsoft Access is a database management system.

Question 21

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

Question 22

A school stores attendance records of its students in a Microsoft 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 23

Microsoft Excel includes comprehensive tools for graphing data.

Question 24

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 25

An organization stores the details of its employees using Microsoft 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 26

If a user clicks on a graph in Microsoft Excel, it will show a special tab called Chart Tools that can be used to customize the graph.

Question 27

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

Question 28

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

Question 29

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

Question 30

Which of the following statements is TRUE of queries?

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 31

What are delimited text files?

Question 32

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

Question 33

Explain the procedure for creating graphs in Microsoft Excel.

Question 34

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

Question 35

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 36

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?

Question 37

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

Question 38

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?

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

Question 39

Matthew, the head of the sales department, has noticed a significant decline in performance in one of his sales teams over the years. He wants to compare the team's performance data over the last five years to study the exact decline percentage. Which of the following Microsoft Excel diagrams should Matthew use for this purpose?

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

Question 40

How are group totals created in Microsoft Access?

Question 41

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

Question 42

When a chart is created in Excel, the first cell contains the default title for the chart.

Question 43

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

Question 44

A ________, which is a subset of the cells in a worksheet that has a unique name, enables data to be transferred from Microsoft Excel to Microsoft Access.

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

Question 45

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

Question 46

Microsoft Access queries can be imported into Microsoft Excel.

Question 47

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

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

Question 48

Which of the following procedures must be used to create a named range for data in Microsoft 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 49

Once data is imported from Access to Excel it automatically stays updated.

Question 50

A user can produce two different reports from a single set of Microsoft Excel data, by importing this data into Microsoft Access and using the Access report generator.

Question 51

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

Question 52

You can do all of the following in the total row EXCEPT ________.

A) Import/Export
B) Average values
C) Count data values
D) Print data

Question 53

Excel can request Access to run queries.

Question 54

In Microsoft Excel, a single space is used to separate the words in range names.

Question 55

A user can import and export data between Access and Excel.