NEW
Font size
WorksheetsEksamens
Total questions: 75
Worksheet time: 38mins
Which Excel function is used to calculate the present value of an investment?
PV
FV
PMT
NPV
What is the default alignment for text in an Excel cell?
Center
Right
Left
Justified
What does the HLOOKUP function do?
Looks for a value in a vertical table
Looks for a value in a horizontal table
Calculates the sum of horizontal cells
Links worksheets together
What is the result of =MID("Information", 3, 4)?
for
orm
orma
Info
How do you lock a cell reference in a formula?
Use a pound sign (#)
Use a dollar sign ($)
Use an asterisk (*)
Use an exclamation mark (!)
Which Excel feature is used to create patterns automatically in a column?
Flash Fill
AutoSum
Fill Handle
Format Painter
What does the TRIM function do?
Removes all spaces from text
Removes leading and trailing spaces from text
Removes specific characters from text
Converts text to uppercase
Which argument is optional in the VLOOKUP function?
Lookup value
Table array
Col index num
Range lookup
How do you represent a dynamic named range in Excel?
Using cell addresses directly
Using a table
Using absolute references
Using the OFFSET and COUNTA functions
What is the shortcut for displaying formulas in Excel?
Ctrl + D
Ctrl + `
Alt + F
Shift + F9
What is the primary purpose of a database management system (DBMS)?
To design software applications
To store, retrieve, and manage data efficiently
To connect multiple computers
To create network systems
What is data redundancy?
Repetition of the same data in multiple places
Compression of data
Deletion of old data
Automatic data synchronization
What is the primary benefit of a relational database model?
Storing large files
Efficient querying and relationships between data
Data encryption
Network management
What does the term “data independence” mean?
Users can directly modify the database structure
Database structure changes do not affect applications
The database is stored across multiple systems
Data is stored in isolated systems
Which of the following is a database integrity rule?
Redundant data
Data must follow defined constraints
Unlimited data duplication
Lack of access control
What is a primary key in a database table?
A key that encrypts data
A unique identifier for table rows
A foreign key reference
A duplicate record key
What does normalization in databases aim to achieve?
Compress data
Minimize redundancy and dependency
Increase redundancy for reliability
Decrease security
What is a foreign key used for?
To identify records uniquely in a table
To enforce a link between two tables
To encrypt sensitive data
To backup database files
What is a transaction in DBMS?
A backup operation
A sequence of operations treated as a single unit
A user login attempt
A database export
What is the purpose of an Entity-Relationship Diagram (ERD)?
To store database records
To represent data relationships graphically
To manage user permissions
To execute SQL queries
What does the term “information systems governance” refer to?
Managing hardware configurations
Developing standalone software
Optimizing server performance
Frameworks to manage and align IS with organizational goals
What is the "iron triangle" in project management?
Scope, cost, and time
Resources, quality, and stakeholders
Risks, quality, and performance
Schedule, resources, and risks
Which of the following is a feature of ERP systems?
Integration of business processes
Decentralized data storage
Limited to HR functions
Exclusive use for small businesses
What is a functional silo in an organization?
A shared resource for all departments
A software repository
An isolated department or function
A network of functions
What is the primary advantage of cloud computing?
Reduces dependency on the internet
Allows access to resources without significant local infrastructure
Requires minimal training for users
Enhances hardware performance
Which term refers to the alignment of IS with an organization’s strategic goals?
Urbanization
Integration
Optimization
Strategic alignment
What is hyper-mobility in information systems?
The rapid scaling of IT resources
Centralized resource management
High-speed network connectivity
IS access from anywhere, anytime, on any device
What is augmented reality in IS?
Displaying real-time computer-generated enhancements on reality
Managing multiple cloud servers
Creating VR environments
Using IS for static data analysis
What is the purpose of process modeling in IS?
To develop new software
To map and optimize business processes
To train employees
To define network architecture
What is an example of IS governance using HR systems?
Payroll management
Marketing campaign analysis
Supplier database integration
Network optimization
Which is an example of SaaS in cloud computing?
Dropbox
Cisco routers
Microsoft SQL Server
Intel processors
What is a “transaction cost” in IS management?
The cost of executing a database query
Costs associated with maintaining and switching systems
Resource acquisition costs
IT hardware replacement costs
What does COBIT stand for?
Corporate Operations for Business IT
Corporate Business IT Toolkit
Central Optimization for Business IT Techniques
Control Objectives for Information and Related Technologies
What is the goal of information system urbanization?
To centralize decision-making
To migrate data to the cloud
To map IS processes and maintain coherence
To manage financial costs
What does an Executive Information System (EIS) do?
Manages transaction-level data
Provides strategic-level information for decision-makers
Operates as a CRM tool
Tracks employee performance
What is the function of CRM software?
Manage customer relationships and interactions
Track company inventory
Optimize production schedules
Perform HR appraisals
What is an MIS?
Modular Integration Software
Management Information System
Multi-Integrated Solution
Master Inventory System
What is the purpose of an ERP system?
To track hardware failures
To encrypt customer data
To isolate data in silos
To integrate core business functions into one system
What does “strategic agility” refer to in IS?
Rapid adaptation of IS to changes in business strategy
Optimizing software licensing costs
Reducing server downtime
Automating repetitive tasks
What is the purpose of process re-engineering in IS?
To develop new cloud applications
To align business processes with IS
To centralize all operations in one system
To eliminate physical hardware usage
What is the purpose of a use case list?
To identify and list the functional requirements that must be provided by the new system.
To identify and list the functional and non-functional requirements that must be provided by the new system.
To identify and list the non-functional requirements that must be provided by the new system.
To identify and list the FURPS (Functionality, Usability, Reliability, Performance, and Supportability) that must be provided by the new system.
What is the purpose of the activity diagram? What are the symbols associated with the UML diagram?
To define the detailed processing steps of a use case. Symbols: Lane, oval activity, transition arrow, synchronization bar, decision activity.
To define the detailed processing steps of a use case. Symbols: Lane, oval activity, transition arrow, synchronization bar.
To define the detailed processing steps of a user story. Symbols: Lane, oval activity, synchronization bar, decision activity.
To define the detailed processing steps for all use cases obtained through the user goal method. Symbols: Oval activity, transition arrow, synchronization bar, decision activity.
How do you distinguish classes and attributes?
Classes are objects/things in the system in preparation for the construction of the database. Attributes are the characteristics of the classes.
Classes and attributes define the use cases of the system in preparation for the construction of the database. Attributes are always common to all classes.
Classes define system activities in preparation for the construction of the database. Attributes are exception conditions of the flowcharts.
Classes define user stories of the system in preparation for the construction of the database. Attributes are the objectives of the user story.
What is the purpose of sequence diagrams (SSD)?
The purpose of the SSD is to document the real input data and the output data that flow between each of the actors and the information system.
The purpose of the SSD is to document the real input data and the output data that flow between all actors and the information system.
The purpose of the SSD is the same as a flowchart.
The purpose of the SSD is to create links between the classes of the system.
What are the three objectives of data integrity control? Define referential integrity violation.
Ensure correct data types, correct business transactions, register and process these transactions correctly, protect all organizational assets. A referential integrity violation occurs when the foreign key does not match a primary key in its "parent" table.
Ensure that the user only enters correct data. A referential integrity violation occurs when the foreign key does not match a primary key in its "parent" table.
Ensure that data can only be changed by authorized users. A referential integrity violation occurs when the foreign key does not match a primary key in its "parent" table.
Ensure commercial transactions are correct, register and process these transactions correctly, and verify the validity of the data. A referential integrity violation occurs when the foreign key does not match a primary key in its "parent" table.
Sequence diagrams (SSD) are among the most difficult UML models to learn. What is their purpose?
a) The purpose of SSD is to document the real input data and the output data that flow between each of the actors and the information system.
b) The purpose of SSD is to document the real input data and the output data that flow between all actors and the information system.
c) The purpose of SSD is the same as a flowchart.
d) The purpose of SSD is to create links between the classes of the system.
What are the three objectives of data integrity control? Define referential integrity violation.
Ensure correct data types, correct business transactions, register and process these transactions correctly, and protect all organizational assets. A referential integrity violation occurs when the foreign key does not match a primary key in its "parent" table.
Ensure that the user only inputs correct data. A referential integrity violation occurs when the foreign key does not match a primary key in its "parent" table.
Ensure that data cannot be altered by all users. A referential integrity violation occurs when the foreign key does not match a primary key in its "parent" table.
Ensure commercial transactions are correct, register and process these transactions correctly, and protect organizational data. A referential integrity violation occurs when the foreign key does not match a primary key in its "parent" table.
What does SAAS mean? What are the characteristics of SAAS?
Software as a Service | Software as a service. The information system software resides on the organization's computers. The data can reside both on the organization's computers and on the providers' servers.
Software as a Service | Software as a service. The information system software resides on the provider's computers. The data reside on the organization's computers, but the software resides on the provider's servers.
Software as a Service | Software as a service. The operational system and information system reside on the organization's computers.
Software as a Service | Software as a service. The user pays a fee every time they use the information system.
What does the XLOOKUP function do?
Searches for a value in a row or column and returns the corresponding value
Finds the maximum value in a dataset
Performs calculations on multiple ranges
Links multiple worksheets together
What is the purpose of range names in Excel?
To create pivot tables
To make formulas easier to read and maintain
To apply conditional formatting
To automate chart creation
Which text function combines data from multiple cells into one?
CONCATENATE
TRIM
SUBSTITUTE
FIND
Which argument is mandatory in the PMT function?
Rate
Future Value
Type
Number of periods
What does =IF(A1>10, "Yes", "No") do?
Checks if A1 is greater than 10 and returns "Yes" or "No"
Multiplies A1 by 10
Adds 10 to A1
Always returns "No"
Which financial function calculates the internal rate of return for a cash flow?
PV
IRR
NPV
FV
What does the LEN function calculate?
The length of a range
The number of characters in a text string
The number of columns in a range
The largest number in a range
What is the purpose of normalization?
To add redundancy
To minimize data redundancy and dependency
To increase database size
To improve data encryption
What does referential integrity ensure in a database?
Data consistency between related tables
Data encryption
Faster query execution
Data deletion
Which SQL command is used to retrieve data?
SELECT
INSERT
UPDATE
DELETE
What is metadata in a database?
Temporary data
Encrypted data
Raw data records
Data about other data
What does ERP stand for?
Enterprise Resource Planning
Extended Resource Program
Effective Resource Processing
Efficient Resource Protocol
Which component is NOT part of the FURPS model?
Functionality
Usability
Scalability
Performance
What is the key difference between predictive and adaptive project planning?
Predictive focuses on fixed plans, while adaptive emphasizes flexibility
Predictive is used only for software projects
Adaptive requires more resources
Predictive is faster to implement
What is the main feature of Agile development?
Emphasizes collaboration and iterative progress
Focuses on fixed plans
Avoids client feedback
Uses traditional methodologies exclusively
What is the purpose of a UML activity diagram?
To analyze network performance
To design software GUIs
To map database schemas
To model the flow of processes and actions
Which formula is used to calculate total hours worked in a worksheet?
=AVERAGE(C4:C11)
=FORMULATEXT(C4:C11)
=SUM(C4:C11)
=IF(C4>C11, TRUE, FALSE)
What is the purpose of the FORMULATEXT function in Excel?
To calculate average values in a range
To find maximum values in a range
To display the formula in a cell as text
To sort values alphabetically
What does the formula =AVERAGE(USSales) indicate?
A formula with an unnamed range
A formula to count rows in the range
A formula using a named range
A formula for conditional formatting
Which shortcut is used to open the Paste Name dialog box in Excel?
Ctrl+F
Alt+N
F3
Ctrl+N
Which of the following is a primary disadvantage of the file-processing system?
Centralized data management
Enforcing data redundancy
Simplified query handling
Program-data independence
Which concept refers to managing resources across multiple projects to meet strategic goals?
Project
Program
Task group
Portfolio
What does the VLOOKUP function primarily do in Excel?
Returns the smallest value in a range
Searches horizontally for a value in a range
Looks up values vertically in the first column of a range
Sorts values in ascending order
Which type of organizational structure minimizes divisions between functions and levels?
Process-driven
Hierarchical-functional
U-form
Multi-divisional
What happens if you copy a formula using the fill handle in Excel?
It duplicates the formula exactly
It creates a new sheet for the copied formulas
It adjusts the cell references relative to the position
It converts the formulas to plain text
What is data abstraction in DBMS?
Visualizing data in a table
Hiding physical storage details from users
Manipulating data using SQL queries
Creating new relationships between tables
What does the column_index argument specify in a VLOOKUP formula?
The range of data to search
The column number containing the return value
The number of rows in the range
The type of lookup (exact or approximate)
