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.
