Scribd
Upload
113 views1 page

ICT Worksheet

This document is an ICT worksheet assignment for class 7 on chapter 2 about computers. It contains 8 questions asking how to perform various tasks in Excel like creating a list of numbers, adding a custom list of friends, using Flash Fill to autofill data, sorting data in descending order, using conditional formatting, removing conditional formatting, filtering rows based on a criteria, and removing a filter. The assignment is due on September 15th, 2022 and contains the student's name, class, subject, total marks, and spaces for signatures from the teacher and parent.

Uploaded by

ZAHRA NAUREEN NAUREEN
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
113 views1 page

ICT Worksheet

This document is an ICT worksheet assignment for class 7 on chapter 2 about computers. It contains 8 questions asking how to perform various tasks in Excel like creating a list of numbers, adding a custom list of friends, using Flash Fill to autofill data, sorting data in descending order, using conditional formatting, removing conditional formatting, filtering rows based on a criteria, and removing a filter. The assignment is due on September 15th, 2022 and contains the student's name, class, subject, total marks, and spaces for signatures from the teacher and parent.

Uploaded by

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

Assignment 2:

Date:
Topic: Chapter 2-More
About Computer
Page 36 ICT Worksheet Total: 20 Marks

Class: 7 Subject: ICT Marks Obtained:


Deadline: 15 September 2022

Student Name: _______________________________________________

A. Answer the following: 20 Marks


1. Which feature of Excel would you use to create the list of numbers 1700, 1701, 1702...1750
in cells A1:A50?
2. How will you add a list of your five friends in Custom Lists? Explain any one method.
3. What is Flash Fill? Explain by taking an example.
4. A worksheet has data fields-Subject and Marks. How will you sort the data in descending
order of Marks?
5. What is conditional formatting?
6. How will you remove the conditional formatting applied to cells A1:E5?
7. A worksheet has data fields-Roll No. and Total Marks, of 10 students in the cell range
A1:B11. The first row is the header row. How will you display only those rows where Total
Marks obtained by a student is greater than 250?
8. How will you remove the Filter button applied to the column heading?

****END****

Teacher’s Signature: ……………………….. Parent’s Signature: ………………………

You might also like