Question 1

Explain the procedure for creating graphs in Microsoft Excel.

Accepted Answer

Microsoft Excel includes comprehensive t

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

How are group totals created in Access?

Accepted Answer

Open the relevant database,click the CRE

Question 8

An organisation 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

A) To count the number of employees having the same salary,the Group By option should be selected under EmployeeID and Count under Salary. 
B) 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. 
C) To count the number of employees in each department,the Group By option should be selected under EmployeeID and the Count option under Department. 
D) 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. 
A) To count the number of employees having the same salary,the Group By option should be selected under EmployeeID and Count under Salary. 
B) 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. 
C) To count the number of employees in each department,the Group By option should be selected under EmployeeID and the Count option under Department. 
D) 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.

Question 9

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.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

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

Question 14

Which of the following statements is true of delimited files?

Accepted Answer

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

Question 15

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

A) To find the number of days each student is absent,Group By should be selected for StudentID and Count for DateAbsent. 
B) To find the average number of days students of each grade are absent,Group By should be selected under Grade and Avg under StudentID. 
C) 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. 
D) To see which students were absent on a particular day,Group By should be selected for StudentName. 
A) To find the number of days each student is absent,Group By should be selected for StudentID and Count for DateAbsent. 
B) To find the average number of days students of each grade are absent,Group By should be selected under Grade and Avg under StudentID. 
C) 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. 
D) To see which students were absent on a particular day,Group By should be selected for StudentName.

Question 16

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

Accepted Answer

Import/export is the process of transfer

Question 17

Microsoft Access is a database management system.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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) specified label 
B) consolidation table 
C) named range 
D) calculated column 
A) specified label 
B) consolidation table 
C) named range 
D) calculated column

Question 20

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

Accepted Answer

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

Exam 19: Using Excel and Access Together

Explain the procedure for creating graphs in Microsoft Excel.

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

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

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

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

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

How are group totals created in Access?

An organisation 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?

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.

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

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.

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

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

Which of the following statements is true of delimited files?

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?

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

Microsoft Access is a database management system.

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

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.

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

The Importance of Mis

Business Processes, Information Systems and Information

Organisational Strategy, Information Systems and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Organisations and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Development

Information Systems Management

Information Security Management

Collaboration Information Systems for Decision Making, Problem Solving and Project Management

Collaboration Information Systems for Student Projects

Mobile Systems

Introduction to Microsoft Excel 2013

Database Design

Using Microsoft Access 2013

Network and Cloud Technology

Enterprise Resource Planning Erp Systems

Supply Chain Management

Hyper-Social Organisations and Knowledge Management

Database Marketing

Reporting Systems and Olap

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters