Current Affairs · Information Technology
In a spreadsheet program like Microsoft Excel, which of the following formulas should be entered into cell B3 to print 'Within Budget' if cell A2 is less than or equal to 100, and 'Over Budget' if cell A2 is greater than 100?
- 1=IF(A2 <= 100, 'Within Budget', 'Over Budget')✓
- 2=IF(A2 <= 100, 'Over Budget', 'Within Budget')
- 3=IF(A2 >= 100, 'Over Budget', 'Within Budget')
- 4=IF(A2 < 100, 'Within Budget', 'Over Budget')
Correct answer
=IF(A2 <= 100, 'Within Budget', 'Over Budget')
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 Current Affairs?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Want more practice questions on Information Technology?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Current Affairs · Information Technology