PSEB 12th Class Computer Science Book Solutions in English Medium 2025

 Punjab School Education Board

Class 12 Computer Science (2025-26)

Dear students, Sat Shri Akal. In this article, you can repeat the exercises of all the lessons of Computer Science of Class 12. You can note the exercises of these lessons by clicking on the links of the related lessons given below.

Computer Science

Class :- 12th

Lesson – 1 Office Automation and Typing

1._______ is a word processor software.

a) MS Windows b) MS Excel c) MS PowerPoint d) MS Word

2. _____ key is used to check spelling and grammar.

a) Ctrl+F7 b) Alt+F7 c) F7 d) Shift+F7

3. _____ option in MS Word changes the structure and layout of the page.

a)Format b) Print and Page Preview c) Page setup d) Proofing

4. _______ is an electronic spreadsheet software, which is used for automatic calculations.

a) Ms Windows b)Ms Excel c) Ms PowerPoint d)Ms Word

5. _____ refers to changing font style, size, color, bold, italic, underline and other related parameters.

a) Formatting b) Alignment c) Proofing d) Filtering

Fill in the blanks

1.____ and ____ functions are used to find the minimum and maximum values ​​in a range?

Answer: Min and Max

2. The filter option is available in the ____ tab of Excel.

Answer: Data

3. If the cursor is placed at the end of the file, the _____ button is used to delete the text.

Answer: Backspace

4. The two orientation options for page setup are ____ and ____.

Answer: Portrait and Landscape

5. _____ symbol is used to start any formula in Excel calculations.

Answer: =(equals)

Questions with very short answers

Question 1: Write the full name of WYSIWYG?

Answer:-What you see is what you get

Question 2: Write the shortcut key to move text in a Word document?

Answer:- CTRL+X, CTRL+V

Question 3: Write the names of four types of alignment?

Answer:- LEFT, CENTER, RIGHT, JUSTIFY

Question 4: Which Excel function is used to combine parts of different cells into one cell?

Answer:- CONCATENATE()

Question 5: Write the names of any two fonts that can be used to type in Punjabi language?

Answer:- Anmollipi, Raavi,Joy, Asses

Write shortcut keys

1. To copy: Ctrl+C

2. To paste: Ctrl+V

3. To bold: Ctrl+B

4. To underline: Ctrl+U

5. To center align: Ctrl+E

6. To justify alignment: Ctrl+J

7. To double line spacing: Ctrl+2

8. To replace: Ctrl+H

9. To print: Ctrl+P

10. To check spelling and grammar: F7

Questions with short answers

Question 1: What is Excel?

Answer:- MS Excel is a powerful spreadsheet program that allows you to store data, perform calculations, present results, create graphs, generate professional-looking reports, publish data on websites, and access real-time data.

Question 2: Explain formatting in detail?

Answer:- Formatting text means changing the font style. The basic functions include increasing and decreasing the font size, changing the color of the text, making the text bold, italic, underlined, etc. Through formatting, we can change the appearance of the text.

Question 3: Explain the print and print preview options?

Answer:- Print preview is a feature that shows how the document will look before printing it on paper. Through the print command, we can print the document by setting the printer selection, paper size, page orientation etc.

Question 4: What are formulas in MS Excel?

Answer:- In MS Excel, we can perform calculations involving school results, grading, and student fees etc. using formulas. Formulas always start with the “=” (equal) sign.

Examples of formulas:-

1. =D12+ D13

2. =A4- A 5

3. =C5+D6*A2

Question 5: What do you know about the formula bar in Excel?

Answer:- The formula bar is one of the most important parts of MS Excel. The formula bar is present at the top of the Excel window and below the ribbon. The formula bar has two parts: the first part is the name box that displays the address of the cell and the second part is the function that displays the typed data or formula.

Question 6: What are margins?

Answer:- A margin is the space or empty space between the text and the edge of the document. The margin of a new document is set to normal, and it has four parts: top margin, bottom margin, left margin, right margin. These four margins are set to one inch in the document, which we can also change according to our needs.

Questions with long answers

Question 1: What are word processors? Tell us about their use?

Answer:- A word processor is an application software that allows the user to create, edit, print documents. Word processors enable us to write text, store data electronically, display data on the screen, and edit and print by entering instructions and characters from the keyboard.

Word processor software is used for the following tasks:-

·        To prepare various types of documents, correspondence, etc.

·        To format documents

·        To create letterheads for personal and business purposes

Question 2: Describe the proofing options in MS Word?

