6
QuizMultiple Choice

Create a Presentation — Unit test

Question 6 • Introduction to Information Technology - EL3701

What is relative referencing?

Answer
A
a system of referring to cells using letters for columns and numbers for rows
B
a method of formatting text in spreadsheet cells so none of it is cut off
C
a formula for calculating the optimal width of columns and height of rows
D
a bulleted list of all of the information included in a spreadsheet

Explanation

Relative referencing identifies a spreadsheet cell by its position using a column letter and a row number, such as B3. In a formula, a relative cell reference adjusts when the formula is copied to another cell. Therefore, the correct choice is “a system of referring to cells using letters for columns and numbers for rows.”

AI-written and checked against the verified answer.

Previous
Next