9th Class Spreadsheet Short Answer Questions [CBSE]

In this page, I will explained short answer type questions of 9th Class Spreadsheet (Electronic Spreadsheet) unit. In this, you will learn all types of questions answers related to Electronic Spreadsheet. These questions are very important for IT(Information Technology) Exam under CBSE and Haryana Board. These questions will prove to be very good for your exam.

9th Class Spreadsheet Short Answer Type Questions

Q:-    What is Spreadsheet Software?

Ans:-   Spreadsheet is a computer software that provides the facility of managing, arranging data in the form of a table, meaning in the form of Row and Column. It is also used for numerical calculations and chart making.

Q:-    Write the name of Spreadsheet Software.

Ans:- Ms-Excel, Open Office Calc, Google Documents

Q:-    What is Active Cell ?

Ans:- The cell inside which the cursor is there is an active cell and it has a border around it.

Q:-    What is Row and Column?

Ans:- Row -The horizontal arrangement of the cell is called row, there is 1048576 row inside a worksheet.

Column –  Vertical arrangement of cells is called column. There are 16384 columns inside a worksheet.

Q:-    What is Worksheet in Excel ?

Ans:- Worksheet is a collection of cells. Where you can keep your data, along with this you can also manipulate them. All Excel Workbooks have Multiple Worksheets.

Q:-    What is Workbook in Excel ?

Ans:- A workbook is an Excel file. A workbook has 256 worksheets and by default it has 3 worksheets. In this, new worksheets can be added and deleted and sheets can also be renamed. Work can be done on only one worksheet at a time which is called Active Worksheet.

Q:-    What is Cell ?

Ans:- Cell is the smallest and most important unit of Excel document. In which data or information is stored and can be calculated in any way.

Q:-    What do you mean by range of cells ?

Ans:- Range of cells is group of one or more contiguous cells that forms a rectangular area  in shape. A range is specified by giving the addresses of first cell and the last cell of the range separated by some symbol characters. E,.g. A5:B10

Q:-    Give some applications areas of electronic spreadsheet.

Ans:- One of the most common uses of spreadsheets is financial planning and budgeting. Some of the business applications associated with spreadsheets are listed below :

  1. Budgets
  2. Annual Reports
  3. Portfolio Analysis
  4. Accounts payable and receivable
  5. Production schedules
  6. Invoices
  7. Income statements
  8. Loan Analysis
  9. Tax statements

9th Class Spreadsheet Short Answer Type Questions

Q:-    What is the default alignment of number, text and formula in a spreadsheet ?

Ans:- Default alignment of text or label entry is left alignment and for numbers and formula it is right alignment.

Q:-    What do you mean by Cell referencing and what are different types of cell referencing ?

Ans:- Each cell in worksheet has a unique address, when cell address is referred in formulas, it is called cell referencing. These are of three types:

  • Relative referencing
  • Absolute referencing
  • Mixed referencing
  • Relative Referencing – Cell referencing in which the cells are referred by their relative position in the worksheet – relative to a particular cell.
  • Absolute Referencing – cell referencing in which the cells are referred by their fixed position in the worksheet.
  • Mixed referencing – combination of relative and absolute referencing is called mixed referencing.

Q:-    Why is formatting necessary ?

Ans:- Formatting means the general arrangement of data. With formatting, we can make some data to appear bolder, rotated or in different colour. So, basically formatting provides worksheet a neater and more legible outlook.

Q:-    What is conditional formatting ? Give example.

Ans:- Conditional formatting is a specific type of formatting where we can set up cell formats to change depending on conditions what we specify. For example, in a table of numbers, we can show all the values above the average in green and all those below the average in red, using conditional formatting.

Q:-    Can you print hidden data from a worksheet ? Can you copy them?

Ans:- when elements are hidden, they are neither visible nor printed, but can still be selected for copying if we select the elements around them. For example, if column B is hidden, it is copied when we select columns A and C.

Q:-    What do you understand by sorting of Data? What is the significance of sorting of data?

Ans:- Sorting is the process of arranging data into meaningful order so that we can analyze it more effectively. For example, we might want to order sales by calendar month so that we can produce a graph of sales performance. We can sort data as follow :

  • Sort text data into alphabetical order
  • Sort numeric data into numerical order
  • Group sort data to many levels, for example, we can sort on City with in Month within Year sorting worksheet data also makes it easier to analyze.

