MS-Excel Basic

MS Excel is the spreadsheet program created by Microsoft. A spreadsheet is a grid that organizes data into columns and rows. The various components of MS Excel are name box, formula bar, column letter, row number, active cell and sheet tab. The Excel window that appears on the screen is called a workbook. This workbook has a number of worksheets. A cell is the intersection of a row and a column. The active cell is the highlighted cell in a worksheet. The cell pointer is the highlighted cell boundary that specifies which cell is active at that moment. Name box displays the location of the cell pointer. The formula bar is used to type any data or formulas in the cell. Status bar shows the status of a particular program. Menus and Toolbar provide commands to perform operations on data entered in a worksheet.

There are three types of data that can be entered in Excel. These are numbers, text and formulas. Autosum feature of Excel also provides a quicker and easier way of calculating. Formulas in MS Excel are used to perform calculations. The formula starts with an equal sign. The result of the calculation is displayed in the cell where the formula was entered. Each cell in worksheet has a unique address, when cell address is referred in formulas, it is called cell referencing. These are three types: relative referencing, absolute referencing and mixed referencing. MS Excel files are saved with .xls extension.

To Access the full content, Please Purchase

  • Q1

    Define workbook.

    Marks:1
    Answer:

    A workbook is a spreadsheet file. By default, a spreadsheet has three workbooks.

    View Answer
  • Q2

    What is value in MS Excel?

    Marks:1
    Answer:

    Number and formulas collectively known as value.

    View Answer
  • Q3

    What do you mean by Range of cells?

    Marks:1
    Answer:

    Range of cells is a group of contiguous cells that forms an area rectangular in shape.

    View Answer
  • Q4

    What is cell in MS Excel?

    Marks:1
    Answer:

    Cell is a basic unit of worksheet in which the text is kept.

    View Answer
  • Q5

    What is Spreadsheet?

    Marks:1
    Answer:

    Spreadsheet is a software tool that helps to enter, calculate, manipulate and analyse set of numbers.

    View Answer