NEW
Font size
WorksheetsExploring Software and Data Analysis
Total questions: 20
Worksheet time: 10mins
What is system software?
System software is only used for gaming applications.
System software is software that manages and controls computer hardware and provides a platform for application software.
System software is primarily for web browsing.
System software is a type of hardware.
Which of the following is an example of application software?
Microsoft Excel
Adobe Photoshop
Google Chrome
Microsoft Word
All of the listed examples
What type of software is used to manage hardware resources?
Application software
Utility software
Malware
System software
Which of the following is NOT a type of software?
Firmware
Application
Operating System
Hardware
What is the primary function of a database management system (DBMS)?
To process financial transactions.
To store, retrieve, and manage related data .
To create and design websites.
To manage user authentication and authorization.
Which Excel function is used to find the average of a set of numbers?
AVERAGE
MAX
COUNT
SUM
What does the VLOOKUP function do in Excel?
The VLOOKUP function looks up a value in a table and returns a corresponding value from a specified column.
The VLOOKUP function creates charts from data in a table.
The VLOOKUP function formats cells based on their values.
The VLOOKUP function calculates the sum of a range of cells.
Which of the following is a logical function in Excel?
IF
SUM
AVERAGE
COUNT
What is the purpose of the COUNTIF function in Excel?
The purpose of the COUNTIF function is to count cells that meet a specific condition.
To sort data in ascending order.
To find the maximum value in a dataset.
To calculate the average of a range of cells.
Which Excel feature allows you to visualize data trends?
PivotTables
Charts
Tables
Conditional Formatting
What is a primary key in a database?
A primary key is an optional field in a database.
A primary key can be duplicated across records.
A primary key is a type of foreign key.
A primary key is a unique identifier for a record in a database.
Which of the following is a type of relational database?
MongoDB
PostgreSQL
MySQL
SQLite
What does SQL stand for?
Structured Query List
Simple Query Language
Standard Query Language
Structured Query Language
Which Excel function would you use to concatenate text?
CONCATENATE or &
JOIN
MERGE
LINK
What is the purpose of pivot tables in Excel?
The purpose of pivot tables in Excel is to summarize and analyze large datasets.
To create charts and graphs from data
To format cells with different colors
To protect data from unauthorized access
Which of the following is a common data type in databases?
String
Date
Integer
Boolean
What does the term 'normalization' refer to in database design?
Normalization is the process of backing up data in a database.
Normalization is the technique of merging multiple databases into one.
Normalization refers to the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization refers to the method of encrypting data for security.
Which Excel function can be used to round numbers?
ROUNDUP
CEILING
ROUNDDOWN
ROUND
What is the difference between a flat file and a relational database?
A relational database stores data in a single table without relationships.
A flat file stores data in a single table without relationships, while a relational database uses multiple tables with defined relationships.
Flat files are more complex than relational databases.
A flat file can store data in multiple tables with relationships.
Which of the following is a benefit of using a DBMS?
Improved data integrity and security
Slower data retrieval
Increased data redundancy
Limited user access control
![Computational Thinking in Python[Quiz 3]](https://cf.quizizz.com/image/image-loader.svg)
