Course completion quiz

LibreOffice Calc Final Quiz

Answer 20 questions covering all ten lessons, including practical scenarios, troubleshooting, and choosing the right steps. Complete all ten lessons and score at least 85 percent (17 of 20 correct) to earn a printable course-completion certificate.

Final quiz

Choose one best answer for each question based on the course material. There are two questions from each lesson and four choices per question. Question and answer order changes each time. There is no time limit. After grading, read the explanations and use the lesson links to review before retaking the quiz.

1. Calc announces D5. What does that cell address identify? Row D, column 5 The fourth value in worksheet 5 Column D, row 5 The fifth worksheet in workbook D

2. A result cell displays 24, but you need to inspect how it was calculated. Which information is relevant? Its formula through the editing controls or Formula Bar Its displayed number format alone The sheet tab's position alone The workbook's saved filename alone

3. You fill a department value down several rows. What should you verify? That the workbook has an ODS extension The destination range and each affected record That the source cell still contains the department That the selected font is readable

4. You need a saved editable Calc original after entering your data. Which format fits the course? ODT ODP PDF ODS

5. B2:B5 contains 5, 10, 15, and 20. What should =SUM(B2:B5) return? 15 12.5 50 20

6. An AutoSum proposal leaves out a final expense row. What should you do before accepting it? Adjust and verify the range so all intended expenses are included Accept it because AutoSum always identifies the complete data set Apply currency formatting to make the missing value appear Move the total label without changing the formula

7. The stored decimal 0.25 represents a quarter of the budget. Which display is appropriate? 25 dollars using currency formatting 0.25 percent by appending a percent sign to its meaning 25 percent using percentage formatting A date generated from the stored number

8. A tracker highlights overdue work in red but provides no textual status. What should be added? Another red shade for alternate rows A larger blank area beside the colored cells A different file name for the tracker An explicit overdue label or equivalent text status

9. You sort quantities without including the corresponding item names. What is the main risk? The table is automatically duplicated on a new sheet Quantities can become associated with the wrong items The workbook necessarily loses all formulas Every quantity is automatically converted to text

10. After applying a filter, fewer records are visible. How should you check whether the others are still present? Clear the filter and review the full range Re-enter the hidden records immediately Replace the filter formula with zero Save as CSV to force the hidden records to be deleted

11. An IF rule should show Complete at 10 or more hours. Which test set checks the threshold well? Three blank records outside the formula range 9, 10, and 11 hours Three records each containing 10 hours 20, 30, and 40 hours

12. A status range contains Closed in four cells and Open in two. A COUNTIF rule counts Closed. What result is expected? 4 1 2 6

13. A Summary sheet needs to reflect changes in a source total on another sheet. Which approach fits? Type the current total into Summary once Copy the total as an image into Summary Use a cross-sheet formula reference and test an input change Rename Summary to match the source total

14. Two sheets both contain B8, but only one holds the intended source total. What must a cross-sheet formula identify? The workbook's title instead of the cell The correct sheet as well as the cell address The last worksheet visited before saving The cell's font size instead of the sheet

15. A chart shows 12, 18, and 24 completed tasks over three months. Which summary conveys the useful pattern? The chart has three colored columns Completions rose by 6 each month, from 12 to 24 The chart occupies half the worksheet The rightmost column is taller on the screen

16. Your chart summary says completions fell, but its source table shows increasing values. What needs correction? Compare both representations and correct the inconsistent interpretation Keep the summary because it is easier to read Hide the table so it cannot conflict with the chart Change the chart's colors to match the word fell

17. You export one sheet as CSV. Which features should you not expect CSV to preserve as a complete workbook? The intended table's text and numeric values The chosen CSV delimiter and import behavior The column order of the exported table Other worksheets, formulas, and workbook formatting

18. An XLSX copy opens in another program but shows a different calculated result. What is the best next step? Change its file extension back and forth until the number matches Remove the original workbook before investigating Compare formulas, references, data types, and calculation behavior Assume the larger result is correct

19. A final tracker has a correct grand total but one incorrect record-level formula. Is the calculation review complete? Yes; one correct total proves every contributing formula is correct Yes; saving as ODS validates every formula automatically No; the workbook must first contain a chart on every sheet No; individual formulas and representative records still require checking

20. Which final package best supports another person's use of the tracker? A workbook containing results with no explanation of their inputs An untested exchange copy with the original discarded A chart image without the underlying data A reviewed workbook, clear labels, tested formulas, and a plain-language summary

LibreOffice Calc Final Quiz

Final quiz

Create your certificate

Certificate of Course Completion