The Following Are The Marks Obtained By The Students Of B Com In Three Subjects

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

Last Updated : 12 Mar 2026 New Question

Solution:

Roll No	Name	QT	FIT	Accounts
1011	Pravalika	50	90	80
1012	Aryaman	40	80	60
1013	Akrosh	38	70	75
1014	Prajaktha	80	60	68
1015	Trisha	84	57	84

A) Highlight Students Scoring Less Than 50 in QT:

Select the range under the QT column.
Go to Format → Conditional Formatting.
Choose "Cell Value" → "less than" → 50.
Set a formatting style (e.g., red background).

B) Highlight Students Scoring More Than 65 in FIT:

Select the range under the FIT column.
Go to Format → Conditional Formatting.
Choose "Cell Value" → "greater than" → 65.
Set a formatting style (e.g., green background).

C) Highlight Students Scoring Between 60 and 80 in Accounts:

Select the range under the Accounts column.
Go to Format → Conditional Formatting.
Choose "Cell Value" → "between" → 60 and 80.
Set a formatting style (e.g., yellow background).

Result:

Once applied, students meeting the criteria will have their scores highlighted in the respective columns. For example:

Aryaman and Akrosh will be highlighted in QT.
Pravalika, Aryaman, and Akrosh will be highlighted in FIT.
Aryaman, Akrosh, and Prajaktha will be highlighted in Accounts.

Report an error