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
   111   112   113   114   115   116   117   118   119   120   121