Q:-    What are different ways of inserting an image in Calc ?

Ans:- Images can be inserted in Calc using any of the following ways : (a) From a File (b) by using drag and drop (c) from Gallery (d) Through Clipboard

9th Class Spreadsheet Short Answer Type Questions

Q:-    What does the ‘Crop’ tool do ?

Ans:- The crop tool is useful tool that allows us to select and use part of an image by cutting unrequired portion around the edges.

Q:-    When using a word processing package, what all features of an image/graphic can you change?

Ans:- We can change one or more or even all of the following features of inserted graphic/images

  • Colour
  • An outline
  • A ‘shadow’
  • Filled area
  • Background
  • Alignment
  • Order

Q:-    Write the steps to change name of Worksheet in Spreadsheet?

ANs;-          The default name of a worksheet is Sheet1 and the steps to rename it are as follows –

1. Spreadsheet consists of By Default 3 Sheets.

2. If you want to rename any sheet, then right click of the mouse on that sheet.

3. A Popup Window will open as soon as you right click.

4. Click on the option named Rename in it.

5. Now write the name of the sheet there and press Enter.

Q:-    Write the steps to insert and delete sheet in excel?

Ans:-           The steps to insert a worksheet into a spreadsheet are as follows-

  1. By Default 1 Sheets is there in Calc.
  2. If you want to insert a new sheet, then right click of the mouse on that sheet.
  3. A Popup Window will open as soon as you right click.
  4. In that you click on the option named Insert Sheet.
  5. Sheet will be inserted as soon as it is clicked.

The steps to delete a worksheet in a spreadsheet are as follows –

  1. There is By Default 1 Sheet in Calc.
  2. If you want to delete any sheet, then right click of the mouse on that sheet.
  3. On right clicking, a popup window will open.
  4. In that you click on the option named Delete Sheet.
  5. Sheet will be deleted as soon as it is clicked.

Q:-    How to create a new spreadsheet ?

Ans:- The steps to create a new spreadsheet are as follows –

  1. First go to the File menu
  2. After that click on NEW.
  3. Then click on Spreadsheet Option.
  4. On clicking, a new file will be created

Q:-    Write any two operations on the data in the Spreadsheet.

Ans:- With the help of Spreadsheet, we can do the biggest calculations, one of them is Addition, we can add two numbers together with Addition.

 Following is the process for how to apply the addition –

  1. First of all open a new spreadsheet.
  2. Will write number data in the file. Such as – A1-20, B2-30, C2=
  3. Now like we have to add the numbers of A1 and A2 in C2, then we will write FORMULA in C2 for that.
  4. =Sum(A1:B2) Press Enter.
  5. On pressing Enter, the cell containing the formula will be added.

Procedure to apply Subtraction –

  1. First of all open a new spreadsheet.
  2. Will write number data in the file. Such as – A1-30, B2-20, C2=
  3. Now like we have to do subtraction of numbers of A1 and A2 in C2, then we will write FORMULA in C2 for that.
  4. =Sub(A1-B2) Press Enter.
  5. Subtraction of the cell containing the formula will happen as soon as you press Enter.

Q:-    What is Relative and absolute cell referencing in Excel ?

Ans:- Relative Reference :- By default, all cell references are relative references. When copies are made across multiple cells, they change depending on the relative position of the rows and columns. For example, if you copy the formula =A1 + B1 from row 1 to row 2, the formula will become =A2 + B2.

Absolute Reference :- There may be times when you do not want to change the cell reference while filling the cell. Unlike relative references, absolute references do not change when copied or filled. You can use an Absolute Reference to keep a line constant. You would typically use the $A$2 format when creating formulas with absolute reference. The other two formats are used much less frequently.

9th Class Word Processor Short Answer Questions [CBSE] 

10th Class Spreadsheet Short Answer Questions [CBSE] 

Conclusion

In this post you have read Short Answer Type Questions of 9th Class Spreadsheet (Electronic Spreadsheet Unit). . If you want to ask about any question and answer other than this, then you can ask us by commenting in the comment box given below

Leave a Reply

Your email address will not be published. Required fields are marked *