Deck 19: Using Excel and Access Together

Question 1

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.

Answer 1

C

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

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

Answer 3

A

Question 4

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 5

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

Question 6

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

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

Question 7

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 8

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 9

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 10

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

Question 11

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 12

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 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

Microsoft Access is a database management system.

Question 18

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

Question 19

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

Question 20

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

Question 21

How are group totals created in Microsoft Access?

Question 22

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

Question 23

Explain the procedure for creating graphs in Microsoft Excel.

Question 24

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 25

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

Question 26

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

Question 27

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

Question 28

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 29

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 30

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 31

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 32

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

Question 33

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

Question 34

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 35

What are delimited text files?

Question 36

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 37

Microsoft Excel includes comprehensive tools for graphing data.

Question 38

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 39

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 40

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 41

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 42

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 43

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 44

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

Question 45

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 46

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

Question 47

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 48

Microsoft Access queries can be imported into Microsoft Excel.

Question 49

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

Question 50

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.