Practical Questions Practice

Master practical skills for NIELIT O Level Exam with hands-on practice questions and real-world scenarios. Perfect for developing practical knowledge, problem-solving abilities, and exam readiness.

Q.1 - Create a table in LibreOffice Writer as shown below with the following output:

QuitExams.com is an online learning platform that provides study resources and practice tools for students preparing for computer-related courses such as O Level, A Level, and B Level examinations. It offers features like mock tests, online quizzes, and downloadable PDFs to help learners strengthen their understanding and improve their exam performance. Designed to simulate real exam environments, the platform enables users to practice extensively and identify areas for improvement. With its focus on interactive learning and exam readiness, QuitExams.com serves as a convenient and accessible solution for students aiming to excel in IT and computing certifications.


Q.2 - Create a table in LibreOffice Writer as shown below with the following fields:

Roll No, Name, Marks (Physics, Chemistry), Total Marks

Roll No Name Marks Total Marks
Physics Chemistry
1.Rahul8897
2.Aman7166
3.Jyoti8479
4.Shruti6372
5.Kamal4957

Do the following:
  • In the Total Marks column, entries should be calculated using formulas (sum of marks in Physics and Chemistry).
  • Insert a new row at the end of the table and find the Grand Total using a formula.
  • Sort the table based on Total Marks.
  • The date and heading should be center aligned.
  • Heading should be in bold and underlined.


Q.3 - Create a presentation in LibreOffice Impress for the following three slides:

a) At first slide:

  • i) Apply a theme.
  • ii) Insert page no. and text as "Training Slides" at footer.
  • iii) Add an image of computer at the top left corner with title "Computer Awareness".
b) Add the following text in slide 1:
  • Heading: "Computer Basics" (Red color, 25 point size, Arial font, Left Aligned).
c) On the second slide type the following text where font="Arial" size="20":

"This is the Computer awareness training for the students living below poverty line. The institute was established in 2010 and providing free education since inception."

d) On third slide, display the courses—a. Basics b. Advance c. Diploma
  • Add some description with these courses.

Note: Download images/video files if required.


Q.4 - Create a student marks statement using a spreadsheet for the following:

Name English History Science Total
Rahul889781
Aman716678
Jyoti847976
Shruti637258
Kamal495753

Find the Total, average, result, max and marks.

Instructions:
  • Calculate the Total marks for each student using formulas
  • Create a Column named "Average" and Find the average marks for each subject
  • Create a Column named "Result" and Determine the result (Pass/Fail) based on criteria (e.g., 40% passing marks)
  • Create a Column named "Max" and Find the maximum marks obtained in each subject
  • Create a Column named "Class Performance" and Calculate the overall class performance statistics


Q.5 - Create a presentation file with 5 slides. Apply transition effect and slide advance every two seconds automatically.

Requirements:

  • Create exactly 5 slides for the presentation
  • Apply appropriate transition effects between slides
  • Set automatic slide advance every 2 seconds
  • Ensure smooth and professional presentation flow
Suggested Topics for 5 Slides:
  1. Slide 1: Title slide with presentation topic
  2. Slide 2: Introduction and overview (e.g., Introduction to Computer Basics)
  3. Slide 3: Main content point 1 (e.g., Computer Basics)
  4. Slide 4: Main content point 2 (e.g., Computer Applications)
  5. Slide 5: Conclusion and summary (e.g., Summary of key points)