WorksheetsData Management Quiz
Total questions: 50
Worksheet time: 25mins
What is the purpose of storing data in a computer?
To play games
To save information for later use
To paint pictures
To watch videos
Which of the following is an example of numeric data?
Name
Age
City
Color
What is a spreadsheet used for?
Writing stories
Organizing data in rows and columns
Editing photos
Watching videos
What does a cell in a spreadsheet represent?
Location for a single piece of data
A whole table
The title of the document
A picture
Which symbol starts a formula in a spreadsheet?
#
=
&
*
In which format is date data usually stored?
Text
Number
Date format (e.g., 12/05/2025)
Boolean
Which data type can only be True or False?
Text
Boolean
Number
Date
What is the name of a collection of data organized in rows and columns?
File
Spreadsheet
Folder
Database
Which part of a database holds information about one item or person?
Field
Record
Table
Cell
The name of a column in a database is called a:
Field
Row
Record
Cell
What is data validation?
Checking data to make sure it is correct
Deleting data
Copying data
Printing data
Why do we use formulas in spreadsheets?
To make calculations automatically
To add colors
To create pictures
To write stories
Which of these is NOT a spreadsheet tool?
Sorting
Copying
Formula
Browsing
What does sorting data in a spreadsheet do?
Changes data values
Organizes data in a specific order
Deletes half of data
Draws pictures
Which data type is best for storing a person’s height?
Text
Number (Decimal)
Boolean
Date
Which data type stores letters and words?
Number
Text
Boolean
Date
What is a database?
A place where data is stored and managed
A kind of computer
A software game
A drawing tool
What is meant by 'record'?
A single row in a database table
A column heading
A spreadsheet formula
A file format
What is the first step in managing data?
Storing data
Collecting data
Drawing data
Deleting data
Which tool helps keep data accurate by checking input?
Validation rules
Coloring
Printing
Deleting
What does data filtering allow you to do?
Display only data that meets certain criteria
Delete data
Create formulas
Copy data
Which is an example of continuous data?
Temperature
Number of students
Days of the week
True/False
Data stored as ‘Yes’ or ‘No’ is an example of which data type?
Boolean
Text
Number
Date
Why do we organize data into tables?
To make it easier to manage and analyze
To make stories
To create images
To watch videos
In a spreadsheet, what does freezing panes do?
Keeps certain rows or columns visible when scrolling
Deletes data
Prints data
Sorts data
What does the ‘sum’ function in spreadsheets do?
Adds numbers together
Multiplies numbers
Finds the average
Counts text
Which of these is NOT a part of a database?
Table
Record
Field
Picture
What is meant by ‘duplicate data’?
Data that appears more than once unnecessarily
Correct data
Broken data
Filtered data
Which of these would be a ‘key’ in a database?
Unique student ID number
Age
Name
Gender
In spreadsheets, what is ‘autofill’ used for?
To quickly copy data or formulas to adjacent cells
To delete cells
To change text size
To print sheets
The place where you type formulas or data in a spreadsheet is called:
Formula bar
Row
Column
Sheet
What is meant by ‘sorting A to Z’ in a spreadsheet?
Organizing data alphabetically from A to Z
Deleting data
Printing data
Copying data
Which data type is best to store telephone numbers?
Text
Number
Boolean
Date
What is data entry?
Typing data into a computer system
Drawing pictures
Playing games
Printing papers
Which is a benefit of using a computer database?
Easy to store and search data
Only for games
Only for photos
Only for videos
A ‘field’ in a database corresponds to:
A category of data, like ‘Name’ or ‘Age’
A single record
A whole table
A spreadsheet formula
What does ‘filtering’ do in a spreadsheet?
Shows only rows meeting criteria
Deletes all data
Changes text color
Copies data
What does ‘validation’ prevent?
Invalid data from being entered
All data getting lost
Printing
Copying data
Which type of chart is best to show parts of a whole?
Pie chart
Line chart
Bar chart
Scatter plot
In spreadsheets, what is a ‘cell reference’?
The name of a cell by column and row (e.g., B3)
The data
A chart
A picture
Which of these is a spreadsheet file extension?
.xlsx
.docx
.jpg
.mp3
Which of these is an example of qualitative data?
Favorite color
Number of pets
Age
Weight
What is a ‘formula’ in a spreadsheet?
A calculation entered by the user
A picture
A text box
A video
Why is it important to save your work often?
To avoid losing data
To decorate files
To print pictures
To play music
Which of these is NOT a good way to keep data safe?
Backing up data
Sharing passwords
Using strong passwords
Using antivirus
Data stored over time from sensors is called:
Time-series data
Text data
Boolean data
Graph data
Which action do you NOT do when managing data?
Sorting
Editing
Playing games
Filtering
What does ‘data redundancy’ mean?
Unnecessary repetition of data
Correct data entry
Unique data item
None of the above
Which option allows you to view data as a summary?
Pivot table
Text box
Video player
Drawing tool
Why should data be kept in consistent formats?
To ensure correct processing and analysis
To make it colorful
To delete old data
To print faster
