Spreadsheet 9th Class IT Notes(in English)

Spreadsheet 9th Class

Question 1. What is a spreadsheet ?

Answer:   Spreadsheet is a computer software that provides the facility to manage and arrange data in the form of Row and Column means as Table. It is also used to make numerical calculations and charts.

Question 2. What are the functions of a spreadsheet?

Answer spreadsheet has the following functions –

  • It performs some kind of calculation and data processing.
  • Sorting and searching can be done quickly and easily of any database.
  • Can create business graphics. Such as charts and graphs.
  • It provides us many functions of mathematics.
  • You can merge the old worksheet into a new worksheet.

Question 3. Write the names of important software in the spreadsheet?

Ans.  Ms-Excel, Open Office, Google Documents

Spreadsheet 9th Class

Question 4. What is the procedure to start Ms-Excel ?

Answer There are two ways to start Ms-Excel

  1. Double clicking on the icon of Ms-Excel on the desktop will open the window of Ms-Excel.
  2. Will click on start button
    1. Click on All Programs.
    2. After this, the window of Ms-Excel will open in the Ms-Office menu.

Question 5. What is Active Cell ?

Answer: The cell inside the cursor is an active cell and it has four borders.

Question 6. What is Row ?

Answer: The horizontal arrangement of the cell itself is called Row. There is 1048576 row inside a worksheet.

Question 7. What are Column?

Answer: Vertical arrangement of cell is called Column. There are 16384 columns inside a worksheet.

Question 7. What is a worksheet inside Excel?

Answer is a collection of Worksheet Cells. Where you can keep your data, you can also manipulate them. All Excel Workbooks have multiple worksheets.

Spreadsheet 9th Class

Question 8. What is a Workbook in Excel?

Answer: The workbook is an Excel file. A workbook has 256 worksheets and By Default it has 3 worksheets.

New worksheets can be added and deleted, and the sheet can also be renamed. Only one worksheet can be worked on at a time, which is called Active Worksheet.

Question 9. What is a cell?

Answer is the smallest and important unit of cell excel document. In which data or information is stored and any kind of calculation can be done on it. Each cell has its own unique address or reference no. it happens. 

A worksheet has 1048576 * 16384 = 17142120448 cells. You can write at most 255 characters in a cell. Each cell has an address. Two cells can also be merged among themselves.

Question 10. What is Formula Bar ?

Answer: It is below Ribbon which shows the data of Active Cell. We also use it to edit data.

Question 11. What is a Scroll Bar?

Answer: Scroll Bar is used to move the page from top to bottom and right to left. There are two types of scroll bar –

  1. Horizontal Scroll Bar
  2. Vertical Scroll Bar

Spreadsheet 9th Class

Questions L2k Ms-Excel files in Open What is the procedure and Save?

Answer: The process of opening and saving files in Ms-Excel is as follows –

Steps to open –

  1. Click on the Office button in the Ribbon bar.
  2. On clicking, you will see a command named Open or you can also press CTRL + O from the keyboard.
  3. Open dialog box will appear.
  4. In this dialog box we will write the name of the file but the file is already created.
  5. After typing the file name, click on open button.
  6. The file will open once you click.

Steps to save –

  1. Click on the Office button in the Ribbon bar.
  2. On clicking, you will see a command named Save or you can also press CTRL + S from the keyboard.
  3. The dialog box of Save will appear.
  4. In this dialog box, we will write the name of the file.
  5. After typing the file name, click on the Save button.
  6. The file will be saved as soon as you click.

9th Class Spreadsheet

Question 13. Write the steps to Addition, Subtraction, Multiplication or Division of Data in Ms-Excel .

Answer: With the help of Ms-Excel, we can do the biggest calculations, among them Addition is one, with Addition we can add two numbers.

 The following procedure is for how to apply Addition –

  1. First open a new spreadsheet.
  2. The number data will be written into the file. For example – A1-20, B2-30, C2 =
  3. Now like we have to add the numbers A1 and A2 in C2, for that we will write FORMULA in C2.
  4. = sum (a1: b2) Press Enter.
  5. The cell containing the formula will be added as soon as you press enter.

Procedure for applying subtraction –

  1. First open a new spreadsheet.
  2. The number data will be written into the file. For example, A1-30, B2-20, C2 =
  3. Now like we have to subtraction the number of A1 and A2 in C2, for that we will write FORMULA in C2.
  4. = sub (a1-b2) Press Enter.
  5. Subtraction of the cell containing the formula will occur as soon as you press enter.

Procedure for applying multiplication

  1. First open a new spreadsheet.
  2. The number data will be written into the file. For example, A1-30, B2-20, C2 =
  3. Now as we have to multiplication of the numbers A1 and A2 in C2, for that we will write FORMULA in C2.
  4. = sub (a1 * b2) Press Enter.
  5. Multiplication of the cell containing the formula will occur as soon as you press enter.

Procedure to apply for Division

  1. First open a new spreadsheet.
  2. The number data will be written into the file. For example, A1-30, B2-20, C2 =
  3. Now like we have to divide the numbers A1 and A2 in C2, for that we will write FORMULA in C2.
  4. = sub (a1 / b2) Press Enter.
  5. The cell containing the formula will be divided as soon as you press enter.

Q14. How to insert and delete Row or Column in Microsoft-Excel ?

Answer: The process of inserting Row or Column in Ms-Excel is as follows –

  1. If we have to insert a column, move the mouse over the column and if we want to insert a row, move the mouse over the row.
  2. Press the right button of the mouse.
  3. On clicking, a popup menu will open.
  4. Click on Insert Column in it, if you want to insert row, then click on Insert Row.
  5. On clicking, the column / Row will be added.

The procedure to delete Row or Column is as follows –

  1. Select the column or row we want to delete.
  2. Press the right button of the mouse.
  3. On clicking, a popup menu will open.
  4. Click Delete in it, if the row is to be deleted, then click on Delete Row.
  5. Clicking on the column / row will be deleted.

9th Class Spreadsheet

Question 15. Write steps to rename the worksheet in Ms-Excel ?

Answer The steps to rename a worksheet in Ms-Excel are as follows –

  1. Ms-Excel has by default 3 sheets.
  2. If you want to rename any sheet, right click the mouse on that sheet.
  3. Right click will open a popup window.
  4. In that, click on the option named Rename.
  5. Now write the name of the sheet there and press enter.

Question 15. Write steps to delete a worksheet in Ms-Excel ?

Answer The steps to delete a worksheet in Ms-Excel are as follows –

  1. Ms-Excel has by default 3 sheets.
  2. If you want to delete any sheet, right click the mouse on that sheet.
  3. Right click will open a popup window.
  4. In that, click on the option named Delete.
  5. The sheet will be deleted as soon as it is clicked.

Question 16. What is the extension to save a file in Ms-Excel ?

Answer * .xlsx

To More Content about spreadsheet – Click Here