IT 1

Question 1

spreadsheet

Answer 1

A spreadsheet is an electronic document, which has
rows and columns. It is used to store data in a systematic
way and do calculations.

Question 2

row

Answer 2

A row is an arrangement of cells in a horizontal
(sleeping) manner.

Question 3

coloumn

Answer 3

A column is an arrangement of cells in a vertical
(standing) manner.

Question 4

cell

Answer 4

A cell is a rectangle shaped box, where the row and
column meet. You can enter text, numbers, date,
formula, etc., in a cell.

Question 5

formula
bar

Answer 5

Whatever you type in, a cell
appears in the area called formula
bar

Question 6

name box

Answer 6

The name box shows the
location of the selected cell.
The location of the cell is a
combination of column and
row.

Question 7

worksheet

Answer 7

A worksheet is a collection of cells in the form
of a grid (a network of lines that intersect each
other, making rectangles).

Question 8

workbook

Answer 8

A workbook is a spreadsheet that has one or
more worksheets.

Question 9

active cell

Answer 9

After selecting multiple cells, a function
will be performed on the cells that are selected. When
a single cell is selected it is called active cell.

Question 10

cell range

Answer 10

number of cells is selected, it is called cell range

Question 11

to put filter

Answer 11

Click on the
the Tool Bar.
AutoFilter icon on
2. This will put filters at the top of each
column as shown

Click on the filter for ‘class’ column.

Question 12

password for spreadsheet

Answer 12

• Click on Tools and select
  Protect Spreadsheet
• Protect Document in dialog box
• Type the same password in the
  Confirm textbox
• Click on OK.

Question 13

There are a number of presentation software available,
such as

Answer 13

1. LibreOffice Impress
2. Microsoft Office – PowerPoint
3. OpenOffice Impress
4. Google Slides
5. Apple Keynote