The Following Are The Salaries Of Five Employees

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

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.

Last Updated : 12 Mar 2026 Jan 23, Jul 24

Solution:

Pay Roll No	Name	Salary Rs.	Part time Rs.	Accounts
1011	Prasanna	10000	900	1800
1012	Anitha	14000	800	1600
1013	Ravi	18000	700	1700
1014	Saritha	15000	600	1600
1015	Mallika	17000	500	1800

A) Highlight Employees with Salary Less Than Rs. 15000:

Select the range under the Salary Rs. column (e.g., C2:C6).
Go to Format → Conditional Formatting.
In the Conditional Formatting dialog:
- Select Cell Value Is.
- Choose less than from the dropdown.
- Enter 15000.
Set the desired formatting style (e.g., red background).
Click OK.

B) Highlight Employees with Part-Time Rs. More Than 700:

Select the range under the Part time Rs. column (e.g., D2:D6).
Go to Format → Conditional Formatting.
In the Conditional Formatting dialog:
- Select Cell Value Is.
- Choose greater than from the dropdown.
- Enter 700.
Set the desired formatting style (e.g., green background).
Click OK.

C) Highlight Employees with Arrears Between Rs. 1600 and Rs. 1800:

Select the range under the Accounts column (e.g., E2:E6).
Go to Format → Conditional Formatting.
In the Conditional Formatting dialog:
- Select Cell Value Is.
- Choose between from the dropdown.
- Enter 1600 and 1800 as the lower and upper bounds.
Set the desired formatting style (e.g., yellow background).
Click OK.

Report an error