Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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.

Accepted Answer

A) True 
 B)False

Question 3

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.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

Microsoft Excel is good at processing in

Question 5

Which of the following statements is true of delimited files?

Accepted Answer

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. 
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 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

A) Diagrams → Illustrations → Column 
B) Add-Ins → Charts → Column 
C) Insert → Illustrations → Column 
D) Insert → Charts → Column 
A) Diagrams → Illustrations → Column 
B) Add-Ins → Charts → Column 
C) Insert → Illustrations → Column 
D) Insert → Charts → Column

Question 8

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?

Accepted Answer

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. 
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 9

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

Accepted Answer

A) True 
 B)False

Question 10

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.

Accepted Answer

A) True 
 B)False

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

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.

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.

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

Which of the following statements is true of delimited files?

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

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

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?

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

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.

The Importance of MIS

Business Processes, information Systems, and Information

Organizational Strategy, information Systems, and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Organizations and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

Collaboration Information Systems for Decision Making problem Solving and Project Management

Collaborative 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

Enterprise Social Networks and Knowledge Management

Database Marketing

Reporting Systems and OLAP

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters

Exam 19: Using Excel and Access Together

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

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.

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.

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

Which of the following statements is true of delimited files?

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

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

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?

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

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.

The Importance of MIS

Business Processes, information Systems, and Information

Organizational Strategy, information Systems, and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Organizations and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Security

Information Systems Management

Information Systems Development

Collaboration Information Systems for Decision Making problem Solving and Project Management

Collaborative 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

Enterprise Social Networks and Knowledge Management

Database Marketing

Reporting Systems and OLAP

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters