Computer Science · Microsoft Excel
If the formula =IF(B5 > 100, 'A', 'A*') is entered in the cell C5, and the cell B5 at different instances contains the values 75, 150 and 100, then cell C5 will have the following values respectively:
- 1A*, A*, A*
- 2A*, A, A
- 3A, A*, A
- 4A*, A, A*✓
Correct answer
A*, A, A*
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 Computer Science mock tests with real exam timers, instant score analysis, and all-India ranking.
Want more practice questions on Microsoft Excel?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · Microsoft Excel