Question 1

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

Accepted Answer

Access is a database management system specifically designed for tracking orders, inventory, equipment, and people. Excel is a spreadsheet software that can also be used for tracking, but it may not be as efficient for complex data management and analysis. Access provides better data organization, searching, sorting, and querying features compared to Excel.

Question 2

Which of the following Excel diagrams is the best to compare various growth alternatives of different employees?

Accepted Answer

Column charts are the best option for comparing growth alternatives of different employees because they allow for easy comparison of values and trends across multiple data points. Pie charts would not be effective since they are better suited for displaying parts of a whole rather than multiple variables. Scatter diagrams would not be efficient for comparing growth alternatives as they are more suited for displaying correlations between two variables. Venn diagrams are not appropriate for comparing growth alternatives, as they show overlapping relationships between sets or categories.

Question 3

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

Accepted Answer

In Access, named ranges are created using the Formulas tab and the Defined Names section. Options B, C and D are not valid procedures for creating named ranges.

Question 4

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

Accepted Answer

Microsoft Access is a database management system that allows users to create data entry forms, queries, and reports. Microsoft Publisher is a desktop publishing software, Microsoft Word is a word processing software, and Microsoft Excel is a spreadsheet software, none of which are specifically designed for database management.

Question 5

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

Accepted Answer

Microsoft Excel has more advanced graphing and visualization features compared to Microsoft Access.

Question 6

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

Accepted Answer

Import/export is exactly what it sounds like: the process of transferring data from one computer system to another.

Question 7

________ is superior for tracking orders,inventory,equipment,people,and so forth.

Accepted Answer

Microsoft Access is specifically designed for managing data, tracking inventory and orders, and maintaining a database. It allows users to create forms, queries, and reports that aid in tracking equipment, people, and other important information. While Excel also has certain features that can be used for tracking, Access is the more powerful tool for this type of task. PowerPoint and Publisher are not designed for data management, and therefore are not suitable options.

Question 8

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

Accepted Answer

The correct steps for formatting currency values in Excel involve selecting the "Home" tab, clicking on the "Number" dropdown menu, and then choosing the "Currency" option.

Question 9

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

Accepted Answer

The answer of In Excel and Access,import/export maintains an active...

Question 10

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

Accepted Answer

The answer of Which of the following is true of...

Question 11

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

Accepted Answer

The term commonly used to describe transferring data from one computer system to another is import/export. This involves moving data from one software or application to another, typically using a standardized file format or data exchange protocol. Option A, auto transfer, is not a commonly used term in this context. Option C, data shift, is a vague term that could refer to any number of data management activities. Option D, reallocation, does not accurately describe the process of transferring data between computer systems.

Question 12

Microsoft Access is a database management system.

Accepted Answer

Microsoft Access is a database management system developed by Microsoft.

Question 13

Which of the following shows the correct steps for importing data into Excel from Access?

Accepted Answer

The answer of Which of the following shows the correct...

Question 14

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

Accepted Answer

The "Insert" tab in Microsoft Excel contains options for inserting various objects into a worksheet, including charts. The option to create a column chart can be found in the "Charts" section of the "Insert" tab.

Question 15

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

Accepted Answer

Delimited text files are considered as external data source in Access, and therefore can be imported through the External Data tab.

Question 16

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

Accepted Answer

To create a pie chart in Microsoft Excel, one should first click on the "Insert" tab, then select "Charts" and finally choose "Pie" from the options available.

Question 17

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

Accepted Answer

To create a column chart in Microsoft Excel, the user needs to go to the "Insert" tab, select "Charts" and then choose "Column."

Question 18

Data can be transferred from Excel to Access by creating a(n)________,which is a subset of the cells in a worksheet that has a unique name.

Accepted Answer

A named range is a subset of cells in Excel that has a unique name. By specifying a named range, it is easy to transfer data from Excel to Access because you can use the unique name to select the data in Excel and transfer it to Access. This saves time and reduces the chances of errors.

Question 19

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

Accepted Answer

It is not recommended to rekey all of the Access data into Excel, as this can introduce errors and is time-consuming. Instead, you can use Excel's data import features to bring in the Access data without manual rekeying.

Question 20

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

Accepted Answer

The Totals button is used to add summary calculations to a query result. It is found in the Show/Hide section of the Design tab.

Quiz 18: Using Excel and Access Together