Spreadsheet Software Quiz

What is a destination range in spreadsheet software?

• The range where data is copied to

• The range where data is originally located

• The range used for calculations

• The range that contains errors

What are relative references in a spreadsheet?

• References that change when a formula is copied

• References that remain constant

• References that refer to another worksheet

• References that are only used in charts

What does the PRODUCT function do in a spreadsheet?

• Adds numbers together

• Multiplies numbers together

• Divides numbers

• Subtracts numbers

What is point mode in spreadsheet software?

• A mode to enter data manually

• A mode to select cells with the mouse

• A mode to format cells

• A mode to print documents

What is an indirect circular reference?

• A reference that directly refers to itself

• A reference that involves a chain of references leading back to itself

• A reference that is always correct

• A reference that is used in charts

What is a circular reference in a spreadsheet?

• A reference that refers to a cell in another worksheet

• A reference that refers to itself

• A reference that is used for formatting

• A reference that is always correct

What is a direct circular reference?

• A reference that involves multiple cells

• A reference that directly refers to itself

• A reference that is used in charts

• A reference that is always correct

What does the MAX function do in a spreadsheet?

• Finds the minimum value

• Finds the maximum value

• Calculates the average

• Counts the number of cells

What is a formula in spreadsheet software?

• A set of instructions for calculations

• A type of chart

• A formatting style

• A data entry method

What is a source range in spreadsheet software?

• The range where data is copied to

• The range where data is originally located

• The range used for formatting

• The range that contains errors