Computer Science · Office Automation Tools
Match the following MS Excel formulas with their correct outputs: Formulas: a. =LEFT('Microsoft Excel', 5) b. =LOWER('HELLO WORLD') c. =SUM(10, 5, 11) d. =AVERAGE(100, 120, 150) Outputs: i) 26 ii) 123.33 iii) hello world iv) Micro
- 1a - iv, b - iii, c - i, d - ii✓
- 2a - iii, b - iv, c - i, d - ii
- 3a - iv, b - i, c - iii, d - ii
- 4a - iv, b - iii, c - ii, d - i
Correct answer
a - iv, b - iii, c - i, d - ii
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 Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Want more practice questions on Office Automation Tools?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · Office Automation Tools