Business Data Management and Tools

What is the first stage of the Supply Chain Management (SCM) process?

Which of the following is NOT a benefit of using Electronic Data Interchange (EDI)?

Which key uniquely identifies each row in a database?

What does CRM stand for?

A Smart Card typically contains an embedded:

What is the full form of DBMS?

Which of the following can you NOT do with a Pivot Table?

Which of the following is NOT a required argument in the VLOOKUP function?

What type of CRM focuses on the management of sales and marketing processes?

Which of the following is a common risk associated with e-banking?

Which of the following best describes a table in a database?

What does the NPV function in Excel represent?

Which of the following is NOT a type of conditional formatting option available in Excel?

Which of the following can be performed through e-banking?

Which of the following statements about primary keys is true?

Pivot Tables

Pivot tables organize and summarize data.
Values area houses numerical data, such as sums or averages.

Supply Chain Management (SCM)

SCM encompasses the planning, execution, and control of all activities of a supply chain.
The first stage of SCM is planning.
Electronic Data Interchange (EDI) benefits include reduced costs, faster response, and shorter cycle times.
EDI eliminates redundancy.

Databases

Database Management System (DBMS) manages databases.
A primary key uniquely identifies each row in a database.
The ECS (Electronic Clearing Services) benefits banks, institutions, and ultimate beneficiaries.

Excel

Excel's Autofill efficiently fills cells with data or patterns.

Smart Cards

Smart cards often contain embedded microprocessors for secure data storage.

Customer Relationship Management (CRM)

CRM aims to improve customer relationships.
Operational CRM focuses on sales and marketing processes.
E-banking offers online fund transfers, bill payments, and loan applications.
Common risks associated with e-banking include identity theft.
Customer segmentation is a common feature of CRM systems.

Other

Tables in databases are organized as rows and columns.
JIT stands for Just In Time.
Conditional Formatting in Excel provides data bars, color scales, and icon sets.
A primary key in a database must have unique, non-repeating values.
The NPV function in Excel calculates the Net Present Value.

This quiz covers essential concepts in business data management tools including Pivot Tables, SCM, Databases, Excel, Smart Cards, and CRM. Explore how these elements streamline processes and enhance decision-making. Test your knowledge on the functionalities and benefits of these tools in a business context.