In Spreadsheet Enter The Following Data

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

(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.

Last Updated : 12 Mar 2026 Jan 22, Jul 24

Solution:

(b) Calculate DA and HRA

DA Calculation (80% of Basic Pay):
- In cell C2, enter the formula: =B2*0.80
- Drag the formula down from C2 to C6.
HRA Calculation (10% of Basic Pay + DA):
- In cell D2, enter the formula: =B2*0.10 + C2
- Drag the formula down from D2 to D6.

(c) Calculate Net Salary

Gross Pay Calculation:
- In cell E2, enter the formula: =B2 + C2 + D2
- Drag the formula down from E2 to E6.
Insurance Calculation (10% of Basic Pay):
- In cell F2, enter the formula: =B2*0.10
- Drag the formula down from F2 to F6.
P.F. Calculation (5% of Basic Pay):
- In cell G2, enter the formula: =B2*0.05
- Drag the formula down from G2 to G6.
Net Salary Calculation (Gross Pay - Insurance - P.F.):
- In cell H2, enter the formula: =E2 - F2 - G2
- Drag the formula down from H2 to H6.

(d) Find Highest and Lowest Salary

Highest Salary:
- In cell H8, enter the formula: =MAX(H2:H6)
Lowest Salary:
- In cell H9, enter the formula: =MIN(H2:H6)

(e) Calculate Total Insurance Collected

Total Insurance:
- In cell H10, enter the formula: =SUM(F2:F6)

(f) Apply Two Decimal Notations

Select the Data in columns B through H.
Format Cells:
- Right-click the selected cells, choose Format Cells.
- Go to the Numbers tab.
- Set the format to Number with 2 decimal places.

Report an error

Meanwhile you can watch this video

Watch Video