CCC Online Test LibreOffice 20 Questions and Answers

LibreOffice is an open-source office suite that offers tools for creating and editing documents, spreadsheets, presentations, and more. It is commonly included in CCC online tests to assess knowledge of its functions and features. Here are important questions and answers to help you prepare for LibreOffice-related topics.

LibreOffice Writer Questions

Question: What is LibreOffice Writer used for?

Answer: LibreOffice Writer is used for creating and editing text documents such as letters, resumes, and reports.

Question: How can you save a document in LibreOffice Writer?

Answer: You can save a document by clicking on File > Save or pressing Ctrl + S.

Question: How can you insert a page number in Writer?

Answer: Go to Insert > Page Number to add a page number to your document.

Question: What is the shortcut key to open a new document in Writer?

Answer: The shortcut key is Ctrl + N.

Question: How do you change the font size in LibreOffice Writer?

Answer: Select the text, then use the font size dropdown menu in the toolbar.

Question: What is the function of the ‘Styles’ feature in Writer?

Answer: The ‘Styles’ feature helps in applying consistent formatting to text quickly.

Question: How do you insert an image in a Writer document?

Answer: Click on Insert > Image and choose the image file from your computer.

Question: What is the use of the ‘Table’ option in Writer?

Answer: The ‘Table’ option is used to create and format tables in a document.

Question: How do you export a Writer document as a PDF?

Answer: Click on File > Export As > Export as PDF.

Question: What is the purpose of the ‘Find and Replace’ tool?

Answer: It helps to locate specific text and replace it with other text quickly.

Question: How do you add a hyperlink in Writer?

Answer: Select the text, click on Insert > Hyperlink, and enter the URL.

Question: What is the shortcut for undoing an action in Writer?

Answer: The shortcut key is Ctrl + Z.

Question: How do you check spelling and grammar in Writer?

Answer: Go to Tools > Spelling and Grammar or press F7.

Question: What is the default file format for Writer documents?

Answer: The default file format is .ODT (Open Document Text).

Question: How do you add a header to a document?

Answer: Go to Insert > Header and select the type of header you want.

Question: What is the shortcut to select all text in a Writer document?

Answer: The shortcut key is Ctrl + A.

Question: How do you adjust line spacing in Writer?

Answer: Select the text, then go to Format > Paragraph > Line Spacing.

Question: What is the use of the ‘Track Changes’ feature?

Answer: It tracks edits made to the document, allowing review and acceptance of changes.

Question: How do you create a numbered list in Writer?

Answer: Select the text and click on the numbered list icon in the toolbar.

LibreOffice Calc Questions

Question: What is LibreOffice Calc used for?

Answer: LibreOffice Calc is used for creating and editing spreadsheets for data analysis and calculations.

Question: How do you insert a new sheet in Calc?

Answer: Click on the ‘+’ icon next to the existing sheet tabs or go to Sheet > Insert Sheet.

Question: What is the shortcut for adding a formula in Calc?

Answer: The shortcut key is ‘=’ followed by the formula.

Question: How do you freeze rows or columns in Calc?

Answer: Go to View > Freeze Rows and Columns.

Question: How do you create a chart in Calc?

Answer: Select the data, then go to Insert > Chart and choose the chart type.

Question: What is the function of the SUM formula in Calc?

Answer: The SUM formula adds up a range of numbers.

Question: How do you sort data in Calc?

Answer: Select the data, then go to Data > Sort and choose the sorting order.

Question: What is the shortcut to delete a row in Calc?

Answer: The shortcut key is Ctrl + – (minus).

Question: How do you format cells in Calc?

Answer: Right-click the cell and select Format Cells to change its appearance.

Question: How do you apply conditional formatting in Calc?

Answer: Go to Format > Conditional Formatting and set the conditions.

Question: How do you merge cells in Calc?

Answer: Select the cells, then go to Format > Merge Cells.

Question: How do you insert a hyperlink in Calc?

Answer: Select a cell, then go to Insert > Hyperlink and enter the URL.

Question: What is the use of the VLOOKUP function?

Answer: The VLOOKUP function searches for a value in a column and returns a corresponding value.

Question: How do you filter data in Calc?

Answer: Go to Data > AutoFilter and select the filter criteria.

Question: How do you lock cells in Calc?

Answer: Select the cells, then go to Format > Cells > Cell Protection and enable the lock.

Question: What is the default file format for Calc spreadsheets?

Answer: The default file format is .ODS (Open Document Spreadsheet).

Question: How do you add a comment to a cell in Calc?

Answer: Right-click the cell and select Insert Comment.

Question: How do you remove duplicates in Calc?

Answer: Go to Data > More Filters > Remove Duplicates.

Question: How do you create a pivot table in Calc?

Answer: Go to Data > Pivot Table > Create and select the data range.

Question: How do you change the sheet tab color in Calc?

Answer: Right-click the sheet tab and select Tab Color.

LibreOffice Impress Questions

Question: What is LibreOffice Impress used for?

Answer: LibreOffice Impress is used for creating presentations with slides.

Question: How do you add a new slide in Impress?

Answer: Click on Slide > New Slide or press Ctrl + M.

Question: How do you apply a slide design in Impress?

Answer: Go to Slide > Slide Design and select a template.

Question: How do you add animations to a slide?

Answer: Select the element, then go to Slide Show > Custom Animation.

Question: How do you insert a video in Impress?

Answer: Go to Insert > Media > Video and select the video file.

Question: How do you change the slide layout in Impress?

Answer: Go to Slide > Slide Layout and choose a layout.

Question: How do you start a slideshow in Impress?

Answer: Press F5 or go to Slide Show > Start From First Slide.

Question: How do you insert a table in Impress?

Answer: Go to Insert > Table and specify the number of rows and columns.

Question: How do you group objects in Impress?

Answer: Select the objects, then go to Format > Group.

Question: How do you set a slide transition in Impress?

Answer: Go to Slide > Slide Transition and choose a transition effect.

Question: How do you duplicate a slide in Impress?

Answer: Right-click the slide in the slide pane and select Duplicate Slide.

Question: How do you add speaker notes in Impress?

Answer: Go to View > Notes Page and type your notes.

Question: How do you add a hyperlink to a slide?

Answer: Select the text or object, then go to Insert > Hyperlink and enter the URL.

Question: How do you align objects in Impress?

Answer: Select the objects, then go to Format > Align and choose the alignment.

Question: How do you export a presentation as a PDF in Impress?

Answer: Go to File > Export As > Export as PDF.

Question: How do you add a background to a slide?

Answer: Right-click the slide, then select Slide > Properties > Background.

Question: How do you insert a chart in Impress?

Answer: Go to Insert > Chart and select the chart type.

Question: How do you spell check a presentation in Impress?

Answer: Go to Tools > Spelling and Grammar or press F7.

Question: What is the default file format for Impress presentations?

Answer: The default file format is .ODP (Open Document Presentation).

LibreOffice tools are essential for CCC online tests, covering a variety of tasks in Writer, Calc, and Impress. These questions and answers provide a thorough understanding to help you prepare efficiently.