Ms xecel

1. What does the TRIM function do in Excel?

• a) Removes all spaces from a text string
• b) Removes extra spaces except for single spaces between words
• c) Converts text to uppercase
• d) Removes special characters

2. What does the LOWER function do in Excel?

• a) Converts text to uppercase
• b) Converts text to lowercase
• c) Capitalizes the first letter of each word
• d) Replaces lowercase letters with numbers

3. Which function is used to find the row number of a value in a column?

• a) INDEX
• b) MATCH
• c) HLOOKUP
• d) OFFSET

4. What is the main difference between VLOOKUP and HLOOKUP?

• a) VLOOKUP searches horizontally, HLOOKUP searches vertically
• b) VLOOKUP searches vertically, HLOOKUP searches horizontally
• c) VLOOKUP can only search in sorted data
• d) HLOOKUP can only search in sorted data

5. Which combination is more flexible than VLOOKUP for looking up values?

• a) SUMIF & COUNTIF
• b) CONCATENATE & SUBSTITUTE
• c) INDEX & MATCH
• d) HLOOKUP & IF

6. What will the formula =IF(A1>10,"High","Low") return if A1 is 5?

• a)low
• b)High
• c)10
• d)Error

7. What will the formula =AND(A1>5, A1<15) return if A1 is 20?

• b) FALSE
• a) TRUE
• c) 20
• d) Error

8. Which function extracts a substring from the middle of a text string?

• a) LEFT
• c) RIGHT
• b) MID
• d) FIND

9 .  Which type of spaces does the TRIM function remove?

• a) Leading spaces
• b) Trailing spaces
• c) Extra spaces between words
• d) All of the above

10. What will the formula =PROPER("hello world") return?

• a) hello world
• b) HELLO WORLD
• c) Hello World
• d) HeLLo WoRLD