ICT Workbook

Grade 5
Term 3

Name: _______________________

Class: _______________________

Section: ______________________

School Publication
 Grade-5, Term3

*****INDEX *****
Contents Page No Signature
1. Starting Excel 2013 2
A. Fill up 2
B. True/False 2
C. Choose the correct option 2
D. Short questions 3
E. Application based questions 4
F. Who am I? 5 ______________
2. Editing Cell Contents in Excel 2013 6
A. Fill up 6
B. True/False 6
C. Choose the correct option 6
D. Short questions 7
E. Application based questions 8
F. Who am I? 9
G. Jumble words 10 ______________
3. First Step to the Internet 11
A. Fill up 11
B. True/False 11
C. Choose the correct option 11
D. Short Answer Questions 12
E. Application-Based Questions 13
F. Who am I? 14
G. Jumbled words 15 ______________

1
 Grade-5, Term3

Starting Excel 2013

A. Fill in the blanks with the correct words.
1. A _____________ is a page containing a grid of cells made up of rows and columns.
2. The ____________________ contains commands divided into groups.
3. The ____________________ box displays the address of the selected cell.
4. The ____________________ bar displays the data or formula in a selected cell. It is
used to enter or edit the cell contents.
5. To cancel the data entry before pressing Enter, press ____________________.

B. Write T for the true statement and F for the false one.
1. An Excel 2013 worksheet has 1,048,576 rows and 16, 384 columns. _______
2. The last column is labelled XFD. _______
3. The types of data that can be entered in Excel 2013 are numbers, text and formulas.
_______
4. You can select only one range of cells at a time. _______
5. You can type data only in the selected cell. _______

C. Choose the correct option.

1. Which key should you press to switch on the EXTEND SELECTION mode?
a. F2 b. F4 c. F5 d. F8

2. Which one of the following is not a Worksheet View option?

a. Normal View b. Page Layout View
c. Page Break View d. Web Layout View

2
 Grade-5, Term3

3. Which of the following displays the address of the selected cell?

a. Formula Bar b. Name Box c. Status Bar d. None of above

4. You can save an Excel 2013 file by clicking the

a. Save icon on the Quick Access Toolbar b. Ctrl + S
d. All of the above

5. The keyboard shortcut to select the full worksheet is

a. Ctrl + A b. Alt + A c. Shift + A d. A

D. Short Answer Questions.

1. How will you create a new workbook?
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
2. How will you open an already existing file on the Desktop within Excel 2013?
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
3. What is the default extension of an Excel 2013 workbook?
______________________________________________________________________
4. What is the difference between the Name Box and the Formula Bar?
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
3
 Grade-5, Term3

5. How will you select the range of cells B1:F5?

______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________

E. Application-Based Questions.
1. Consider the worksheet given below:

a. Name the cell formed by the

intersection of row 5 and column D.
______________________________________________________________________
b. How will you select the entire D column and the 5th row?
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
2. Atif wants to work in Excel 2013. He has opened a Blank Workbook.

a. How many worksheets are there in a blank workbook by default?

______________________________________________________________________
b. What is the default name of the worksheet?
______________________________________________________________________
c. How can you get more worksheets?
______________________________________________________________________
______________________________________________________________________

4
 Grade-5, Term3

3. Study the worksheet given below and

answer the following questions:

a. How will you select the cell range A2:B9

and D2:E9?
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
b. How will you select the entire worksheet?
______________________________________________________________________
______________________________________________________________________

F. Who am I? (Identify what is being talked about from the hint given.)
a. I am a useful spreadsheet program. ________________
b. I am a page containing a grid in Excel. ________________
c. I am the bar located at the top of the Excel window. ________________
d. I contain commands to perform formatting and sorting. ________________
e. I am a collection of worksheets. ________________

5
 Grade-5, Term3

Editing Cell Contents in Excel 2013

A. Fill in the blanks with the correct words.

1. The Undo and Redo commands are present on the _________________ Access
Toolbar.
2. To delete cell contents, select the cell(s) and click the _________________ key.
3. The _________________ group on the HOME tab has the options: Cut, Copy and
Paste.
4. Click Insert _________________ rows option in the Cells group on the HOME tab
to insert row(s).
5. The _________________ command in the Cells group on the HOME tab has the
options to change row height and column width.

B. Write T for the true statement and F for the false one.
1. To repeat the action that you undid, click the Redo button on the Quick Access
Toolbar. _____
2. When you cut or copy the cell range, a dotted line appears around the cell range. ___
3. The default column width is 8.43. _____
4. The default row height using the default font is 20 points. _____
5. You cannot change the row height or the column width manually. _____

C. Choose the correct option.

1. Which of the following commands are part of the Cells group on the HOME tab?
a. Insert b. Delete c. Format d. All of these

6
 Grade-5, Term3

2. Which one is not an option in the Delete dialog box?

a. Shift cells up b. Shift cells left c. Entire row d. Shift cells right

3. The key used to select more than one column / row, consecutively is
a. Ctrl b. Shift c. Alt d. Spacebar

4. The Insert menu option used to insert multiple rows is

a. Insert Cells b. Insert Sheet Rows c. Insert Sheet Columns d. Insert Sheet

5. You can edit the data in a cell in the

a. Selected cell b. Formula Bar c. Name box d. Both a. and b.

D. Short Answer Questions.

1. What are the two ways in which you may edit cell contents?
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
2. What is the difference between copying and moving a cell range?
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
3. What are the different ways to copy or move a cell range?
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
7
 Grade-5, Term3

4. What are the four options in the Insert dialog box?

______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
5. What are the default row height and column width in Excel 2013?
______________________________________________________________________
______________________________________________________________________

