Page 116 - IT-802_class_12
P. 116
2. Write a short note on spreadsheet.
Ans. A spreadsheet is a computer application for computation, organization, analysis, and storage of data in tabular form.
Spreadsheets were developed as computerized analogs of paper accounting worksheets. A spreadsheet may also refer to
one such electronic document. A collection of worksheets is known as a spreadsheet.
3. What is a cell?
Ans. A cell is the intersection of a row and column in the worksheet where data is entered by the user. It is identified by its column
letter and row number. An “Active Cell” is a cell that is currently being edited.
4. Write a short note on Formula.
Ans. Formula helps to perform arithmetic calculations and also execute non-arithmetic tasks. It consists of the operands and the
operators that operate upon the data. The formula has to be expressed with the prefix “=” before the operator/data.
5. Define any four components of a spreadsheet.
Ans. Components of a spreadsheet are as follows:
Ð A row is a horizontal arrangement of cells. There are a total of 10,48,576 rows in a single worksheet of Calc.
Ð A column is a vertical arrangement of cells. Columns are labelled from left to right. There are 1024 columns available in
a single worksheet of Calc.
Ð A cell is the intersection of a row and a column in the worksheet where data is entered by the user. It is identified by its
column letter and row number. An “Active Cell” is a cell that is currently being edited.
ÐÐAll the data that is entered by the user appears in the formula bar.
6. Write the steps to select non-contagious cells.
Ans. Select a range of non-contiguous cells.
Ð Select a cell or range of cells.
Ð Move the mouse pointer to the start of the next range or single cell.
Ð Hold down the Control key and click or click-and-drag to select another range of cells to add to the first range.
Ð Repeat the above-mentioned steps as necessary.
7. Write down some of the available spreadsheet formatting options.
Ans. Ð Font name: It contains different font size styles for changing text design.
Ð Font size: The font size of the text can be altered here.
Ð Bold/Italic/Underline: It converts the text to bold or italic text or underlines the text according to the selected option.
Ð Text alignment: It helps one to set the alignment of the line/paragraph to the right, left, or center according to the user’s
choice.
Ð Font color: This option is used to change the font color of the text in the selected cell.
8. What are the advantages of Presentation software?
Ans. The following are the advantages of Presentation software:
Ð It makes our work more expressive and presentable.
Ð It is user-friendly.
Ð It is helpful in conveying our message to large groups of people.
9. 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? [CBSE Sample Paper 2023]
Ans. She can sort the data on the total marks.
10. What is a workbook? Name any one spreadsheet application. [CBSE Sample Paper 2023]
Ans. A workbook is a spreadsheet that has one or more worksheets, e.g., Calc (or any other application)
11. How do you protect your spreadsheet from unauthorised access? Which menu option you will click to protect your
spreadsheet? [CBSE Sample Paper 2023]
Ans. Protect your spreadsheet using a password.
Ð Click on Tools and
select
Ð Protect Spreadsheet
114 Touchpad Information Technology-XII

