Page 141 - TP_V5.1_C7_fb
P. 141
Half-Yearly Examination
Sample Paper
(Chapters 1, 2, 3 and 4)
Max. Time: 2 Hours Max. Marks: 40
1. Fill in the blanks. 5×1=5
a. A computer represents all kinds of data and information like text, numbers, audio and video
in ........................ form.
b. The hexadecimal number system uses digits from 0 to 9 and letters from ........................
to ........................ .
c. The feature that allows you to see only the data that meets specific criteria is
called ........................ .
d. To style an element with a circle bullet, you can use the CSS property list-style-........................ .
e. To arrange data in ascending order, you use the ........................ option in Excel.
2. Application-based questions. 4×1=4
a. You need to find out which students have attended more than 40 classes. What feature in
Excel will help you filter this information?
b. You are working on a project that involves converting binary numbers to decimals.
You receive the binary number 1011. Convert this binary number to its decimal equivalent.
c. Your friend wants to know how many items he has in a list of products. He should use
the ........................ function to count the number of entries.
d. You have scores for 5 subjects: 88, 92, 79, 85, and 90. Which Excel function will you use to
find the average score?
3. Define the following terms: 4×1.5=6
a. LEN() function in Excel
b. Conditional Formatting
c. Rowspan attribute in an HTML table
d. Decimal number system
4. Short answer type questions. 3×2=6
a. Difference between Least Significant Digit and Most Significant Digit.
b. Explain the difference between the <ol> and <ul> tags in HTML.
c. Describe how to use the ROUND() function in Excel and provide an example.
5. Long answer type questions. 3×3=9
a. Explain the difference between container tags and empty tags in HTML, with examples.
b. Describe a scenario where you would use conditional formatting to improve the readability of
a data table. Explain how you would set it up.
c. What is the difference between the LEFT() and RIGHT() functions? Provide examples of both.
Half-Yearly Examination Sample Paper 139

