Scribd
Upload
26 views10 pages

Ict L3

The document outlines a series of Excel tasks for students, including creating a workbook, entering and formatting data, and applying conditional formatting. It details steps for managing rows and columns, creating tables, sorting data, and generating pivot tables. Additionally, it includes instructions for using the Text to Columns feature to separate full names into first and last names.

Uploaded by

MUHAMMAD Fahad Iqbal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
26 views10 pages

Ict L3

The document outlines a series of Excel tasks for students, including creating a workbook, entering and formatting data, and applying conditional formatting. It details steps for managing rows and columns, creating tables, sorting data, and generating pivot tables. Additionally, it includes instructions for using the Text to Columns feature to separate full names into first and last names.

Uploaded by

MUHAMMAD Fahad Iqbal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 10

Submitted By:

Name Registration No
ZAINAB BIBI BS-24-IB-102897
Lab#
Batch: Teacher:
BSChe 2024-28 Dr. Irfan Ul Haq

Semester Lab Engineer:


2nd Mr. Adnan Ijaz

TASK 1 & Task 2: Basic Excel Operation, Data Entry and Formatting
1. Open Microsoft Excel and create a new workbook.

2. Rename the first sheet to "Student Data."

3. Add three more sheets and rename them as "Marks," "Attendance," and

"Reports."

4. Change the tab color of each sheet to different colors.

5 In the "Student Data" sheet, enter the following columns:

• Student ID

• Name

• Age

• Department

a. Enter data for at least 10 students.

b. Format the header row with bold text and a background color.

c. Adjust column width to fit the content.


TASK 3

Task 3: Working with Rows and Columns

1. Insert a new column between "Name" and "Age" labeled "Gender."

2. Add a new row at the top for the title "Student Information" and merge the

cells across all columns.

3. Delete the last row from the dataset


Task 4: Conditional Formatting

1. In the "Marks" sheet, enter student names and their marks in three subjects.

2. Apply conditional formatting to highlight marks:

• Greater than 80 in green.

• Between 50 and 80 in yellow.

• Less than 50 in red..


Task 5: Tables and Sorting

1. Convert the "Student Data" range into a table.

2. Sort the table alphabetically by student name.

3. Filter the table to show only students from a specific department.

STUDENTS FROM SPECIFIC DEPARTMENT

Task 6: Pivot Table

1. Create a pivot table from the "Marks" sheet.

2. Display the average marks of students per subject.

3. Apply a suitable table style.


Task 8: Text to Columns

1. In a new column of the "Student Data" sheet, enter full names of students

(e.g., "Ali Khan").

2. Use the Text to Columns feature to split names into separate "First Name" and
"Last Name" columns.

You might also like