LibreOffice Online Test – NIELIT O Level (M1-R5.1) Practice Questions

Prepare thoroughly for your NIELIT O Level (M1-R5.1) examination with our dedicated online practice test covering the core office automation applications: LibreOffice Writer, Calc, and Impress. This online quiz features a randomized set of 20 high-yield MCQs created strictly as per Revision 5.1 syllabus guidelines.

🚀 About the Online Test

• Exam Name: NIELIT O Level (IT)
• Paper Code & Name: M1-R5.1 – Information Technology Tools and Network Basics
• Module Topic: LibreOffice Suite (Word Processing, Spreadsheet, Presentation)
• Test Format: 20 Dynamic MCQs per attempt (Practice Mode)
• Language Support: Fully Bilingual (English & Hindi / द्विभाषीय)
• Result Analysis: Instant scorecard with complete answers and detailed step-by-step explanations

📚 Detailed Syllabus Breakdown

This comprehensive practice test evaluates your practical and theoretical knowledge across three major modules of LibreOffice:

1. Word Processing (LibreOffice Writer)

• Document Basics: Title Bar, Menu Bar, Toolbars, Sidebar, Page Setup, Borders, Watermarks, Print Preview, and Exporting to PDF.
• Text Editing & Formatting: Selection, Cut/Copy/Paste, Alignment, Fonts, AutoCorrect, Spelling & Grammar, Find & Replace, Indentation, Bullets & Numbering, and User-defined Styles.
• Tables & Tools: Table creation, cell merging/splitting, cell alignment, Mail Merge, Table of Contents, Indexes, Comments, Track Changes, and Macros.

2. Spreadsheet (LibreOffice Calc)

• Workbook Fundamentals: Row/Column cell addressing, Data Entry (Text, Number, Date), Page Setup, Cell formatting, AutoFill, Freezing Panes, and Paste Special.
• Data Management: Sorting, Filtering, Advanced Filtering, Data Validation, What-If Analysis, and Pivot Tables.
• Formulas & Functions: Arithmetic formulas, AutoSum, Standard Functions (SUM, COUNT, MAX, MIN, AVERAGE), Database Functions (DSUM, DMIN, DMAX, DCOUNT, DCOUNTA), and Charts (Bar, Column, Pie, Line).

3. Presentation (LibreOffice Impress)

• Slide Creation: Using Templates vs. Blank Presentations, Slide Master creation, running Slide Shows, setup configurations, and Custom Timings.
• Object Manipulation: Text boxes, Tables, Pictures, Resizing/Scaling objects, adding Movie/Sound elements, and applying Aesthetics.
• Finishing Touches: Slide Transitions, Animation timings, Headers & Footers, Speaker Notes, and Printing Slides or Handouts.

💡 Top Exam Preparation Tips for LibreOffice (M1-R5.1)

1. Master Keyboard Shortcuts: Memorize essential LibreOffice shortcuts (e.g., Ctrl + F12 to insert a table in Writer, Ctrl + Shift + F5 for Navigator, Ctrl + F2 for Function Wizard in Calc, F5 to start a slide show in Impress).
2. Understand Menu Paths: Pay close attention to which menu bar tab contains specific commands (e.g., Mail Merge under Tools, Track Changes under Edit, Pivot Table under Insert).
3. Practice Functions & Formulas: Review formula syntax, cell reference types (Relative vs. Absolute like $A$1), and database functions (DSUM, DCOUNT) frequently asked in the examination.