1 Which function is used to extract a specified number of characters from the beginning of a text string?
a) MID
b) RIGHT
c) LEFT
d) CONCATENATE
Answer: c) LEFT
2 What is the result of the formula =RIGHT(“Excel 2024”, 4)?
a) “Excel”
b) “2024”
c) “202”
d) “2024 ”
Answer: b) “2024”
3 How does the formula =MID(“Programming”, 4, 5) work?
a) Returns “ogram”
b) Returns “gramm”
c) Returns “ogramm”
d) Returns “ogrammi”
Answer: a) Returns “ogram”
4 Which function combines multiple text strings into one text string?
a) MID
b) CONCATENATE
c) LEFT
d) RIGHT
Answer: b) CONCATENATE
5 What is the result of the formula =CONCATENATE(“Hello”, ” “, “World”)?
a) “Hello World”
b) “HelloWorld”
c) “Hello”
d) ” WorldHello”
Answer: a) “Hello World”
6 What does the formula =LEFT(“Data Analysis”, 4) return?
a) “Data”
b) “Data ”
c) “Data Analysis”
d) “Ana”
Answer: a) “Data”
7 In the formula =MID(“Excel Functions”, 7, 9), what does the number 7 specify?
a) The starting position in the text string
b) The number of characters to extract
c) The length of the entire text string
d) The ending position in the text string
Answer: a) The starting position in the text string
8 Which function is used to extract characters from the end of a text string?
a) LEFT
b) CONCATENATE
c) RIGHT
d) MID
Answer: c) RIGHT
9 What will be the result of the formula =CONCATENATE(“Year”, ” “, 2024)?
a) “Year 2024”
b) “Year2024”
c) “Year 2024 ”
d) “Year2024 ”
Answer: a) “Year 2024”
10 What is the output of the formula =MID(“Excel Functions”, 7, 10)?
a) “Functions”
b) “Excel Function”
c) “Functions ”
d) “Functions s”
Answer: a) “Functions”