In MS-Excel, to repeat a text for a given number of times, we can use _______ function.

Question

Accepted Answer

The correct option is (4):
The correct Excel function to repeat a text string a specified number of times is **REPT**. This function, which is short for "Repeat Text," belongs to Excel's category of Text functions. It is highly versatile and requires two arguments: the text you want to repeat and the positive number that specifies how many times it should be repeated. For example, `=REPT("X", 4)` would result in "XXXX". This function is particularly useful for creating simple, in-cell histograms or for padding numerical data with a character, like a leading zero, to achieve a uniform string length for formatting.

The incorrect option is (1):
The **BAHTTEXT** function is a highly specialized Text function in Excel used exclusively for converting a numeric value into its Thai text equivalent, specifically representing an amount of Thai Baht currency. Its purpose is entirely unique and relates to financial and linguistic conversion, making it wholly inappropriate for the general operation of simply repeating a text string.

The incorrect option is (2):
Although the action described in the question is "repeat," there is **no** built-in function in the standard Microsoft Excel function library named simply **REPEAT**. This option is a common distractor designed to test whether students know the exact, abbreviated name of the text repetition function.

The incorrect option is (3):
The **EXACT** function serves a completely different purpose within Excel. It is a logical/text function that compares two text strings and returns a Boolean value, either TRUE or FALSE, based on whether the two strings are precisely identical, including whether they match in case. It is a comparison tool and does not possess any capability for repeating text.