Computer · MS Excel
Match the Excel formulas/expressions in Column 1 with their correct outputs in Column 2: Column 1 (Formula) (a) =MID('mumbai metro', 8, 5) (b) =REPT('mumbai metro', 3) (c) =DEC2HEX(11) (d) =PROPER('mumbai metro') Column 2 (Output) (i) Mumbai Metro (ii) metro (iii) mumbai metromumbai metromumbai metro (iv) B
- 1a - iv, b - iii, c - i, d - ii
- 2a - ii, b - iii, c - iv, d - i✓
- 3a - ii, b - iv, c - iii, d - i
- 4a - iii, b - ii, c - iv, d - i
Correct answer
a - ii, b - iii, c - iv, d - i
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Preparing for Computer?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Want more practice questions on MS Excel?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer · MS Excel