Computer Science · Spreadsheet Formulas
In a spreadsheet, the data is structured as follows: Cell A1: 'Lunch Cost (Rs.)', Cell B1: 'Dinner Cost (Rs.)', Cell C1: 'Total Cost (Rs.)' Row 2: A2 = 15, B2 = 27, C2 = 42 Row 3: A3 = 23, B3 = 35, C3 = 58 Row 4: A4 = 10, B4 = 35, C4 = 45 Which of the formulas below is best for cell C2 so that it can be correctly copied down from C2 to both C3 and C4?
Verified Solution4 OptionsUpdated: October 2026👁️1 View
Share:
- 1=$A2 + B2✓
- 2=A2 + B2
- 3=A2 + B2
- 4=A$2 + $B2
Correct answer
=$A2 + B2
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!
Online Test Series
Start Free Mock Test →Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Chapter Practice
Practice Spreadsheet Formulas MCQs →Want more practice questions on Spreadsheet Formulas?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · Spreadsheet Formulas