O LEVEL (O-PR) – BATCH: S2
Using grade.xls in MS-Excel to perform the following formatting operations:
a) Draw a border around the worksheet
b) Change the font size of heading to 14 points and underline it and hide column c
c) Increase the width of column A to 15 characters
d) Right Align the values in column B, C, F (25)
ANSWER
(a) for border, first select all cells press Ctrl + A.
After click on border symbol and select all border.
SAVE THIS FILE WITH THE NAME OF grade.xls
Result:
.jpeg "o level practical question paper, a level it, web designing, python solution")
(b) Change the font size of heading to 14 points and underline it and hide column c
(C) To adjust the width of column A to 15 characters in Microsoft Excel , follow these steps:
Steps:
1. **Select Column A:**
- Click on the **A** header at the top of the column to highlight the entire column.
2. **Open the Column Width Dialog:**
- Right-click on the selected column and choose **Column Width** from the context menu.
3. **Set the Width:**
- In the dialog box, enter `15` and click **OK**.
### Shortcut Method:
- Select column A, then go to the **Home** tab.
- In the **Cells** group, click **Format** > **Column Width**.
- Enter `15` and press **OK**.
This will set the width of column A to exactly 15 characters.
RESULT:
2. Design a form using HTML tags for student enrolment in a school. (25)
<!DOCTYPE html>
<html>
<head>
<title>Student Enrollment Form</title>
</head>
<body>
<h2>Student Enrollment Form</h2>
<form>
<label for="name">Full Name:</label><br>
<input type="text" id="name" name="name" required><br><br>
<label for="dob">Date of Birth:</label><br>
<input type="date" id="dob" name="dob" required><br><br>
<label for="gender">Gender:</label><br>
<select id="gender" name="gender">
<option value="male">Male</option>
<option value="female">Female</option>
<option value="other">Other</option>
</select><br><br>
<label for="class">Class:</label><br>
<input type="text" id="class" name="class" required><br><br>
<label for="address">Address:</label><br>
<textarea id="address" name="address" rows="4" required></textarea><br><br>
<input type="submit" value="Enroll">
</form>
</body>
</html>
.jpeg)
3. Write a ‘python’ function to remove duplicates from an ordered array. For example, if input array
contains 10,10,10,30,40,40,50,80,80,100 then output should be 10,30,40,50,80,100.
OR
<!DOCTYPE html>
<html>
<head>
<title>Remove Duplicates</title>
<script>
function removeDuplicates() {
const array = [10, 10, 10, 30, 40, 40, 50, 80, 80, 100];
const uniqueArray = [...new Set(array)];
document.getElementById("output").innerText = uniqueArray.join(", ");
}
</script>
</head>
<body>
<button onclick="removeDuplicates()">Remove Duplicates</button>
<p id="output"></p>
</body>
</html>
Write a program in ‘python’ to read two strings from the keyboard using readline statements and
compare them ignoring the case.
s1 = input("Enter first string: ")
s2 = input("Enter second string: ")
print(f"String 1: {s1}\nString 2: {s2}")
.jpeg&description=O LEVEL (O-PR) – BATCH: S2 2015 question paper with solution){kind=link}