0 votes
in Other by (19.0k points)
In Spreadsheets,

Statement I: To consolidate by row labels or column labels, the label must be contained in the selected source ranges.

Statement II: The text in the labels must be identical, so that rows or columns can be accurately matched.

Statement III: If the row or column label does not match any that exist in the target range, it will be appended as a new row or column.

Consider the above three statements, identify the correct one.

(a) Only Statements I and II are correct

(b) Only Statements II and III are correct

(c) Only Statement II is correct

(d) All the Statements are correct

1 Answer

0 votes
by (305k points)

Correct option is (d) All the Statements are correct