ICS FA Notes Computer Science Part 1 Chapter 9 Spreadsheet Short Questions

ICS FA Notes Computer Science Part 1 Chapter 9 Spreadsheet Short Questions 1st Year Notes Online Taleem Ilm Hub

If you want to view other notes of Computer Part 1 Please Click Here.

Q 1: Define Spreadsheet.

Ans: A spreadsheet is an application program. It provides worksheets to enter and process data. In a worksheet, data is arranged into rows and columns just like a table. MS-Excel is an example of spreadsheet program.

Q 2: List the features of spreadsheet program?

Ans: The basic features of spreadsheet program are as follows:

1. Grid of Rows and Coulums
2. Formulas
3. Functions
4. Commands
5. Text Manipulation
6. Creating Chart in Excel
7. Printing

Q 3: List some uses or applications of spreadsheet?

Ans: Some uses / applications of spreadsheet are as follows:

1. It is used for analyzing all types of data such as financial, inventory, laboratory etc.
2. It is used for creating charts.
3. It is used for preparing home budgets.

Q 4: List three benefits of spreadsheet?

Ans: Three benefits of spreadsheet are as follows:

1. In spreadsheet information can represented in rows and columns.
2. Spreadsheet has the ability to perform calculations on the numerical data.
3. It provides facility to present data in graphical form. It means that different types of charts ( or graphs) can be made from the numerical data.
4. Spreadsheet provides method for analyzing all types of data ( such as financial, inventory, laboratory etc.) and producing high quality graphics.

Q 5: What is worksheet?

Ans: A spreadsheet program provides worksheets to enter data. A worksheet consists of rows and columns. In Excel, a worksheet consists of 256 columns and 65536 rows. The columns are labeled with letters A, B, C, ... etc. The rows are labeled with numbers 1, 2, 3, 4, ... etc.

Q 6: What is workbook?

Ans: In MS-Excel, the document or file in which data is permanently stored on the disk is called workbook. It is a collection of worksheets. Like a book that contains many pages, a workbook may contain many worksheets. Data is stores into the worksheets.

Q 7: Differentiate between worksheet and workbook.

Ans: A worksheet consists of rows and columns. Data is entered in worksheet. A workbook is a file of document. It is a collection of worksheets.

Q 8: What is Microsoft Excel?

Ans: Microsoft Excel is most popular spreadsheet program. It allows to perform various calculations on numeric data, and creating charts etc.

Q 9: What is a cell and cell address?

Ans: The intersection of a column and a row is called a Cell. The data is entered into the cells of worksheet. A cell address identifies the location of cell in the worksheet. For example, the cell located at column number three and row number 6, is represented as C6.

Q 10: What is active cell?

Ans: The currently selected cell where data can be entered or edited is called the Active Cell. When another cell is selected or cell pointer is moved to another cell, then that cell becomes the Active Cell.

Q 11: What is a column header?

Ans: A horizontal bar that has headings of columns with labels A, B and so on (It is from A to IV) is called Column Header.

Q 12: What is row header?

Ans: A vertical bar that has headings of rows with labels 1, 2, 3, and so on ( It is from 1 to 65536) is called Row Header.

Q 13: What is the use of formula bar in Excel interface?

Ans: When a formula is used into a cell, then the calculated result is displayed into the cell. The actual formula is displayed into Formula Bar. If a formula is not applied into the cell, then the contents of cell are displayed into the Formula bar. Formula bar is also used to edit the contents of cell.