WorksheetsComputer Fundamentals Quiz
Total questions: 20
Worksheet time: 10mins
What is the main function of a CPU in a computer?
To water plants and feed pets
To execute instructions and perform calculations
To play music and watch movies
To brew coffee and make toast
Name three common network topologies.
Bus, Star, Ring
Hybrid
Tree
Mesh
How can you change the font style in MS Word?
Go to Insert tab -> Font settings -> Modify font style
Right-click text -> Change font style
Access Format menu -> Adjust font style
Select text -> Home tab -> Font group -> Choose font style
What is the purpose of using formulas in MS Excel?
To create animations, design graphics, and write code
To perform calculations, manipulate data, and automate tasks.
What is a primary key in a database table in MS Access?
A primary key in a database table in MS Access uniquely identifies each record in the table.
A primary key in a database table in MS Access can be duplicated across multiple records.
A primary key in a database table in MS Access is optional and not necessary for data integrity.
A primary key in a database table in MS Access is used for sorting records alphabetically.
Explain the concept of recursion in algorithm design.
Recursion in algorithm design involves a function calling itself to solve a problem by breaking it down into smaller subproblems.
Recursion is a linear process in algorithm design
Recursion involves using loops to solve problems
Recursion always leads to infinite loops
Give an example of system software.
Google Chrome browser
Adobe Photoshop
Microsoft Office Suite
Operating systems like Windows, macOS, and Linux
List three hardware components of a computer.
1. Central Processing Unit (CPU), 2. Random Access Memory (RAM), 3. Hard Disk Drive (HDD)
Motherboard
Solid State Drive (SSD)
Graphics Processing Unit (GPU)
What is the difference between LAN and WAN?
LAN and WAN are the same thing
LAN is used for wireless connections, while WAN is used for wired connections
LAN is more secure than WAN
LAN is limited to a small geographic area, while WAN covers a large geographic area.
How can you insert a table in MS Word?
Go to Review tab -> Table -> Select number of rows and columns
Go to Insert tab -> Table -> Select number of rows and columns
Go to Home tab -> Table -> Select number of rows and columns
Go to Layout tab -> Table -> Select number of rows and columns
What is the function of the SUM function in MS Excel?
Multiplies a range of numbers
Divides a range of numbers
Subtracts a range of numbers
Adds up a range of numbers
How can you create a query in MS Access?
Open the database, go to 'Create' tab, select 'Query Design', add tables, drag fields, set criteria, and run the query.
Access does not support creating queries
Open the database, go to 'Analyze' tab, select 'Query Wizard', and follow the steps
Click on 'Format' tab and select 'Query Builder'
What is the importance of flowcharts in problem-solving?
Flowcharts help in organizing thoughts, identifying key steps, and improving overall problem-solving efficiency.
Flowcharts are only used for artistic purposes
Flowcharts are only relevant for computer programming
Flowcharts make problem-solving more complicated
Define the term 'software'.
A type of hardware used in computers
A type of musical instrument
A set of instructions that tell a computer how to perform specific tasks or functions.
A type of food consumed by programmers
Explain the role of RAM in a computer system.
RAM is used to permanently store data in a computer system.
RAM is responsible for processing graphics in a computer system.
RAM in a computer system is used to temporarily store data that the CPU needs to access quickly.
RAM is only used when the computer is turned off.
What is a star network topology?
A star network topology is a type of network where each device is connected directly to a central hub.
A star network topology is a type of network where each device is connected in a mesh-like structure.
A star network topology is a type of network where each device is connected in a circular manner.
A star network topology is a type of network where each device is connected in a linear chain.
How can you format text in MS Word?
Use the 'Paint' application instead
Write the text in a separate document and paste it into MS Word
Use voice commands to format the text
Use the toolbar options like bold, italic, underline, font size, font color, alignment, etc.
What is conditional formatting in MS Excel?
Conditional formatting in MS Excel is a feature that allows users to insert images into cells based on certain conditions.
Conditional formatting in MS Excel is a feature that allows users to send emails directly from the spreadsheet based on certain conditions.
Conditional formatting in MS Excel is a feature that allows users to apply formatting to cells based on certain conditions or criteria.
Conditional formatting in MS Excel is a feature that allows users to create pivot tables based on certain conditions.
What is a relational database in MS Access?
A relational database in MS Access is a database that stores data in a single table
A relational database in MS Access is a database that organizes data into tables with relationships between them.
A relational database in MS Access is a database that does not support relationships between tables
A relational database in MS Access is a database that only allows data to be stored in text format
Describe the process of binary search in algorithm design.
The process of binary search involves selecting the middle element of the array and comparing it to the target value. If the middle element is equal to the target, the search is successful. If the middle element is greater than the target, the search continues on the left subarray. If the middle element is less than the target, the search continues on the right subarray. This process repeats until the target value is found or the interval is empty.
Binary search involves selecting the first element of the array and comparing it to the target value.
In binary search, the search continues on the left subarray if the middle element is less than the target.
The process of binary search always starts from the end of the array.
