In MS Excel, which of the following functions can be used to remove all spaces from a text string except for single spaces between words?

A) TRIM
B) SUBSTITUTE
C) CLEAN
D) REPT

Trim is correct answer, it is used to remove all spaces from a text string except for single spaces between words.

Post navigation

which of the following is not a valid Zoom percentage in Excel?

Who chaired Asia Pacific Group of UNESCO for the year 2020 from Pakistan:

A. Software B. Hardware C. Human ware D. All of these The answer is: B [/expand]

A. sequoia B. Fugaku C. Tianhe-2A D. Frontera The answer is: B [/expand]

A. Main document B. Data source C. Merge fields D. Word fields The answer is: D [/expand]

a) Insert b) Slide shows c) Zoom d) Slide master

A. Memory or disk space. B. Time. C. CD drives space. D. CD-RW. The answer is: A [/expand]

A. Home arrangement B. Qwerty arrangement C. Basic arrangement D. General arrangement The answer is: B [/expand]

A. System software B. Operating system C. Utility program D. Device driver The answer is: B [/expand]

A. Name box B. Row headings C. Formula bar D. None of these The answer is: C [/expand]

A. Rule discover B. Signal processing C. Neural nets D. Case-based reasoning The answer is: C [/expand]

Related Posts