ICT NOTES
Q 1.What is spreadsheet?
Answer:
A spreadsheet is a form of row-and-column electronic document. It is utilised to execute calculations
in a methodical manner and save data.
Q 2.Define workbook?
Answer: A workbook is a single file that contains one or more worksheets.
Question 3) How many types of data?
Answer) Text, numbers and formulas are the three main types of data along with pictures,
audio, video and shapes can be entered into a spreadsheet.
Question 4) Define worksheet?
Answer) A worksheet is the working area or page on the screen. A worksheet consists of
rows and columns.
Question 5.)Ms Sharma has saved marks of all students in a spreadsheet. What should she
do to find out three students with the highest total marks?
Answer) she can sort the data on the total marks
LONG
Question 1) Define difference between Worksheet and Workbook?
Answer) A worksheet is the working area or page on the screen. A worksheet consists of
rows and columns. A collection of worksheets is known as a workbook.
Question 2) Describe an active cell?
Answer) The active cell is the one that has been chosen, and it is distinguished by a bold
border. The name box also shows the address of the active cell.
Question 3.
What is filter in spreadsheet software?
Answer:
In order to identify and interact with specific data depending on your specified criteria,
filtering is a quick and easy method. The filter feature allows you to selectively conceal the
data you don’t want to see and only display the rows or columns that satisfy the criteria
you specify.
Question 4.) What is the use of fill handle?
Answer:The Calc fill handle tool is used to automatically fill input in series. It fills the next
cells when we drag it with the next predefined value. For example, if you want to fill the
numbers in sequence of even numbers 2,4,6 …….. or days of the week as Monday,
Tuesday… or month name as Jan, Feb,–.-, we need to enter the first two values, select
them and drag to the next cells to generate the series.
Question 5) Mention two steps in which we can save a workbook.
Answer) Ctrl + S
File → Save
Question 6) What is Cell referencing in a spreadsheet?
Answer) A cell reference identifies a cell or a range of cells. Each cell in the worksheet has
a unique address formed by the combination of its intersecting row and column. When a
cell address is referred to in a formula, it is called cell referencing.
Question 7)Write down the steps to insert picture from file.
Answer) The steps to insert a picture from a file are:
1. Select Insert – From File. ¬ Picture
2. The Insert picture dialog box appears.
3. Select the picture you want to insert and click Open.
Question 1) What is presentation? Name few presentation software.
Answer) Information is displayed in a structured manner through presentation. It consists
of well-organized and.displayed images, words, graphics, music, videos, and animated
objects. Ideas or information can. now be presented in a more compelling, effective, and
efficient manner thanks to the invention of the computer and the development of many
types of presentation software.
There are a variety of presentation software available:
Microsoft PowerPoint . LibreOffice Impress
OpenOffice Impress Google Slides
Prezi Sway
Question 2) Differentiate between Undo and Redo.
Answer) While working in the worksheet, ‘Undo’ command helps the user to reverse the
series of actions and ‘Redo’ helps to reverse the actions that have been executed by the
‘Undo’ action.
Pressing ‘Ctrl + Z’ or by clicking on the ‘Undo’ option from the ‘Edit’ menu or by clicking
on the ‘Undo’ button from the standard toolbar, we can undo. Pressing ‘Ctrl + Y’ or by
clicking on the ‘Redo’ option from the ‘Edit’ menu or by clicking on the ‘Redo’ button
from the standard toolbar, we can redo.
Question 3) Define the advantages of spread sheets?
Answer) Below are the advantages:
Built-in functions make calculations easier, faster, and more accurate.
Large amounts of data can be handled and manipulated with ease.
Data can be exported to or imported from other applications.
Data can be easily represented in pictorial form, such as graphs or charts.
Formulae are automatically recalculated when the underlying data values change
ICT NOTES
Q 1.What is spreadsheet?
Answer:
A spreadsheet is a form of row-and-column electronic document. It is utilised to execute calculations
in a methodical manner and save data.
Q 2.Define workbook?
Answer: A workbook is a single file that contains one or more worksheets.
Question 3) How many types of data?
Answer) Text, numbers and formulas are the three main types of data along with pictures,
audio, video and shapes can be entered into a spreadsheet.
Question 4) Define worksheet?
Answer) A worksheet is the working area or page on the screen. A worksheet consists of
rows and columns.
Question 5.)Ms Sharma has saved marks of all students in a spreadsheet. What should she
do to find out three students with the highest total marks?
Answer) she can sort the data on the total marks
LONG
Question 1) Define difference between Worksheet and Workbook?
Answer) A worksheet is the working area or page on the screen. A worksheet consists of
rows and columns. A collection of worksheets is known as a workbook.
Question 2) Describe an active cell?
Answer) The active cell is the one that has been chosen, and it is distinguished by a bold
border. The name box also shows the address of the active cell.
Question 3.
What is filter in spreadsheet software?
Answer:
In order to identify and interact with specific data depending on your specified criteria,
filtering is a quick and easy method. The filter feature allows you to selectively conceal the
data you don’t want to see and only display the rows or columns that satisfy the criteria
you specify.
Question 4.) What is the use of fill handle?
Answer:The Calc fill handle tool is used to automatically fill input in series. It fills the next
cells when we drag it with the next predefined value. For example, if you want to fill the
numbers in sequence of even numbers 2,4,6 …….. or days of the week as Monday,
Tuesday… or month name as Jan, Feb,–.-, we need to enter the first two values, select
them and drag to the next cells to generate the series.
Question 5) Mention two steps in which we can save a workbook.
Answer) Ctrl + S
File → Save
Question 6) What is Cell referencing in a spreadsheet?
Answer) A cell reference identifies a cell or a range of cells. Each cell in the worksheet has
a unique address formed by the combination of its intersecting row and column. When a
cell address is referred to in a formula, it is called cell referencing.
Question 7)Write down the steps to insert picture from file.
Answer) The steps to insert a picture from a file are:
1. Select Insert – From File. ¬ Picture
2. The Insert picture dialog box appears.
3. Select the picture you want to insert and click Open.
Question 1) What is presentation? Name few presentation software.
Answer) Information is displayed in a structured manner through presentation. It consists
of well-organized and.displayed images, words, graphics, music, videos, and animated
objects. Ideas or information can. now be presented in a more compelling, effective, and
efficient manner thanks to the invention of the computer and the development of many
types of presentation software.
There are a variety of presentation software available:
Microsoft PowerPoint . LibreOffice Impress
OpenOffice Impress Google Slides
Prezi Sway
Question 2) Differentiate between Undo and Redo.
Answer) While working in the worksheet, ‘Undo’ command helps the user to reverse the
series of actions and ‘Redo’ helps to reverse the actions that have been executed by the
‘Undo’ action.
Pressing ‘Ctrl + Z’ or by clicking on the ‘Undo’ option from the ‘Edit’ menu or by clicking
on the ‘Undo’ button from the standard toolbar, we can undo. Pressing ‘Ctrl + Y’ or by
clicking on the ‘Redo’ option from the ‘Edit’ menu or by clicking on the ‘Redo’ button
from the standard toolbar, we can redo.
Question 3) Define the advantages of spread sheets?
Answer) Below are the advantages:
Built-in functions make calculations easier, faster, and more accurate.
Large amounts of data can be handled and manipulated with ease.
Data can be exported to or imported from other applications.
Data can be easily represented in pictorial form, such as graphs or charts.
Formulae are automatically recalculated when the underlying data values change
