Question

Which function leverages sheet hierarchy to reference the range of rows that are indented below another row?

a) ANCESTORS()
b) CHILDREN()
c) PARENT()
d) INDEX()

Answer 1

The CHILDREN() function references the range of rows that are indented below another row, aiding in accessing hierarchical data within a spreadsheet.

Step-by-step explanation:

The function that leverages sheet hierarchy to reference the range of rows that are indented below another row is the CHILDREN() function. This function is particularly useful in spreadsheets that implement a hierarchical structure, where rows represent different levels of detail or categories. For instance, if you have a row labeled as "Sales 2021", using the CHILDREN() function on this row would reference all the rows that are indented beneath it, such as individual monthly sales figures.