Skip to content
Question of 29

Q.Monthly production of a company are given below:
Spreadsheet (columns A, B):
Row 1: Month | Production (Units)
Row 2: January | 25,000
Row 3: February | 20,000
Row 4: March | 22,000
Row 5: Total Production | ?
Row 6: Average Production | ?
Write the formula to calculate.

(a) Total production in cell B5.
(b) Average production in cell B6.
Punjab PsebPSEB Punjab Class 12 (Commerce) 2024Subjective· 2mImportance★★★★★
0% · 0/29 Questions
🔒 Locked · start free trial →

You're viewing a preview — the full solution, concept, methods & PYQ mapping are locked.

Start your 14-day free trial to unlock the full solution →

B5 = =SUM(B2:B4) = 67,000; B6 = =AVERAGE(B2:B4) = 22,333.33.

(a) Total production in cell B5: =SUM(B2:B4) = 25,000 + 20,000 + 22,000 = 67,000. …

Unlock everything free for 14 days

  • Full step-by-step solutions
  • Concept-first explanations
  • Methods, shortcuts & mistakes
  • PYQ mapping + timed mock tests

Full access for 14 days. No credit card required.