Answer:- MS Word can also check the document to highlight the errors in the document, whether the comma (,) is used incorrectly or the correct word is not used incorrectly. Proofing option has been provided for this. Proofing option appears in the status bar of Word when there is any error in the document. Proofing option provides us with commands like auto-correct and spelling and grammar check to correct the errors in our document.

1. Auto-correct:- In MS Word, we can correct some text in our document due to spelling error while typing, it can be corrected through auto-correct option. The auto-correct option already includes many misspelled words and their correct words and whenever a word is misspelled while typing, auto-correct reads that word and replaces it with the correct word.

2. Spelling and Grammar Check:- MS Word also provides the facility to check spelling and grammar errors in the document. It shows a red wavy line under the words with spelling errors, a green wavy line under the text with grammar errors and a blue wavy line for formatting errors. Function key 7 is used to check spelling and grammar in the document.

Question 3: Explain the page setup and printing options available in Excel?

Answer:- Through page setup in Excel, we can present our spreadsheet in a better way. Excel gives us many options to set up our page. The following commands are used in the Page Setup group of the Page Layout tab:-

1. Margins:- This can be used to select one of the three preset margins for generating a report or to set custom margins from the Margins tab of the Page Setup dialog box.

2. Orientation:- This is used to change the page to portrait or landscape mode for printing.

3. Size:- The Size option is used to select one of the preset paper sizes, set a custom size, or change the page number, etc.

4. Print Areas:- This option is used to set or remove the print area.

5. Breaks:- This is used to apply or remove page breaks.

6. Background:- The Background option can be used to insert a new graphic or photo to use a new background in the worksheet.

7. Print Title:- This option can be used to repeat the row number of the worksheet and the column title on each page in a report.

Question 4: What are functions in Excel? Explain any two functions with examples?

Answer:- A function provides an automated method to create formulas. A function is a predefined formula, which performs calculations using specific values ​​in a specific order. Functions such as SUM, AVERAGE, COUNT, MAX, and MIN are used in MS Excel.

1. SUM:- The SUM function in Excel returns the sum of the supplied values. The SUM function adds the values. In this we can include value, cell address or range of cells.

Syntax:- =SUM(Value 1, Value 2, Value 3,……)

Example:-

2. COUNT:- The COUNT function in Excel counts the cells, which contain numbers and counts the numbers in the list of arguments. The number of entries in a number field can be obtained using the COUNT function.

Syntax:- =COUNT(Value 1, Value 2, Value 3,……)

Example:-

Question 5: Tell about the different methods of typing?

Answer:- Two methods are used for typing:-

1. Touch typing:- Touch typing is a technique through which we can learn to type step by step with all the fingers without looking at the keyboard. If we keep searching for the keys on the keyboard while typing, then as a result our typing speed will be very slow. Any typing software can be used to learn this technique.

2. Voice Typing:- This is a kind of speech recognition program, which converts the words spoken by the user into written/alphabet language.

Lesson – 2 Control Statement in C

Multiple Choice Questions

1. Which of the following statements is called a conditional statement.

a) for     b) break              c) if        d) while

2. Switch-case is a type of statement.

a) if-else             b) if else if         c) break              d) goto

3. In switch statement, __ is used to terminate the case.

a) continue        b) goto                 c) if                       d) break

4. Which of the following is an example of post test loop?

a) for                    b) while               c) do-while       d) continue

5. Which of the following is not a jumping statement?

a) do-while       b) continue        c) goto                 d) break

Fill in the blanks

1. In _____ loop, some condition is tested before the body of the loop.

Answer:- Pre-test loop

2. In _____ loop, control is tested after the body of the loop.

Answer:- Post test loop

3. ______ statement is used to skip some statements in the loop.

Answer:- continue

4. ______ is a multi-way control statement.

Answer:- switch-case

5. break statements are used to terminate the choice in ______ statements.

Answer:- switch

Very short answer questions

1. What is the act of writing an if statement inside another if statement called?

Answer:- Nested if

2. Which statements are used to change the normal flow of programs in C language?

Answer:- Branching control statement

3. Which statement is often useful to skip some statements inside a loop?

Answer:- continue

4. Which statements repeat commands?

Answer:- goto

Short Answer Questions

Question 1: Define branching? Write the names of its different control statements?

Answer: The statements that select one branch or another branch during the execution of the program are called branching statements. These statements are used for decision making tasks or to select one out of more than one.

Branching statements are further divided into two parts:-

1. Conditional Control Statement

