NEW
Font size
WorksheetsManaging Data
Total questions: 50
Worksheet time: 25mins
What type of data is used to represent numbers with decimals?
Boolean
Integer
Floating point
Character
What is the purpose of a database?
Create images
Manage and store data efficiently
Edit videos
Send emails
Which data type can have only two values: True or False?
Numeric
Text
Boolean
Date
Which spreadsheet function is used to find the average of a range of cells?
SUM()
AVG()
AVERAGE()
COUNT()
What is a primary key in a database?
A field that uniquely identifies each record
The first record in a table
A field used for sorting
The total number of records
What does data validation do?
Deletes data
Checks the accuracy and quality of data before entry
Views data
Filters data
Which of the following represents categorical data?
Student ID
Gender
Age
Height
What tool in spreadsheets is used to organize data in a specific order?
Filter
Sort
Highlight
Annotate
What happens when you apply a filter on data?
Data is deleted
Only data meeting specified criteria is shown
Data is copied
Data is saved
How is a record represented in a database?
A row
A column
A field
A cell
Which of the following is NOT a common data type?
Text
Integer
Image
Boolean
What is the range check in data validation used for?
To ensure data falls within specified limits
To check if data is text
To delete invalid data
To sort data
How can data redundancy in databases be minimized?
By properly designing the database and normalizing data
By duplicating data
By deleting all records
By sorting data
What symbol is used to start a formula in most spreadsheet applications?
=
+
-
*
Why are databases preferred over spreadsheets for large data storage?
Easier data management and querying
Better color schemes
Attractive fonts
Animations
What does the COUNT() function do in a spreadsheet?
Adds numbers
Counts the number of cells containing numbers
Finds the maximum value
Finds the minimum value
Which of these is an example of continuous data?
Number of students
Temperature
Gender
Date of birth
What is the purpose of sorting data?
To delete it
To organize data in a meaningful order
To make cells bigger
To highlight sheets
Which data type represents dates and times?
Text
Date/time
Boolean
Number
What does normalization in databases involve?
Deleting data
Organizing data to reduce duplication
Coloring tables
Merging documents
What does the formula "=A1+B1" do?
Subtracts two cells
Multiplies two cells
Adds the content of cells A1 and B1
Divides the content of cells A1 and B1
What is the definition of a 'field' in a database?
A single data item or attribute
A record
A row
A table
What is meant by data filtering?
Deleting all data
Displaying only data that meets specified criteria
Sorting data
Calculating data
Which data type can store letters, numbers, and symbols?
Text
Integer
Boolean
Date
How can you ensure data entered into a spreadsheet is valid?
Use data validation rules
Print the data
Delete data
Save the data
What is a cell reference in spreadsheets?
The address of a cell like B2
The content of a cell
A chart
A type of data
How is data stored in a database table?
In rows and columns
As images
As videos
In charts
What action should be taken to avoid data redundancy?
Use proper design and normalization
Duplicate data
Increase data size
Delete tables
What does the SUM() function do?
Adds numbers in a range
Counts numbers
Multiplies numbers
Divides numbers
What type of data is 'Student ID'?
Text
Numeric
Boolean
Date
What does a database management system (DBMS) do?
Stores and organizes data
Edits videos
Creates images
Plays music
What does a formula in a spreadsheet allow you to do?
Perform calculations automatically
Make a drawing
Watch videos
Type text
What is meant by data integrity?
The accuracy and consistency of data
Data being colorful
Data being deleted
Drawing tables
Which of these is used to find the highest number in a range?
MAX()
MIN()
AVERAGE()
SUM()
What does duplication of data lead to?
Data redundancy
Data saving
More efficient data
Correct data entry
What is Boolean data used for?
True/False values
Text values
Number values
Date values
Which of the following best describes 'metadata'?
Data about data
Pictures in a database
Videos in a file
Audio recordings
What is the function of a primary key?
To uniquely identify records
To sum numbers
To sort data
To validate entries
How does sorting data A to Z organize text?
Alphabetically from A to Z
By size
By date
By color
Why is data security important?
To protect data from unauthorized access
To make data colorful
To delete data
To make data bigger
What term describes removing unnecessary data duplication?
Normalization
Sorting
Filtering
Formatting
In a spreadsheet, what is the function of ‘autofill’?
To automatically fill cells with data or formulas
To delete cells
To print cells
To copy cells manually
How do you prevent entering incorrect data?
Use validation rules
Clear the spreadsheet
Save frequently
Color the cells
What is the function of a filter in managing data?
Show only data that matches criteria
Delete data
Copy data
Paste data
What does the MIN() function in a spreadsheet do?
Finds the smallest number in a range
Adds numbers
Multiplies numbers
Counts numbers
Which of the following is NOT a type of data field?
Text
Number
Picture
Boolean
What does 'data modelling' refer to?
Making a digital representation of real-world data
Drawing pictures
Editing videos
Writing documents
What does duplicated data cause?
Data redundancy
Data correctness
Data accuracy
Data integrity
What type of chart shows relationships between categories?
Bar chart
Pie chart
Line chart
Scatter chart
What is the best way to back up important data?
Copy to another location or cloud storage
Deleting files
Printing files
Coloring cells
