Question 1

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

Accepted Answer

To format currency values in Microsoft Excel, you need to go to the Home tab, then click on the Number formatting drop-down and select Currency. This will format the selected cell(s) as currency with the default currency symbol ($). If you want to change the currency symbol, you can do so by clicking on the "More Number Formats" option at the bottom of the drop-down and selecting a different currency symbol.

Question 2

Which of the following statements is true of delimited files?

Accepted Answer

Field values in a tab-delimited file are separated by tabs. Delimited files can be imported by both Access and Excel, and a comma-delimited file has data that is separated by commas, not containing them.

Question 3

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

Accepted Answer

The correct sequence of steps for creating a column chart in Microsoft Excel is through the Insert tab, then click on Charts, and choose Column.

Question 4

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

Accepted Answer

The Totals button is present in the Show/Hide section of the Design tab in Microsoft Access. This button allows you to add total calculations, such as sum or average, to fields in a query.

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?

Accepted Answer

To find the sum of salaries drawn by the employees of each department, we need to group the data by department and sum the salaries. Therefore, the correct option is 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. Option A is incorrect because we need to group by department, not by salary. Option B is incorrect because we need to count the number of employees per department, not per EmployeeID. Option D is incorrect because we don't need to count the number of employees who have the same 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?

Accepted Answer

The correct sequence of steps for importing Access data that has been stored in a text file into Excel is to go to the Data tab, select Get External Data, and choose From Text. This option will allow you to select the file containing the Access data and import it into Excel. Option A is incorrect because it directs you to import data directly from Access instead of a text file. Option B is incorrect because there is no Get External Data option under the Edit tab. Option C is incorrect because it directs you to import data from a text file, but not specifically a text file that contains Access data.

Question 7

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

Accepted Answer

Column charts are the best choice for comparing performance data over many years of different employees as they allow for easy comparison of data for each employee year over year. Pie charts and doughnut charts are better suited for displaying data as a percentage of a whole, while Venn diagrams are used for displaying relationships between different sets of data.

Question 8

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

Accepted Answer

The option to import delimited text files is located under the "External Data" tab in Microsoft Access.

Question 9

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

Accepted Answer

The "Insert" tab contains options for inserting various elements into the Excel worksheet, including charts. To create a column chart, one would click on the "Column" option under the "Charts" section of the "Insert" tab.

Question 10

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

Accepted Answer

The correct sequence of steps for creating a pie chart in Microsoft Excel is to first click on the Insert tab, then select Charts, and finally select the type of chart you want (in this case, Pie). Option D is the only one that follows this sequence.

Question 11

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

Accepted Answer

The process of transferring data from one computer system to another is commonly referred to as import/export. Auto transfer and reallocation are not commonly used terms in this context, while buffer overrun refers to a type of security vulnerability.

Question 12

Which of the following statements is true of queries?

Accepted Answer

A query in Access can be based on the results of other queries that have been saved. This is known as a nested query. Option B is incorrect as selecting the Group By option for both fields does not inform Access that the fields of two tables are the same. Option C is also incorrect as the Group By option is used to group data in a query by one or more fields, and is not related to the Append function. Option D is incorrect as the results of a query can be imported by Excel and can be further operated on using Excel's tools.

Question 13

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 forms, queries, and reports for data entry and analysis. Microsoft Publisher is a desktop publishing program used for creating publications such as brochures and newsletters, Microsoft Word is a word processing software for creating and editing documents, and Microsoft Excel is a spreadsheet software for organizing and analyzing data. While all of these programs have their uses, Microsoft Access is specifically designed for creating and managing databases, making it the best choice for creating data entry forms, queries, and reports.

Question 14

Microsoft Access is a database management system.

Accepted Answer

Microsoft Access is a widely used database management system that allows users to store, organize, and retrieve data in various formats.

Question 15

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

Accepted Answer

When data in Access is changed, it does not automatically update in Excel. The data must be re-imported to reflect any changes.

Question 16

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

Accepted Answer

To create a named range for data in Excel, we need to highlight the required data, click the Formulas tab, click Define Name in the Defined Names section, and enter a suitable name. This procedure allows us to create a named range which we can later use to refer to the data in calculations and formulas. Option B, C, and D are not the correct procedures for creating a named range.

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?

Accepted Answer

To find the number of days each student is absent, we need to group by StudentID and count the number of entries in the DateAbsent column. Grouping by Grade or StudentName would not provide this information.

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.

Accepted Answer

A named range in Excel is a subset of the cells in a worksheet that has a unique name. This named range can then be used to transfer data from Excel to Access by linking the Excel worksheet to an Access database. Once the named range is created, it can be selected as a data source when setting up a linked table in Access. Therefore, option C is the best choice for this question.

Question 19

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

Accepted Answer

While Excel and Access can both be used for various data management tasks, Excel's strength lies in its ability to create visually appealing graphs and charts. Access, on the other hand, excels (no pun intended) in creating forms, queries, and reports.

Question 20

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

Accepted Answer

Microsoft Access is a database management system that is specifically designed for tracking orders, inventory, equipment, people, and other data. It allows for easy data entry, filtering, and reporting, making it an efficient tool for keeping track of various types of information. Microsoft Word, PowerPoint, and Publisher are not database management systems and are not well-suited for these types of functions.

Quiz 19: Using Excel and Access Together