Type The Following Data In Spreadsheet And Save It As Second

Questions

Perform the following task in librewriter: • Make the three blank pages where 1st and 3rd pages are in portrait orientation and 2nd pages is in landscape orientation. • Give the different header and footer within a document for each page. • Set the watermark compute operator • Save your document with password to open

(a) In Spreadsheet, Enter the following data. (b) Calculate DA as 80% of Basic Pay and HRA as 10% of basic pay + DA. (c) Find out Net Salary (giving the deductions of Insurance 10% of Basic pay and P.F. 5% of Basic pay). (d) Find out the Highest and lowest Salary of the Employee. (e) Calculate the total Insurance collected from all the employee. (f) Apply two decimal notations to all the numeric values.

O Level Practical Viva Questions Answers

Create 3 Slides using different slide layouts - describing about your College.

Create 4 Slides on annual day of your college and perform the following: A) Give Header and Footer B) Give Background Color C) Insert Picture from Clip Art D) Insert Slide Numbers

The following are the marks obtained by the students of B.Com in three subjects: Using Conditional Formatting list out students who scored A) Less than 50 in QT B) More than 65 in FIT C) Between 60 and 80 in Accounts.

The following are the salaries of five employees: Using Conditional Formatting, list out employees who got A) Less than Rs. 15000 as salary B) More than Rs. 700 as Part time C) Between Rs. 1600 and Rs. 1800 as Arrears.

Create your BIO data in LibreOffice Writer.

Create 4 slides on annual day of your college and perform the following: i) Give Header and Footer ii) Give background color iii) Insert Picture from clip art iv) Insert Slide number v) Insert animation effect  Link first slide with the third

The Ministry of health has appointed you as an educator. You are required to give a talk on “Role of Sex Education in Schools” You are required to: (a) Design three slides as follows: (i) Slide I - Should have the introduction of the Topic. (ii) Slide II - Should have the content of the Topic. (iii) Slide III- Should have relevancy of sex education in schools. (b) Include your name and Personal number at the end of each slide. (c) Save your presentation as “My Slide” (d) Use minimal graphic effects

𝚆𝚛𝚒𝚝𝚎 𝚝𝚑𝚎 𝚏𝚘𝚕𝚕𝚘𝚠𝚒𝚗𝚐 𝚙𝚊𝚛𝚊𝚐𝚛𝚊𝚙𝚑: National Institute of Electronics & Information Technology (NIELIT),(erstwhile DOEACC Society), an Autonomous Scientific Society under the administrative control of Ministry of Electronics & Information Technology (MoE&IT), Government of India, was set up to carry out Human Resource Development and related activities in the area of Information, Electronics & Communications Technology (IECT). and do according to the instructions given below : a) 𝚂𝚙𝚕𝚒𝚝 𝚒𝚝 𝚒𝚗𝚝𝚘 2 𝚌𝚘𝚕𝚞𝚖𝚗𝚜 b) Make Header of "National Institute of Electronics and Information Technology" c) Make a logo of NEILIT on the right side of Header. d) Make Footer of Phone number and hyperlink website of NEILIT https://www.neilit.gov.in

Make a presentation with 3 slides. a) First slide contain title LibreOffice with font Cambria size 24 color green b) In second slide write points of libre writer c) In slide three write points of libre calc and make page color green.

Create a presentation which have slides with following data: a) Title O-Level Course prepared by XYZ. b) Explain about O-Level Course. c) Tell about modules of O level. d) Thank You Slide. e) Change the font of Thank You, and change its size also.

Type the following data in spreadsheet and save it as Second. Do the following (a) Complete column C for finding product x * y (b) Find sum of x column at the end of data (c) Find sum of y column at the end of data (d) Find sum of x * y column at the end of data (e) Find sum of x^2

O Level Practical Exam Viva Questions ans Answers

PRACTICAL-PR1 PRACTICAL-PR2 PRACTICAL-PR3 PRACTICAL-PR4

Type the following data in spreadsheet and save it as Second. Do the following (a) Complete column C for finding product x * y (b) Find sum of x column at the end of data (c) Find sum of y column at the end of data (d) Find sum of x * y column at the end of data (e) Find sum of x^2

Last Updated : 12 Mar 2026 jan 2023, jul 2024

Solution:

A(x)	B(y)	C	D
370	70.5
61166	53.5
684	65
449	76.5
643	70
1551	71
616	60.5
403	51.5

Soltuion:

(a) Complete column C to find the product $y$ :

In cell C1, enter the formula:
=A1*B1
Drag the fill handle down to apply the formula to all rows in column C.

(b) Find the sum of the x column:

Below the last entry in column A (say A9), enter the formula:
=SUM(A1:A8)

(c) Find the sum of the y column:

Below the last entry in column B (say B9), enter the formula:
=SUM(B1:B8)

(d) Find the sum of the $y$ column:

Below the last entry in column C (say C9), enter the formula:
=SUM(C1:C8)

(e) Find the sum of :

Create a new column (e.g., column E). In E1, enter the formula:
=A1^2
Drag the fill handle down to apply the formula to all rows in column E.
Below the last entry in column E (say E9), enter the formula:
=SUM(E1:E8)

(f) Find the sum of :

Create a new column (e.g., column F). In F1, enter the formula:
=B1^2
Drag the fill handle down to apply the formula to all rows in column F.
Below the last entry in column F (say F9), enter the formula:
=SUM(F1:F8)

Report an error