View latest educational results 2026 of class 9th, 10th / Matric / SSC, Intermediate / HSSC / FA / FSc / Inter, 5th / Primary, 8th / Middle, DAE, DBA, D.COM, BA / BBA / BCom / BSc / B.Ed, MA / MSc / MBA / MIT / MCS, MBBA / M.Ed, LLB, Engineering, M.Phil, PhD from all BISE / boards and Universities by roll number & by name and check old result 2025 online.

Chapter 9 Spreadsheet Computer Science 11th Class Punjab Short Questions

Question No. 1 - What is Active Cell?

Answer No. 1 - Active cell is also referred to as cell pointer or selected cell. An active cell refers to a cell in excel spreadsheet that is currently select by clicking mouse pointer or keyboard keys. Remembers only one cell cab be active cell at a time.

Question No. 2 - What is Relative cell?

Answer No. 2 - Calling cells by just their address Such as A1 is called relative referencing and it is copied from one cell to an other, the spreadsheet does not create an exact copy of the formula.

Question No. 3 - What are function in MS-Excel?

Answer No. 3 - Function are build in formulas used to perform complex operation. Function can be used in formula. Functions can be more difficult way to performing mathematical operations their formula.
Example: Sum, Average, Max.Min, Sort etc.

Question No. 4 - Define Worksheet.

Answer No. 4 - In the document window the document is displayed. In a spreadsheet you can actually work in a grid of rows and column called worksheet.

Question No. 5 - What is 3D-Sheet?

Answer No. 5 - The work book could contain just one work sheet. New spread sheet are related as 3D work sheet which are like a pad of worksheets. It is due to this feature that the data in one worksheet can be used for calculation performed in another worksheet of the same or a different workbook.

Question No. 6 - What is mean by Cell Reference?

Answer No. 6 - A cell reference tells formula to look up the content of the referenced cell. This increase the flexibility of the formula.

Question No. 7 - List any two benefits of spread sheets.

Answer No. 7 - The facility of spread sheet make calculation easier to understand by displaying stages of development of a sum with the ability to write not explaining each line. Templates containing formulas for regularly used spreadsheets increase productivity by removing the word for highly operators.

Question No. 8 - Write a formula to add five cell in a row in MS-Excel.

Answer No. 8 - Formula =A1+A2+A3+A4+A5
Function =SUMA1:A5

Question No. 9 - How formula is used in MS Excel?

Answer No. 9 - Formula are entered in the excel worksheet cell an must begin with an equal sign "=", the formula is written in the formula bar:
Example:
=A1+A2

Question No. 10 - Write function that totals cell B3 through B10.

Answer No. 10 - Function :
=SUMB3:B10

Question No. 11 - What do you understand by the term of named ranges?

Answer No. 11 - Named ranged: are names that you define present a cell or cell range on a worksheet.

Question No. 12 - Can you enter data in passive cells?

Answer No. 12 - No we can not enter data in passive cells. For entering data firstly select a cell then selected cell is called active cell.

Question No. 13 - What is cell?

Answer No. 13 - Cell is the basic unit where data is entered in a work sheet. The data can be take variety of forms i.e text, numbers, dates and formulas. The cell can also hold graphics, audio files and video or animation.

Question No. 14 - What is Spread Sheet?

Answer No. 14 - Spread Sheet: A spread sheet program is a software tool for entering, calculating, manipulating and analysing set of numbers. The specially of spread sheet software is working with numbers. It can hold large amount of data arranged in rows and column.

Chapter 9 Spreadsheet Computer Science 11th Class Punjab Short Questions

Computer Science

11th Class Punjab Short Questions

11th Class Online Classes 2026

11th Class Online Preparation

11th Class 2026 Online

11th Class 2026