Skip to content
Question of 29

Q.The monthly production of a company is given below:
Spreadsheet (columns A, B):
Row 1: January | 25000
Row 2: February | 20000
Row 3: March | 22000
Row 4: April | 18000
Row 5: May | 19000
Row 6: June | 24000
Write the formulas to calculate:

(a) Find the total production for the six months.
(b) Find the average production for the six months.
(c) Find the lowest production of the six months.
(d) Find the highest production of the six months.
Punjab PsebPSEB Punjab Class 12 (Commerce) 2026Subjective· 4mImportance★★★★★
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 →

SUM = 1,28,000; AVERAGE = 21,333.33; MIN = 18,000; MAX = 25,000.

Monthly production is in cells B1:B6 (Jan 25,000; Feb 20,000; Mar 22,000; Apr 18,000; May 19,000; Jun 24,000).

  1. Total production: =SUM(B1:B6) = 1,28,000.
  2. Average production: =AVERAGE(B1:B6) = 1,28,000/6 = 21,333.33.
  3. Lowest production: =MIN(B1:B6) = 18,000 (April). …

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.