An if-else statement is commonly used to check user inputs for validity before processing them.

Match the following terms to their meanings:

I. Subtotal II. Outline III. Collapse IV. Expand V. Grouping A. The process of joining rows or columns of related data together into a single entity B. A row within the dataset containing at least one aggregated value C. A hierarchical structure of data D. Restricting the view of a grouped data set E. Displaying all information in a grouped data set

The bar, located below the Ribbon, that displays the active cell's content is the ________

A) formula bar B) name bar C) data bar D) display bar