o level online test
o level online test

O Level Exam 2025!

O Level Exam
Practical IT Tools Papers!

IT Tools And Business System Practical Exam Papers!


Topic : LibreOffice Writer


Question - 1
Create a document titled My New Document that includes the following

Question - 2
Create document letter for Republic Day Flag hoisting to all the employees using mail marge

Question - 3
Create a new LibreOffice Writer document and set the page size to A4.

Question - 4
Insert a header with your full name aligned to the right.

Question - 5
Add a footer containing the page number centered at the bottom.

Question - 6
Set the margins of the document to 2.5 cm on all sides.

Question - 7
Change the line spacing of the entire document to 1.5 lines.

Question - 8
Insert a title at the top using a 20 pt bold font and center-align it.

Question - 9
Create a bulleted list with at least five items under a heading.

Question - 10
Insert a numbered list using Roman numerals.

Question - 11
Format a paragraph with justified alignment and 1 cm first-line indent.

Question - 12
Apply a 3-point red border around a selected paragraph.

Question - 13
Insert a table with 4 columns and 6 rows and fill it with data.

Question - 14
Merge the top row of the table and center the text inside.

Question - 15
Add a new row at the bottom of the table and fill it with totals.

Question - 16
Sort the second column of the table in ascending order.

Question - 17
Insert a picture from file and align it to the left of a paragraph.

Question - 18
Resize the inserted image to 5 cm width and maintain aspect ratio.

Question - 19
Wrap text around the image using the “Page Wrap” option.

Question - 20
Insert a text box beside an image and add a caption.

Question - 21
Add a hyperlink to the text that redirects to https://www.libreoffice.org.

Question - 22
Create a two-column layout for a section of the document.

Question - 23
Insert a manual page break between two sections.

Question - 24
Apply a page border using a single black line around all pages.

Question - 25
Use “Find and Replace” to change every “student” to “learner”.

Question - 26
Insert a table of contents at the beginning of the document.

Question - 27
Apply “Heading 1” style to at least three main titles in the text.

Question - 28
Use “Heading 2” for sub-headings and update the table of contents.

Question - 29
Create a header that displays the current date on the left side.

Question - 30
Add a drop cap at the beginning of the first paragraph.

Question - 31
Insert a footnote at the end of a sentence and add a reference.

Question - 32
Add a comment in the margin to suggest changes in a paragraph.

Question - 33
Track changes while editing and accept all tracked changes.

Question - 34
Convert a block of uppercase text into lowercase using the format menu.

Question - 35
Apply a background color to one paragraph without affecting others.

Question - 36
Use the “Format Paintbrush” to copy formatting from one paragraph to another.

Question - 37
Insert a cross-reference to a heading or figure in the document.

Question - 38
Add a bookmark to a section and create a link to it from another part.

Question - 39
Set the document language to UK English and check for spelling errors.

Question - 40
Insert an equation using the LibreOffice formula editor.

Question - 41
Add a watermark text that reads “Confidential” diagonally across the page.

Question - 42
Export the completed document as a PDF file with the file name “OLevel_Writer_Practice.pdf”.

Topic : LibreOffice Calc


Question - 1
Create a worksheet employee with the following information.

Question - 2
Create a worksheet employee data with the following information.

Question - 3
Create a worksheet employee with the following information

Question - 4
Create a worksheet university and perform the following operation

Question - 5
Create a worksheet for university report.

Question - 6
Create a spreadsheet of Student marks and find the followings.

Question - 7
Create worksheet for Employees Details and perform following operations.

Question - 8
In a spreadsheet, create a table with the following data for monthly sales.

Question - 9
Create a Spreadsheet Employee data with following details.

Question - 10
Enter student names and marks in columns and calculate their total using the SUM function.

Question - 11
Use the AVERAGE function to calculate the mean score from a range of marks.

Question - 12
Create a formula to calculate the percentage of a score out of 100.

Question - 13
Use the IF function to display "Pass" if a score is 50 or above, otherwise "Fail".

Question - 14
Format a column of marks to show no decimal places.

Question - 15
Sort a list of names in ascending alphabetical order.

Question - 16
Format a column of numbers as currency with two decimal places.

Question - 17
Use conditional formatting to highlight all scores below 40 in red.

Question - 18
Merge cells A1 to D1 and center the text.

Question - 19
Insert a column chart comparing student scores.

Question - 20
Create a pie chart showing the percentage of each subject's marks.

Question - 21
Apply a border to an entire table of data.

Question - 22
Rename the current sheet to “Results”.

Question - 23
Protect a sheet so data cannot be edited without a password.

Question - 24
Wrap text in a cell so all content is visible.

Question - 25
Adjust column width to fit the longest entry in each column.

Question - 26
Use the COUNT function to count how many students scored above 60.

