Font size
Worksheets8 ICT MidTerm 2024-25
Total questions: 80
Worksheet time: 47mins
Which of the following is not an HTML version?
HTML 1.0
XHTML
HTML 5
All of the above
Which of the following is an attribute of the body element?
bgcolor
background
leftmargin
None of the above
What instructs the browser how to display a particular text or image?
Tag
Element
Attribute
Which of the following is an empty element?
<html>
<br>
<body>
<head>
State whether the following statements are true or false.
<hr> element can draw a line only in black colour.
(a)
What is this tag used for?
<u>
(a)
A (a) consists of multiple web pages linked to each other through hypertext.
What is this tag used for?
<hr>
(a)
An (a) is a piece of code that instructs the browser how to display a particular text or image.
State whether the following statements are true or false.
To display the text in the center of the web page, we use <middle> tag.
(a)
The process of arranging data in a particular order is called.
(a)
When data is formatted according to the specific conditions, it is called.
(a)
(a) referencing is the combination of absolute and relative referencing.
The buttons to sort data are in.
(a)
A formula cannot be copied from one cell to another.
True
False
In the Sort dialog box, option is selected if the selected range consists of column headings in the top row of the selected range.
My data has headers
My headers
My Data
My headers have data
In a (a) , the categories are organized vertically and the values horizontally.
All the sectors summed up together in a pie chart make up the full circle.
(a)
2. The (a) chart is created by connecting a series of data points.
3. A (a) chart is used to display quantitative data graphically.
True or Flase
A chart can never be inserted in a separate sheet.
(a)
True or False
A data table can be inserted with the chart.
(a)
True or False
You cannot change the title of the chart once it is inserted.
(a)
True or False
In a bar chart, X-axis is the category axis.
(a)
With reduced redundancy. ___________ automatically increases.
Duplication
Consistency
characters
AutoNumber
What is the default size of a text data type?
240 characters
255 characters
260 characters
270 characters
Which of the following data types is the most suitable for a primary key?
Text
AutoNumber
Date/Time
short text
A (a) is a unique identifier for a perticular record in a table.
Data is maintained and (a) and a database.
A database might contain (a) tables..
(a) supports multiple user environment.
Which chart will be most effective in comparing the tuition fee of private and public schools?
Bar chart
Doughnut chart
Area chart
Pie chart
Which of the following is not a subtype of column chart?
Cylinder
Circle
Cone
Pie
Which chart contains the data for a single data series?
Column
Bar
Line
Pie chart
Area chart
Which of the following is used to identify the data series being represented in the chart?
Data Label
Plot area
Chart
Legends
As the chart is inserted in the worksheet, which of the following tabs do not appear on the ribbon?
Design
View
Layout
Format
Name one component of a chart.
Legend
Axis
Gridlines
Data Labels
What is a sparkline?
A sparkline is a large, detailed graph.
A sparkline is a statistical analysis tool.
A sparkline is a type of computer program.
A sparkline is a small, simple chart that shows data trends.
What is the first step to create a sparkline?
Enter a title for the sparkline.
Select the data range for the sparkline.
Choose a chart type for the sparkline.
Adjust the color settings for the sparkline.
What should you specify in the Location Range when creating a sparkline?
The range of cells for the sparkline's color.
The type of chart to be used for the sparkline.
The title of the sparkline.
The range of cells containing the data for the sparkline.
What happens when you click OK after setting up a sparkline?
The sparkline is deleted from the selected cell.
The sparkline is saved as a separate file.
A dialog box appears asking for confirmation.
The sparkline is created and displayed in the selected cell.
Can sparklines be larger than a single cell?
Sparklines can be larger than a row but not a cell.
No, sparklines cannot be larger than a single cell.
Sparklines can be resized to fit any area.
Yes, sparklines can be displayed across multiple cells.
What type of data representation do sparklines provide?
Static data snapshots
Categorical data distributions
Trends in data over time
Random data points
How can you move a chart in a spreadsheet?
Right-click the chart and select 'Move' from the menu.
Click and drag the chart to move it.
Double-click the chart to open a settings menu.
Use the arrow keys to reposition the chart.
What is relative referencing in spreadsheets?
Relative referencing allows cell references in formulas to adjust automatically when copied to another cell.
Relative referencing requires manual adjustment of cell references after copying.
Relative referencing is a method to lock cell references in formulas.
Relative referencing is used to create static links between cells.
What is the first step to sort data in multiple columns?
Filter the data before sorting.
Add a header to the data range.
Change the font style of the data.
Select the range of data to sort.
Where can you find the Sort button in Excel?
In the 'Data' tab on the Ribbon.
In the 'Insert' tab on the Ribbon.
In the 'View' tab on the Ribbon.
In the 'Home' tab on the Ribbon.
What should you check if your data has headers?
Ensure all data is numeric
Verify header labels, check for duplicates, ensure data consistency, and confirm alignment with data structure.
Verify the file format is CSV
Check for missing rows
What is the default order for sorting data?
Random order
Descending order
Alphabetical order
Ascending order
What does the Add Level button do in the Sort dialog box?
It adds additional sorting criteria.
It removes existing sorting criteria.
It changes the order of the current criteria.
It saves the sorting settings for future use.
What options can you select under the Then By list box?
Shape
Color
Weight
Date, Name, Size, Type
What are the two criteria for filtering data?
Color criteria
Size criteria
Shape criteria
1. Value criteria 2. Type criteria
What appears next to each column when filtering is enabled?
Checkbox
Text field
Dropdown arrow
Radio button
Can you filter data based on cell formats?
No, you cannot filter data based on cell formats directly.
Yes, you can filter data based on cell colors.
You can filter data based on font styles.
Filtering by cell formats is possible with a special tool.
What is the purpose of filtering data in spreadsheets?
To increase the amount of data displayed.
To remove all data from the spreadsheet.
To sort data in alphabetical order.
To display only relevant data that meets specific criteria.
What are the three main elements of a database?
Data, Server, Network
Data Model, Query Language, User Interface
Data, Application, Storage
DBMS
What does DBMS stand for?
Digital Business Management Software
Database Management System
Data Backup Management System
Database Backup Service
What is the primary function of a DBMS?
To manage user authentication and access control.
To store, retrieve, and manage data in databases.
To create and design websites.
To process and analyze financial transactions.
How does an RDBMS differ from a DBMS?
An RDBMS does not support transactions.
its a type of DBMS that uses a relational model.
An RDBMS stores data in a flat file format.
A DBMS is always more complex than an RDBMS.
What is a table in the context of a database?
A table is a type of software used for managing databases.
A table is a single piece of data in a database.
A table is a graphical representation of data without any structure.
A table is a structured collection of data organized in rows and columns in a database.
Define a field in a database.
A field is a row in a database that contains all attributes.
A field is a column in a database table that holds data for a specific attribute.
A field is a database that holds entire datasets.
A field is a type of database that stores multiple tables.
What is a record in a database?
A record is a collection of related data items stored together in a database.
A record is a method for querying a database.
A record is a type of database management system.
A record is a single data type in programming.
What is the first step to create a database in MS Access 2019?
Open an existing database file.
Select 'Create New Table' from the menu.
Open MS Access 2019 and select 'Blank Database'.
Click on 'Import Data' to start a new database.
What should you do after selecting a template in MS Access?
Delete the template immediately.
Print the template without any changes.
Customize the template by adding fields and entering data.
Share the template with other users.
What is the purpose of the 'Save Database As' option?
To delete the existing database permanently.
To create a copy of the database with a new name or location.
To export the database to a different file format.
To merge two databases into one.
What appears when you select 'Save Database As' in MS Access?
A dialog box to save the database with a new name and location.
A prompt to delete the existing database.
An error message about insufficient permissions.
A confirmation message indicating the database is saved.
What should you type in the File name text box when saving a database?
database_file.txt
my_database.doc
data_backup.csv
my_database.db
What happens when you click the Save button in the Save As dialog box?
The file is deleted from the system.
The file is saved to the specified location with the chosen name.
The file is opened in a new window.
The file is sent to a printer.
Can you create a blank database in MS Access?
You can only create a database with pre-defined templates in MS Access.
Yes, you can create a blank database in MS Access.
MS Access does not support database creation at all.
No, you cannot create a blank database in MS Access.
List three attributes of the font element.
style
color, size, face
weight
alignment
What is the purpose of the background attribute?
To define the font style of an HTML element.
To set a background image or color for an HTML element.
To control the visibility of an HTML element.
To set the margin and padding of an HTML element.
What is the tag used for?
The tag is used to create hyperlinks.
The tag is used to add audio files.
The tag is used to define a table.
The tag is used to embed images in a webpage.
Name two attributes of the tag.
src, alt
width
title
href
What does the 'src' attribute in the tag specify?
The 'src' attribute specifies the URL of the image.
The 'src' attribute specifies the size of the image.
The 'src' attribute specifies the alt text for the image.
The 'src' attribute specifies the title of the image.
How can you center text on a web page?
Set 'display: flex;' on the parent container.
Use 'text-align: left;' to align text to the left.
Apply 'padding: 20px;' to the text element.
Use CSS 'text-align: center;' for inline elements or 'margin: auto;' for block elements.
What is the purpose of the 'alt' attribute in the tag?
The 'alt' attribute is used for image file names.
The 'alt' attribute controls the image's loading speed.
The 'alt' attribute provides alternative text for images.
The 'alt' attribute specifies the image's dimensions.
Can the bgcolor attribute accept RGB hexadecimal codes?
Yes, the bgcolor attribute can accept RGB hexadecimal codes.
No, the bgcolor attribute only accepts named colors.
Yes, but only in RGB format, not hexadecimal.
No, the bgcolor attribute does not accept any color codes.
What is the significance of the 'width' attribute in the tag?
The 'width' attribute specifies the height of the image.
The 'width' attribute is used to set the image's file size.
The 'width' attribute defines the display width of the image in pixels.
The 'width' attribute controls the image's loading speed.
How do you specify an image file for the background attribute?
Use 'background-image: url("path/to/image.jpg");' in CSS.
Apply 'background-url: 'path/to/image.jpg';' in CSS.
Set 'background-file: 'path/to/image.jpg';' in CSS.
Use 'background: image('path/to/image.jpg');' in CSS.
What does the 'align' attribute do in the tag?
The 'align' attribute sets the image's size.
The 'align' attribute specifies the image format.
The 'align' attribute adds a border to the image.
The 'align' attribute controls the alignment of the image.
