Question

Answer the following Questions:

1. What is a spreadsheet?

2. Name three important features of spreadsheets.

3. Mention any four spreadsheet software.

4. Define a workbook.

5. How is a Formula bar different from Name box?

6. Define cell range in MS Excel.
​

Answer 1

Answer:

*1. A computer program for working with rows of numbers , used especially for doing accounts.*and

*2. Grids, rows, & columns.*

Answer 2

1. A spreadsheet is a computer application for organization, analysis and storage of data in tabular form. Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in cells of a table. an electronic document in which data is arranged in the rows and columns of a grid and can be manipulated and used in calculations.
2. The three important features of spreadsheet are:

• Data management:

Efficient data management facilities may in­clude features for data entry with data validation, rearranging data (sorting), finding and/or extracting a part of the data depending upon the requirement, cutting and pasting, classification of data in the form of frequency tables etc.

• Cell definition:

Cell is the intersection of a row and a column in the spreadsheet. The contents of a cell may be defined with the help of a value (number), label (text), formula, date or time. In case of the need to enter a series of data, electronic spreadsheets facili­tate automatic filling of a range of cells within the series. The user has to define the starting value, the incremental value, the termi­nal value and the range of cells that are to be filled with the series of values.

• Display of data:

Most electronic spreadsheets maintain two layers of data. The first layer contains the data the way they were entered and modified. The other layer of data is for display of values. The display of data is done on the basis of the formatting specifica­tions made by the user.

3. Examples of spreadsheet programs:

• Google Sheets - (online and free).
• iWork Numbers - Apple Office Suite.
• LibreOffice -> Calc (free).
• Lotus 1-2-3 (discontinued).

4. In Microsoft Excel, a workbook is a collection of one or more spreadsheets, also called worksheets, in a single file. Below is an example of a spreadsheet called "Sheet1" in an Excel workbook file called "Book1." Our example also has the "Sheet2" and "Sheet3" sheet tabs, which are also part of the same workbook.Workbooks in the American education system are paperback textbooks issued to students. Workbooks are usually filled with practice problems, where the answers can be written directly in the book.

5. Formula Bar displays the current content of cells and allows you to add in formulas, labels or values into a cell. ... The name box shows the address of the current cell selected or the name of that cell if a special name has been given to it.

6. A cell range in an Excel file is a collection of selected cells. This range is usually symmetrical (square), but can exist of separate cells just the same. A cell range can be referred to in a formula as well.Press F5 or CTRL+G to launch the Go To dialog. In the Go to list, click the name of the cell or range that you want to select, or type the cell reference in the Reference box, then press OK. For example, in the Reference box, type B3 to select that cell, or type B1:B3 to select a range of cells.