Basic Features
Q: What is LibreOffice Writer?
A: It is a word processing software used to create, edit, format, and print documents.
Q: What is the default file format of LibreOffice Writer?
A: .odt (Open Document Text).
Q: How do you save a document in LibreOffice Writer?
A: Click File > Save or press Ctrl+S.
Q: Which shortcut is used to open a new document in LibreOffice Writer?
A: Ctrl+N.
Q: How can you export a document as a PDF in LibreOffice Writer?
A: Click File > Export As > Export as PDF.
Formatting
Q: Which option is used to make text bold?
A: Ctrl+B or the Bold button on the toolbar.
Q: How do you apply italics to text?
A: Ctrl+I or the Italic button on the toolbar.
Q: How do you underline text in LibreOffice Writer?
A: Ctrl+U or the Underline button on the toolbar.
Q: How can you change the font size of text?
A: Use the Font Size dropdown on the toolbar or Format > Character.
Q: How do you align text to the center?
A: Ctrl+E or click the Center Align button on the toolbar.
Page Layout
Q: How can you change the page orientation to landscape?
A: Go to Format > Page Style > Page > Orientation > Landscape.
Q: How do you set margins for a document?
A: Go to Format > Page Style > Page > Margins.
Q: What is the default unit of measurement for margins in LibreOffice Writer?
A: Centimeters (cm).
Q: How can you insert page numbers?
A: Go to Insert > Page Number.
Q: How do you add a header or footer?
A: Go to Insert > Header and Footer and choose the desired option.
Tables and Lists
Q: How can you insert a table in LibreOffice Writer?
A: Go to Table > Insert Table or press Ctrl+F12.
Q: Which menu is used to create a numbered list?
A: Format > Bullets and Numbering.
Q: How do you add rows to an existing table?
A: Right-click on the table, select Row > Insert.
Q: What is the shortcut for creating a bullet list?
A: Shift+F12.
Q: How can you merge table cells?
A: Select the cells, then right-click and choose Merge Cells.
Advanced Features
Q: How can you insert an image in LibreOffice Writer?
A: Go to Insert > Image or drag and drop the image.
Q: What feature is used to check spelling and grammar?
A: Tools > Spelling and Grammar or press F7.
Q: What is the shortcut to find and replace text?
A: Ctrl+H.
Q: How do you track changes in a document?
A: Go to Edit > Track Changes > Record.
Q: How can you add comments to a document?
A: Go to Insert > Comment.
Miscellaneous
Q: How do you insert a hyperlink in a document?
A: Go to Insert > Hyperlink or press Ctrl+K.
Q: What is the use of the Navigator in LibreOffice Writer?
A: It helps navigate through headings, tables, images, and other elements in the document.
Q: How can you insert a table of contents?
A: Go to Insert > Table of Contents and Index > Table of Contents, Index, or Bibliography.
Q: Which feature is used to automate repetitive tasks in LibreOffice Writer?
A: Macros.
Q: How do you print a document in LibreOffice Writer?
A: Go to File > Print or press Ctrl+P.
Basics of LibreOffice Calc
Q: What is LibreOffice Calc?
A: It is a spreadsheet application used to perform calculations, analyze data, and create charts.
Q: What is the default file format of LibreOffice Calc?
A: .ods (Open Document Spreadsheet).
Q: What is a cell in LibreOffice Calc?
A: A cell is the intersection of a row and a column where data can be entered.
Q: How can you save a spreadsheet in LibreOffice Calc?
A: Click File > Save or press Ctrl+S.
Q: What is the maximum number of rows in a LibreOffice Calc spreadsheet?
A: 1,048,576 rows.
Data Entry and Editing
Q: What is the shortcut to edit the content of a cell?
A: F2.
Q: How do you delete the content of a cell?
A: Select the cell and press the Delete key.
Q: How can you select an entire row?
A: Click on the row number.
Q: How can you select an entire column?
A: Click on the column header.
Q: How do you merge cells in LibreOffice Calc?
A: Select the cells, then go to Format > Merge Cells.
Formulas and Functions
Q: How do you start a formula in LibreOffice Calc?
A: By typing = (equal sign).
Q: What is the function to calculate the sum of a range of cells?
A: =SUM(range).
Q: How do you calculate the average of a range of cells?
A: Use the formula =AVERAGE(range).
Q: Which function is used to find the maximum value in a range?
A: =MAX(range).
Q: Which function is used to count the number of cells containing numbers?
A: =COUNT(range).
Formatting
Q: How can you bold text in a cell?
A: Select the cell and press Ctrl+B.
Q: What is the shortcut to italicize text in a cell?
A: Ctrl+I.
Q: How do you change the background color of a cell?
A: Go to Format > Cells > Background.
Q: How can you align text to the center of a cell?
A: Use the Center Align button on the toolbar or go to Format > Alignment > Center.
Q: How do you format a cell to display currency?
A: Go to Format > Cells > Numbers > Currency.
Charts
Q: How do you insert a chart in LibreOffice Calc?
A: Select the data range and go to Insert > Chart.
Q: What are the types of charts available in LibreOffice Calc?
A: Bar, Line, Pie, Area, Scatter, and more.
Q: Which chart type is best suited for showing proportions?
A: Pie chart.
Q: How do you edit the title of a chart?
A: Double-click the chart and edit the title.
Q: How can you delete a chart?
A: Select the chart and press the Delete key.
Data Analysis
Q: What is the use of the AutoFilter feature?
A: It allows you to filter data based on specific criteria.
Q: How do you apply AutoFilter in LibreOffice Calc?
A: Select the data range and go to Data > AutoFilter.
Q: What is the purpose of conditional formatting?
A: To format cells based on specific conditions or criteria.
Q: How do you sort data in ascending order?
A: Select the data range and go to Data > Sort > Ascending.
Q: What is the use of the Pivot Table feature in LibreOffice Calc?
A: It is used to summarize and analyze data dynamically.
Basic Concepts(DBMS)
Q: What is LibreOffice Base?
A: It is a database management system (DBMS) used to create, manage, and manipulate databases.
Q: What is the default file format of LibreOffice Base?
A: .odb (Open Document Database).
Q: What is a database?
A: A database is an organized collection of data stored electronically.
Q: What is a table in a database?
A: A table is a collection of rows and columns used to store data in a structured format.
Q: What is a primary key?
A: A primary key is a unique identifier for each record in a table.
Data Types
Q: Name any two data types available in LibreOffice Base.
A: Text [VARCHAR] and Number [INTEGER].
Q: Which data type is used to store dates in LibreOffice Base?
A: Date [DATE].
Q: Which data type is used for storing true/false values?
A: Boolean [YES/NO].
Q: What data type is suitable for storing decimal values?
A: Decimal [DECIMAL] or Float [FLOAT].
Q: What is the maximum length of a VARCHAR data type?
A: 255 characters.
Database Operations
Q: How can you create a new database in LibreOffice Base?
A: Go to File > New > Database.
Q: How do you open an existing database in LibreOffice Base?
A: Go to File > Open and select the database file.
Q: What is a query in a database?
A: A query is used to retrieve specific data from one or more tables.
Q: What is a form in LibreOffice Base?
A: A form is a user-friendly interface for data entry and viewing.
Q: What is a report in LibreOffice Base?
A: A report is used to display and print data in a structured format.
Working with Tables
Q: How do you create a table in LibreOffice Base?
A: Use the Table Design view or the Wizard.
Q: How can you set a primary key in a table?
A: Right-click on the column and select Primary Key.
Q: What is the purpose of indexing in a table?
A: Indexing speeds up data retrieval by creating an index on a column.
Q: How do you delete a record from a table?
A: Open the table, select the record, and press the Delete key.
Q: How do you add a new column to an existing table?
A: Edit the table structure and add a new field.
Queries
Q: How do you create a query in LibreOffice Base?
A: Use the Query Design view or the Query Wizard.
Q: What is the purpose of a WHERE clause in a query?
A: It is used to filter records based on specific conditions.
Q: Write the SQL query to retrieve all data from a table named Students.
A: SELECT * FROM Students;
Q: How do you sort data in ascending order in a query?
A: Use the ORDER BY clause in SQL, e.g., SELECT * FROM Students ORDER BY Name ASC;.
Q: What is the purpose of the GROUP BY clause in a query?
A: It groups records with the same value in a specified column.
Forms and Reports
Q: How do you create a form in LibreOffice Base?
A: Use the Form Wizard or create it manually in the Design View.
Q: What is the purpose of a subform?
A: A subform displays related records from another table.
Q: How do you create a report in LibreOffice Base?
A: Use the Report Wizard or design it manually.
Q: Can reports in LibreOffice Base be customized?
A: Yes, they can be customized in the Design View.
Q: How do you print a report in LibreOffice Base?
A: Open the report and go to File > Print.