LibreOffice Calc Trivia Questions

Explore LibreOffice’s spreadsheet program, from formulas and cell formatting to charts and file compatibility. See how well you know the open-source alternative for working with data.

10 questions · 10 per game

LibreOffice Calc trivia questions and answers

  1. Which Calc function adds a range of numbers, such as the values in A1 through A10?

    Show answer

    SUM

    SUM can add individual numbers and cell ranges, and you can combine multiple ranges in one formula.

  2. In a cell reference such as $A$1, what kind of reference keeps both the column and row fixed when a formula is copied?

    Show answer

    Absolute reference

    The dollar signs lock the column and row; placing a dollar sign before only one part creates a mixed reference.

  3. What is the name for a reference such as B3 that identifies a cell by its column letter and row number?

    Show answer

    Cell reference

    A cell reference can be used in formulas to point to data elsewhere in the spreadsheet.

  4. In Calc’s standard worksheet layout, what identifies each row along the left edge of the grid?

    Show answer

    Row numbers

    Columns are labeled with letters, while rows are labeled with numbers.

  5. What Calc feature can automatically change a cell’s appearance when its value meets a specified rule?

    Show answer

    Conditional formatting

    Rules can use cell values or formulas to determine which formatting is applied.

How to play

  • • Each game has 10 questions. Before each one you see only a hint about its topic.
  • • Choose what it’s worth, from $1 to $20. Each value can only be used once per game.
  • • Type your answer. Small spelling mistakes are fine. Get it right and you win that amount.

Related categories