Advance itt exam​

1️⃣ Which Excel feature allows you to summarize large data sets and create dynamic reports?
A) Data Validation
B) Pivot Table
C) Conditional Formatting
D) VLOOKUP
Answer: B) Pivot Table

2️⃣ Which of the following is NOT a primary objective of information system controls?
A) Confidentiality
B) Integrity
C) Availability
D) Profitability
Answer: D) Profitability

3️⃣ In ERP systems, the module that handles inventory, order processing, and procurement is known as:
A) HRM
B) SCM
C) CRM
D) FICO
Answer: B) SCM (Supply Chain Management)

4️⃣ What is phishing?
A) Installing security patches
B) Attempt to acquire sensitive info by pretending to be a trustworthy entity
C) Data mining process
D) Encrypting data
Answer: B) Attempt to acquire sensitive info by pretending to be a trustworthy entity

5️⃣ What does SQL stand for?
A) Standard Query Language
B) Structured Query Language
C) Simple Query Language
D) Sequential Query Language
Answer: B) Structured Query Language

6️⃣ Which Excel function is used to find the number of items in a range?
A) SUM
B) COUNT
C) AVERAGE
D) MAX
Answer: B) COUNT

7️⃣ Blockchain technology is primarily used to ensure:
A) Data duplication
B) Data tampering
C) Data integrity and security
D) Higher bandwidth
Answer: C) Data integrity and security

8️⃣ Which control helps prevent unauthorized access to computer systems?
A) Detective control
B) Corrective control
C) Preventive control
D) Compensating control
Answer: C) Preventive control

9️⃣ In an audit of an automated environment, which risk is especially significant?
A) Human error risk
B) Access control risk
C) Materiality risk
D) Independence risk
Answer: B) Access control risk

🔟 Which feature in Excel allows creating macros to automate tasks?
A) Data Analysis Toolpak
B) Developer Tab
C) Goal Seek
D) Solver
Answer: B) Developer Tab

1️⃣1️⃣ Data visualization tools like charts and graphs in Excel help to:
A) Increase file size
B) Hide data
C) Make data more understandable
D) Reduce accuracy
Answer: C) Make data more understandable

1️⃣2️⃣ ERP implementation failure is often due to:
A) High-quality data migration
B) Strong user training
C) Lack of top management support
D) Adequate customization
Answer: C) Lack of top management support

1️⃣3️⃣ The primary purpose of audit trails is to:
A) Speed up processing
B) Track transactions
C) Increase system downtime
D) Reduce memory usage
Answer: B) Track transactions

1️⃣4️⃣ Which of the following is an example of a detective control?
A) Antivirus software
B) Reconciliation of bank statements
C) Biometric access control
D) Encryption software
Answer: B) Reconciliation of bank statements

1️⃣5️⃣ The practice of evaluating large datasets to uncover patterns is known as:
A) Data compression
B) Data warehousing
C) Data mining
D) Data replication
Answer: C) Data mining

1️⃣6️⃣ What is the main risk associated with using spreadsheets for critical calculations?
A) High cost
B) High level of automation
C) Human error and lack of controls
D) Complexity of coding
Answer: C) Human error and lack of controls

1️⃣7️⃣ Which of the following is an example of an emerging technology relevant to audit?
A) Blockchain
B) Dot matrix printers
C) Floppy disks
D) CRT monitors
Answer: A) Blockchain

1️⃣8️⃣ The term “CIA” in information security stands for:
A) Certified Internal Auditor
B) Confidentiality, Integrity, Availability
C) Control, Investigation, Audit
D) Compliance, Inspection, Assurance
Answer: B) Confidentiality, Integrity, Availability

1️⃣9️⃣ What is the function of a firewall in IT security?
A) It acts as a backup device
B) It detects malware
C) It monitors and controls incoming and outgoing network traffic
D) It provides physical security
Answer: C) It monitors and controls incoming and outgoing network traffic

2️⃣0️⃣ Which of these techniques is used to recover data in case of system failure?
A) Encryption
B) Data mirroring
C) Data mining
D) Data masking
Answer: B) Data mirroring