E. Application-Based Questions.
1. Misha wants to modify the content in cell A2 from ‘Muneeza’ to ‘Muniza’. The data
should be modified only partially.

a. What are the different ways to modify the cell contents partially?
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
b. Can you modify the cell content in the Formula Bar?
______________________________________________________________________

2. Naufil, a computer operator in a school,

entered the data of all the students in a
worksheet as shown here [Fig.i] By mistake, he
missed entries of roll numbers 3 and 4 [Zoha
and Afrah, respectively. See Fig.ii]. What do

8
 Grade-5, Term3

you think Naufil should do?

______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________

3. Amir, an accountant in a departmental store, entered data in a worksheet as shown in

Figure. i. He wants to delete the data in cell range B3: C4 and shift the data in cell range
B5:C6 to cell range B3: C4 as shown in Figure. ii . What are the steps Amir should
follow to make the changes as shown in Figure. ii?

Figure. ii
Figure. i
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________

F. Who am I? (Identify what is being talked about from the hint given.)
a. I am the intersection between a row and column. __________________
b. I am the process of replacing the contents of a cell completely. _________________
c. I am the group containing the Copy option. __________________
d. I am the command that allows you to reverse the last action. __________________
e. I am the keyboard shortcut to redo an action. __________________

9
 Grade-5, Term3

G. Jumbled Words.
Unjumble the letters to form words using the hints given.
a. Letede _______________________
Hint : Key used to remove cell contents
b. Etingdi _______________________
Hint : I am the group in the HOME tab where the Clear button is found
c. Etpas _______________________
Hint : Option used to move data from one place to another
d. Mortaf _______________________
Hint : This menu has the option to change the row height

10
 Grade-5, Term3

First Step to the Internet

A. Fill in the blanks with the correct words.
1. A ________________ is a device that allows a computer to connect and
communicate with other computers.
2. A ________________ is a small USB device that allows you to access the Internet
through a mobile broadband connection.
3. A ________________ is a collection of one or more related web pages, linked
together through a system of hyperlinks.
4. An ________________ is an electronic message sent from one computer to another
which can include text, picture and sound.
5. Do not give your ________________ information to anyone on the Internet without
your parents’ permission.

B. Write T for the true statement and F for the false one.
1. The internet is a huge network of computers around the world. ______
2. Safari is a search engine. ______
3. The World Wide Web is that part of the Internet that no one can access. ______
4. A web page can contain text, graphics, audio, video and links to other pages. ____
5. You should use all caps in your mails or online messages. ______

C. Choose the correct option.

1. The Internet was developed by (the)
a. University of California b. Researchers
c. Department of Defense of the USA d. University of Maryland

11
 Grade-5, Term3

2. The first page of a website is called its

a. Web address b. Web page c. Home page d. Any one of these

3. A highlighted word that on being clicked takes you to another webpage.

a. Hyperlink b. Link c. Address d. All of above

4. A company that allows you to connect to the Internet on payment of a fee is called
a/an
a. URL b. ARPANET c. ISP d. None of these

5. When the mouse pointer is moved over a hyperlinked image or text, the pointer
changes to a ____________ symbol.
a. Arrow b. Hand c. Bucket d. Line

D. Short Answer Questions.

1. What is the World Wide Web?
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
2. Give any two uses of the Internet.
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
3. Mention any three websites that offer you a free e-mail account.
______________________________________________________________________
______________________________________________________________________
12
 Grade-5, Term3

______________________________________________________________________
4. Define Netiquette. Mention any two points you need to keep in mind while on the
Internet.
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
5. Mention any two safety tips you need to be aware of when you are online.
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________

E. Application-Based Questions.
1. Your mother wants to buy books online, but she does not know which are the
websites she can visit for that purpose. Can you help her?
a. What should she do to get website addresses?
______________________________________________________________________
______________________________________________________________________
b. What is the term used for moving from one website to another?
______________________________________________________________________
2. Ghania, a student of Alsan Public School, gets information on homework, test
results, etc. from the school’s website.
a. What does she do to access the school’s website?
______________________________________________________________________

13
 Grade-5, Term3

______________________________________________________________________
_____________________________________________________________________
b. In order to connect her computer to the Internet, which device or devices can she
use?
______________________________________________________________________
______________________________________________________________________
______________________________________________________________________

3. Consider the screen given below for composing an email message. Label the
following:
a. The place to type the E-mail address of the receiver.
b. The place to type the message.
c. The place to type the subject.

F. Who am I? (Identify what is being talked about from the hint given.)
a. I am a huge network of computers around the world. __________________

14
 Grade-5, Term3

b. I am the first computer network in the world which formed the basis of the Internet.
__________________
c. I am a message sent via Internet. __________________
d. I am the process of buying and selling things on the Internet. __________________
e. I am a device that allows a computer to connect and communicate with other
computers. __________________

G. Jumbled Words.
Unjumble the letters to form words using the hints given.
a. Roadbanbd __________________
Hint : Type of Internet access connection
b. Lesseriw __________________
Hint : A type of modem
c. PTLC __________________
Hint : Popular ISP in Pakistan
d. Glenod __________________
Hint: Device used for mobile Internet

15
 Grade-5, Term3

Extension Work
______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

16
 Grade-5, Term3

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________
17
 Grade-5, Term3

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________
18
 Grade-5, Term3

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________
19
 Grade-5, Term3

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________
20
 Grade-5, Term3

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________
21
 Grade-5, Term3

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________
22
 Grade-5, Term3

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________
23
 Grade-5, Term3

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________
24
 Grade-5, Term3

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________
25
 Grade-5, Term3

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

______________________________________________________________________

26