Louie Is Designing a Complex Worksheet and Needs to Format

question 95

Multiple Choice

Louie is designing a complex worksheet and needs to format cells containing numbers and calculated values in a special way. Simply applying bold or italic formatting will not meet his needs. He gives you a call to ask for formatting tips.
-Louie calls back with another formatting question.Another coworker suggested that he use styles to format cells in his worksheet,but he is unfamiliar with styles.You tell Louie that _____.

• A) a style is a group of format specifications that are assigned a name; he can view styles in the Cell Styles gallery and then click a style to apply it to the selected cell or range
• B) styles are effective when used to format a word-processing document but cannot be used to format a worksheet
• C) a style is just another name for a set of formatting codes; a style must be customized to be useful
• D) using a style will allow him to apply multiple formats at one time to an active cell if it contains text; unfortunately,styles cannot be used to format numbers or calculated values

---

Definitions:

IQR

Short for Interquartile Range, it measures the middle 50% of data points in a dataset, offering a glimpse into data spread.

Range

The difference between the highest and lowest values in a set of data.

Median

The median is the value that lies at the center of a dataset when it is organized in ascending or descending order, splitting the set into two equal parts.

Standard Deviation

A metric that gauges the spread or deviation of a dataset in relation to its average, showing the extent to which the data points are scattered.