Class 11 Computer Science Chapter 9 Notes
Important Notes of complete Class 11 Computer Science Chapter 9 Notes written by Professor Mr. Faraz Qasir Suib. These notes are very helpful in the preparation of Class 11 Computer Science Chapter 9 Notes of for the students of the intermediate and these are according to the paper patterns of all Punjab boards.
Summary and Contents:
Topics which are discussed in the notes are given below:
- Describe Basic Features of Spreadsheet Software.
- A Spreadsheet program is a software tool for entering, calculating, manipulating and analyzing sets
of numbers. The specialty of spreadsheet software is working with numbers. This can hold large
amount of data arranged in rows and columns. It can manipulate numbers and present information in
numerous ways. Like Word Processors, the Spreadsheet software also varies significantly e.g.
LOTUS 123, Quatro Pro and MS Excel etc. But all of them have following basic features :
The spreadsheet is a grid of rows and columns. Each row is assigned a number and each column a
letter. The intersection of a row and a column forms a cell. Each cell has a reference number that is
formed by combining the column number and row number e.g. A1, G18 etc. A cell contains labels or
values. A label is a text entry such as “Gross Salary” whereas a value can be a number, a date, a
formula or a formula’s result.
- Describe Common Forms of Data Entered in a Cell.
- Describe Cell References and Ranges.
- Describe Relative and Absolute Cell Referencing.
- Explain Named Ranges of Cells in MS Excel.
- Entering Data in a Worksheet
- Cell is the basic unit where the data is entered in a worksheet. The data can take variety of forms i.e. text, numbers, dates, and formulas. The cell also can hold graphics, audio files, and video or animation files. There are two states of a cell ie. active and passive. Before entering data, the cell must be activated. Using the mouse or arrow keys, you can select a cell to make it active. A bold rectangular border indicates an active cell. Every cell in the worksheet has an address (figure 9.1). When a cell is selected you can enter data by simply typing on the keyboard. You can also enter the data in an active cell through the formula bar. Similarly you can edit the contents of a cell in the formula bar. When a cell containing a formula is activated, its formula appears in the formula bar, which you can edit there. Like word processors, the basic operations of cut, copy and paste work in the same way here in Worksheets. You can move data between the worksheets of the same or different workbooks by using these operations.
- Basics of Worksheet: As it has been discussed that the data entered in a cell can take variety of forms but the most common of these are:
- Labels (Simple text)
- Values (numbers)
- Labels are used to identify a value or a series of values. Labels are helpful in making the worksheet meaningful. It is important to note that formulas can be applied only on values; these cannot be applied on labels. Values are just numbers that you enter in different cells of a worksheet. These can be whole numbers, decimals, negative numbers, currency and other types of values including scientific notations. Working with Formulas is the most powerful feature of a spreadsheet. Formula can be calculated on the basis of values or formulas in other cells. Formulas can involve basic arithmetic operators. More complex formulas can even evaluate logical conditions and perform certain calculations on the basis of the result of the evaluation. Conditions may evaluate to true or false.