WorksheetsExploring Computer Systems and Python
Total questions: 20
Worksheet time: 10mins
What is a computer system?
A computer system is solely a collection of software applications.
A computer system is a combination of hardware and software designed to process data.
A computer system is a network of devices that do not process data.
A computer system consists only of physical components without software.
Name two types of algorithms.
Graph algorithms
Sorting algorithms, Search algorithms
Compression algorithms
Encryption algorithms
What is the purpose of Python programming?
The purpose of Python programming is to provide a platform for only web development and nothing else.
The purpose of Python programming is to limit the functionality of applications and reduce efficiency.
The purpose of Python programming is to provide a simple and efficient way to write code for various applications.
The purpose of Python programming is to create complex and lengthy code for specific tasks.
Define a virus in the context of computer systems.
A computer virus is a software that improves user experience by adding features.
A computer virus is a harmless program that enhances system performance.
A computer virus is a tool used for data recovery and backup.
A computer virus is a malicious program that replicates itself by infecting other files or programs.
What is Excel primarily used for?
Data organization, analysis, and visualization in spreadsheets.
Creating presentations and slideshows.
Writing and editing text documents.
Designing graphics and illustrations.
List one feature of Excel that helps in data organization.
PivotTables
Charts
Tables
Macros
What is the first step in creating a Python program?
Install Python on your computer.
Write the program's documentation.
Choose a programming language.
Define the problem or task.
Explain what a loop does in programming.
A loop stops the execution of the program.
A loop creates a new variable in the program.
A loop defines a function in the code.
A loop enables repeated execution of a block of code.
How do you open a new Excel spreadsheet?
Click on 'File' and choose 'Open' from the menu.
Select 'New Document' from the Home tab.
Right-click on the desktop and select 'New Excel Sheet'.
Open Microsoft Excel and select 'New' from the File menu.
What is the function of an algorithm?
The purpose of an algorithm is to generate random numbers.
An algorithm serves to display visual content.
The function of an algorithm is to provide a systematic method for solving problems or performing tasks.
An algorithm is used to create random data.
Describe how to save a file in Excel.
Select 'Edit', then 'Save', choose format, and confirm.
Click 'File', then 'Save As', choose location, enter file name, and click 'Save'.
Click 'Home', then 'Export', select type, and finalize.
Go to 'View', then 'Download', pick folder, and hit 'OK'.
What is a variable in Python?
A variable in Python is a named reference to a value stored in memory.
A variable in Python is a constant value that cannot change.
A variable in Python is a type of data structure used for storage.
A variable in Python is a function that performs calculations.
How can you format cells in Excel?
Select cells, then drag to resize them for formatting.
Select cells, right-click, choose 'Format Cells', or use the 'Home' tab to access formatting options.
Use the 'Insert' tab to change cell colors.
Click on the cell, then press 'Ctrl + F' to format.
What is the difference between a virus and a worm?
A virus can only infect executable files, while a worm can only spread through email attachments.
A virus needs a host file to spread, whereas a worm is self-replicating and does not require a host.
A virus can spread through networks, while a worm requires user interaction to activate.
A virus is a standalone program, whereas a worm is a type of malware that needs a user to function.
How do you write a simple print statement in Python?
console.log('Hello, World!')
echo 'Hello, World!'
print('Hello, World!')
print('Greetings, Earth!')
What is the purpose of using functions in Python?
Functions in Python are used to create graphical user interfaces.
The purpose of using functions in Python is to promote code reuse, organization, and modularity.
The purpose of functions is to increase the execution speed of the program.
Functions in Python are primarily for handling database connections.
How can you create a chart in Excel?
Select data, go to 'Insert' tab, choose chart type, and customize.
Copy data, open 'View' tab, pick graph type, and print.
Highlight data, click 'File' menu, select chart style, and save.
Enter data, navigate to 'Home' tab, select diagram type, and share.
What is the significance of indentation in Python?
Indentation is significant in Python as it defines code blocks and controls the flow of execution.
Indentation is a stylistic choice and does not impact functionality.
Indentation is optional in Python and has no effect on execution.
Indentation is used only for comments in Python code.
Explain how to use the SUM function in Excel.
The SUM function in Excel subtracts a range of numbers.
The SUM function in Excel divides a range of numbers.
The SUM function in Excel adds together a range of numbers.
The SUM function in Excel multiplies a range of numbers.
What steps would you take to debug a Python program?
Ignore error messages and continue coding.
Use only comments to explain the code.
Rely solely on online forums for solutions.
Use print statements, a debugger, and review error messages to identify and fix issues.