Question - 27
Insert the current date in a cell using a formula.

Question - 28
Use the MAX function to display the highest score in a list.

Question - 29
Use the MIN function to display the lowest score in a list.

Question - 30
Use a VLOOKUP function to find a student’s grade based on their mark.

Question - 31
Copy a formula from one cell to the entire column using fill handle.

Question - 32
Freeze the top row of a spreadsheet so it stays visible while scrolling.

Question - 33
Add a header with your name and candidate number.

Question - 34
Use the CONCATENATE function to join first and last names into full names.

Question - 35
Insert a new worksheet and name it “Summary”.

Question - 36
Move a worksheet to be the first tab in the workbook.

Question - 37
Use the ROUND function to round percentages to one decimal place.

Question - 38
Insert a function that counts all non-empty cells in a range.

Question - 39
Create a bar chart that compares monthly sales across four regions.

Question - 40
Create a data validation list of subjects in a dropdown menu.

Question - 41
Use the SUMIF function to total marks of students who scored “Pass”.

Question - 42
Format alternate rows with different colors using conditional formatting.

Question - 43
Insert a comment in a cell explaining a formula.

Question - 44
Use the LEFT function to extract the first 3 letters of each name.

Question - 45
Hide a column and then unhide it.

Question - 46
Insert a row above row 5 and enter new data.

Question - 47
Use the NOW() function to insert current date and time.

Question - 48
Set page orientation to landscape before printing.

Question - 49
Print only the selected range of data.

Topic : LibreOffice Impress


Question - 1
Create a presentation consisting of 5 slides on Delhi Capital of India.

Question - 2
Create a presentation with 8 slides Information Operator

Question - 3
Create a new LibreOffice Impress presentation and set the slide layout to 16:9.

Question - 4
Insert a title slide with the title “My School Presentation” and subtitle “Prepared by [Your Name]”.

Question - 5
Add a new slide with “Title and Content” layout and create a bulleted list of your favorite subjects.

Question - 6
Apply a light-blue background to all slides using the Master Slide view.

Question - 7
Insert an image on the third slide and set its wrap to “In Background”.

Question - 8
Draw a shape (circle or rectangle), change its color, and add a shadow effect.

Question - 9
Insert a 5×3 table titled “Class Timetable” and fill it with sample schedule data.

Question - 10
Add WordArt-style text on a slide and apply an outline or glow effect.

Question - 11
Insert a bar chart showing “Monthly Attendance” with correctly labeled axes.

Question - 12
Add a hyperlink on a slide linking to https://www.libreoffice.org.

Question - 13
Type at least three speaker notes below a slide titled “Presentation Tips”.

Question - 14
Insert and position a video on a slide titled “Student Project Showcase”.

Question - 15
Apply a Fade In animation to a text box and set it to start on click.

Question - 16
Animate three different text objects on one slide with unique entrance effects.

Question - 17
Set a slide transition (e.g. Wipe) for all slides with a 2-second duration.

Question - 18
Insert slide numbers on all slides using the “Slide Number” feature.

Question - 19
Create a final slide titled “Summary” and link each topic to its respective slide.

Question - 20
Change the font theme in the Master Slide to Calibri for titles and Arial for content.

Question - 21
Save the presentation in both .odp and .pptx formats.

Question - 22
Export the entire presentation as a PDF including all slides and notes.

Question - 23
Insert a slide with two content boxes and add a numbered list in one and a picture in the other.

Question - 24
Change the slide layout of the second slide to “Title, Content and Chart”.

Question - 25
Apply a gradient background to an individual slide without affecting the others.

Question - 26
Insert a slide with three columns using a layout or manually with text boxes.

Question - 27
Group two shapes together and apply a rotation of 45 degrees.

Question - 28
Add a text box with a hyperlink to another slide within the same presentation.

Question - 29
Insert a slide with a vertical timeline using shapes and text boxes.

Question - 30
Set a picture as the background for only one slide.

Question - 31
Insert a star shape, resize it, and add text inside it.

Question - 32
Apply a “Fly In” animation to a shape from the left side.

Question - 33
Change the transition effect of a single slide to “Push” and set it to advance automatically.

Question - 34
Insert a pie chart and customize the colors for each segment.

Question - 35
Add a header to all slides with your name and candidate number.

Question - 36
Create a custom slide show with selected slides only.

Question - 37
Insert a callout shape and connect it to an image with a line.

Question - 38
Import a slide from another presentation and place it as the third slide.

Question - 39
Add a motion path animation to a shape and set it to repeat 3 times.

Question - 40
Insert an audio file that plays automatically when the slide opens.

Question - 41
Create a slide duplicating an earlier one and edit only the title.

Question - 42
Use the slide sorter view to rearrange slides so the summary slide appears last.