2. Multi-Way Conditional Control Statement

Question 2: What is looping? Write the names of three different types of looping statements?

Answer: Looping statements are also called iterative statements. There may be situations in programs when we need to execute a block of statements multiple times. In such situations, loops provide us with a way to repeat statements and they also control how many times the statements will be repeated.

The different types of looping statements are as follows:-

1. For loop

2. While loop

3. Do while loop

Question 3: What is a nested if statement? Write its Syntax?

Answer: When another if condition or if else condition statement block is used in the statement block of an if condition, then it is called a nested if statement. Thus we can say that the block of the inner if statement will execute when both the condition of the outer if statement and the condition of the inner if statement are true.

Syntax-

if(expression or condition1)

{

/*Execute when condition1 is true*/

if(expression or condition2)

{

/*Execute when condition2 is true*/

Block1 of statements;

}

}

Question 4: What is if else statement? Write a program for if else statement?

Answer: We can also control the execution status of the statement through if else statement. When we have to make a decision based on two or more conditions, or we have to do some specific work from the program, then we use if else statement. In this, if the if condition is true, then if block is executed, and else part is skipped. And in case if statement is false, only else part is executed.

#include<stdio.h>

void main()

{

int a=20, b=10;

if(a>b)

{

printf(“a is greater than b”);

}

else

{

printf(“a is less than b”);

}

getch();

}

Question 5: What is the While statement? Write its structure?

Answer: While loop is a pre-test loop, and this loop is used to repeat a statement repeatedly. The While keyword of the language is used for this loop. In the While loop, only the test condition is defined, the initial part of the loop is defined before the While loop, and the step size of the loop is declared inside the While () loop.

Syntax of While () loop:-

Variable declaration;

Variable initialization;

while(test condition)

{

Statement block;

Step size;

}

Long Answer Questions

Question 1. What are control statements? Write their types?

Answer: A computer program is a collection of instructions or statements, which are used to make the computer perform a specific task. These statements are executed one after the other in the order written in the program. This order of statement execution works well for simple problems, where no decision-making process is involved. But sometimes the order of execution of these statements needs to be changed or a group of statements needs to be repeated until a specific condition is met. The statements using which we can control the flow of execution of the program are called control statements.

Types of Control Statements:-

1. Branching Control Statement

2. Looping Control Statement

3. Jumping Control Statement

Question 2. What is Switch Statement? Write a program for Switch Statement?

Answer: When we use more than one condition in a program, the program becomes complex, due to which the program becomes difficult to read and understand, to avoid this problem we have to use Switch case control statement. Switch case is similar to if else if statements, it depends on us which statement we use. Switch statement is more efficient statement and it is easy to read. In switch case, the group of statements is executed only when only the related case constants are true. When all the case constants are false, the control comes to the exit point and executes it.

Switch Statement Program-

#include<stdio.h>

Void main()

{

char day = ‘D’;

switch(day)

{

case ‘A’:

printf(“Monday”); break;

case ‘B”:

printf(“Tuesday”); break;

case ‘C’:

printf(“Wednesday”); break;

case ‘D’:

printf(“Thusrday”); break;

case ‘E’:

Printf(“Friday”); break;

Case ‘F’:

printf(“Saturday”); break;

default:

printf(“Day is not found”); break;

}

getch();

}

Question 3. What are loops? What are the two different categories of loops?

Answer: Looping statements are also called iterative statements. There may be situations in programs when we need to execute a block of statements multiple times. In such situations, loops provide us a way to repeat statements and they also control how many times the statements will be repeated.

Types of Loops:-

1. Pre-Test Loop

2. Post Test Loop

Question 4. What are jumping statements? Describe their types?

Answer: Jumping statements are used in C programming to change the normal flow of a program. Using these statements, we can transfer the control of the program from one place to another.

Types of jumping statements:-

1. Break statement

2. Continue statement

3. Goto statement

Question 5. What is a do while loop? How is it different from a while loop?

Answer: This loop used in C language is called a post test loop. In this loop too, we need all three parts of the loop: the initial part of the loop, the test condition and the step size of the loop. The special feature of this loop is that in it the condition is checked at the end. That is, whenever we want to execute the statement block of the loop at least once in our program, we will use this loop.

Do while loop is a post test loop, while while loop is a pre test loop. In while loop, the condition check is done first and only if the condition is true, the body of the loop is executed, while in Do while loop, the body of the loop is executed first and then the condition check is done. In Do while loop, whether the condition is true or not, the body of the loop is executed once.