Basic Spreadsheet retrieval

What is cell referencing in a spreadsheet?

• Using a cell's address to identify its location in the spreadsheet
• Changing the color of a cell
• Sorting data in ascending order
• Merging multiple cells into one

Answer explanation

Cell referencing lets you use the cell’s address (like A1) to identify and use its value in calculations.

What is the difference between relative and absolute cell referencing?

• Relative references change when copied, while absolute references remain fixed
• Relative references are for text, and absolute references are for numbers
• Relative references are used for formatting, and absolute references are for calculations
• There is no difference between them

Answer explanation

Relative = changes when moved (A1); Absolute = fixed (e.g. $A$1).

Which formula would you use to find the sum of values in A1 to A10?

• =SUM(A1:A10)
• =ADD(A1:A10)
• =TOTAL(A1:A10)
• =COMBINE(A1:A10)

Answer explanation

=SUM adds the numbers in a cell range.

What does =AVERAGE(B1:B10) do?

• Adds all values in B1–B10
• Finds the average of values in B1–B10
• Finds the maximum value in B1–B10
• Counts the number of cells in B1–B10

Answer explanation

=AVERAGE calculates the mean of values in a range.

Which function finds the smallest value in a range?

• =MIN(A1:A10)
• =MAX(A1:A10)
• =LOWEST(A1:A10)
• =SMALL(A1:A10)

Answer explanation

=MIN returns the smallest number in a specified range.

Which function finds the largest value in a range?

• =MAX(A1:A10)
• =MIN(A1:A10)
• =HIGHEST(A1:A10)
• =LARGE(A1:A10)

Answer explanation

=MAX returns the HIGHEST number in a range.

What does =A1+B1 do?

• Adds A1 and B1
• Subtracts B1 from A1
• Multiplies A1 and B1
• Divides A1 by B1

Answer explanation

A simple formula for addition.

What does =$A$1+B1 do when copied down?

• Keeps A1 fixed and adds it to the new B cell
• Changes both A1 and B1
• Keeps B1 fixed and changes A1
• Doesn’t work because of $ symbols

Answer explanation

$A$1 is an absolute reference — it never changes.

Which feature lets you apply a formula down a column quickly?

• AutoFill
• Conditional Formatting
• Data Validation
• Freeze Panes

Answer explanation

AutoFill copies and adjusts formulas automatically.

What does =SUM(A1:A5)+MAX(B1:B5) do?

• Adds the total of A1–A5 and the highest B1–B5 value
• Multiplies the sum of A1–A5 with the max of B1–B5
• Finds the max of A1–A5 + sum of B1–B5
• Adds the smallest A value to largest B value

Answer explanation

Adds two results: the SUM of one range and the MAX of another.