Spreadsheet Features, Cell Referencing, and Formulas

What does the formula =SUM(A1:A5) do in a spreadsheet?

• Multiplies the values in cells A1 to A5.

• Adds the values in cells A1 to A5.

• Subtracts the values in cells A1 to A5.

• Finds the average of the values in cells A1 to A5.

Which of the following is an example of relative cell referencing?

• Option B: $A$1
• Option C: B2
• Option D: A$1
• Option A: A1

What is the purpose of the AVERAGE function in a spreadsheet?

• To find the highest number in a range.
• To calculate the average of a range of numbers.
• To format the appearance of the numbers in a range.
• To calculate the sum of a range of numbers.

In a spreadsheet, what does the IF function allow you to do?

• Count the number of cells in a range.

• Perform conditional logic based on specified criteria.

• Multiply the values in a range of cells.

• Sort data in ascending order.

Which of the following is an absolute cell reference?

• B2
• $A$1
• A$1

• $C3

What is the primary function of the SUM function in a spreadsheet?

• Finds the average of a range of cells.

• Calculates the total of a range of cells.

• Multiplies the values in a range of cells.

• Checks for errors in a range of cells.

What is the purpose of data validation in a spreadsheet?

• Calculates the average of a range of cells.

• Checks for errors in a range of cells.

• Ensures data entered meets specified criteria.

• Multiplies the values in a range of cells.

Which feature in a spreadsheet is used for visualizing data trends?

• Sorting

• Filtering

• Equation
• Chart or Graph

What does the formula =IF(A1>10, "Yes", "No") do?

• Adds the values in cell A1 to 10.

• Checks if A1 is greater than 10 and returns "Yes" if true, "No" otherwise.

• Subtracts 10 from the value in cell A1.

• Finds the average of the values in cell A1 to 10.

What is the purpose of the SORT function in a spreadsheet?

• Calculates the total of a range of cells.

• Arranges data in ascending or descending order.

• Ensures data entered meets specified criteria.

• Performs conditional logic based on specified criteria.