The TRIM Function Removes All Spaces in a Text String

question 45

Multiple Choice

The TRIM function removes all spaces in a text string except for the single spaces ____.

• A) between numbers
• B) between words
• C) between cells
• D) between worksheets

---

Definitions:

Wilcoxon Signed Rank Test

A non-parametric statistical test used to compare two related samples, matched samples, or repeated measurements on a single sample to assess differences.

Nonparametric Test

A type of statistical test that does not assume your data comes from a particular distribution.

Matched-Pairs Sample

A study design where subjects are paired based on certain characteristics, and each pair is treated differently to study effects of a variable.

Interval Data

A type of numerical data where the distance between two points is meaningful, including temperatures and dates.