cs Ans.pdf

Q1 ) FILL IN THE BLANKS 1.What type of data is placed in the "Va lues" area of a Pivot Table? a) Labels or text categories b) External links or URLs c) Dates and times d) Numeric data (e.g., sum) 2.SCM stands for _ _ _ _ _ __ a) Supply chain management b) Service chain management c...

Q1 ) FILL IN THE BLANKS 1.What type of data is placed in the "Va lues" area of a Pivot Table? a) Labels or text categories b) External links or URLs c) Dates and times d) Numeric data (e.g., sum) 2.SCM stands for _ _ _ _ _ __ a) Supply chain management b) Service chain management c) Supply control management d) Supplier chain management 3.What is the first stage of SCM process? a) Plan b) Deliver c) Return d) Develop 4.Which of the following is NOT a benefit of using EDI? a) Low cost b) Reduced cycle time c) Faster Response d) Redundancy 5.What is the full form of DBMS? a) Database management system b) Database managerial system c) Digital management system d) Data backup management system 6.Smart card usually contains an embedded _ _ _ _ _ __ a) SIM b) IC c) Microprocessor d) Microcontroller 7.What is the full form of CRM? a) Customer relationship management b) Customer related management c) Consumer resource management d) Client relationship management 8.ln a database, which of the following key uniquely identifies each row? a) Primary Key b) Foreign Key c) Secondary Key d) Candidate Key 9.ECS has provided benefits to the banks, User Institutions and a) Government b) School c) Ultimate Beneficiaries d) Colleges 1o. _ _ _ _ _ _ _ _ feature of Excel fills cell data or series of data in a worksheet into a selected range of cells. a) Data b) Autofill c) Quick Access d) Cut and Paste 11.SCM stands for _ _ _ _ __ a) Supply chain management b)Supply customer management c) Service chain management d) Supplier customer management 12.A debit card is issued with a _ _ _ _ for a security reasons a) One Time Password b) Personal identification number c) Character password d) Mobile Number 13. _ _ _ is the benefit of EDI a)Reduced cost b)Reduced cycle time c)Faster Response d) All of these 14. ____ is the first stage of SCM a) Plan b)Develop c) Deliver d) Return 15.DBMS stands for _ _ _ _ __ a) Database Management System b) Database Managerial System c)Database Manipulation System d)Data backup Management System 16.CRM stands for _ _ _ __ a)Customer Relationship Management b) Client Relationship Management c)Customer Resource Management d) Consumer Retention Management 17.EDI stands for _ _ _ _ __ a) Electronic Data Interchange b) Electronic Data Interface c) Electronic Data Integrated d) Electronic Digital Interface 18.Which of the following can you NOT do with a Pivot Table? a) Summarize data b) Automatically update data c) Filter data d) Create relationships between multiple tables 19.Which of the following is NOT a required argument in the VLOOKUP function? a) Lookup value b) Table array c) Column index number d) Row number 20._ _ _ _ _ _ is the collection of interrelated data and a set of programs to access those data a)Table b)Worksheet c) DBMS d)None of these 21.What type of CRM focuses on the management of sales and marketing processes? A) Operational CRM B) Analytical CRM C) Collaborative CRM D) Strategic CRM 22.Which of the following is a common feature of e-banking? A) In-person transactions only B) Online fund transfers C) Paper statements only D) Limited access to account information 23.What is a common risk associated withe-banking? A) Improved customer service B) lden_tity theft C) Increased transaction speed D) Decreased operational costs 24.What is a common feature of most CRM systems? A) Inventory management B) Customer segmentation C) Employee performance reviews D) Payroll processing 25.Which of the followi ng best describes a table in a database? A) A collection of rows and columns C) A method of accessing data B) A graphical representation of data D) A temporary storage area 26.Full form of JIT: A) Just In Time B) Job In Training C) Just In Technology D) Just In Trend 27.Which of the following can be performed th rough e-banking? A) Money transfers between accounts B) Loan applications C) Bill payments D) All of the above 28.Which of the following is NOT a type of conditional formatting option available in Excel? A) Data Bars B) Color Scales C) Icon Sets D) Cell Protection 29.Which of the following statements about primary keys is true? A) It can contain duplicate values. B) It can contain null values. C) It must contain unique values. D) It can be any field in a table. 30.What does the NPV function in Excel represent? A) Net Profit Value B) Net Present Value C) Nomin al Present Value D) Net Payment Value