Skip to content
Question of 29

Q.The monthly sales of a company for the first six months are given below in Rupees (₹).
Spreadsheet (columns A, B):
Row 1: January | 25,000
Row 2: February | 15,000
Row 3: March | 28,000
Row 4: April | 32,000
Row 5: May | 20,000
Row 6: June | 36,000
Write the formulae to calculate Sale:

(a) Find the total sale for the six months
(b) Find the average sale of the six months
(c) Find the lowest sale of the six months
(d) Find the highest sale of the six months
Punjab PsebPSEB Punjab Class 12 (Commerce) 2025Subjective· 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,56,000; AVERAGE = 26,000; MIN = 15,000; MAX = 36,000.

Monthly sales are in cells B1:B6 (Jan 25,000; Feb 15,000; Mar 28,000; Apr 32,000; May 20,000; Jun 36,000).

  1. Total sale: =SUM(B1:B6) = 25,000+15,000+28,000+32,000+20,000+36,000 = 1,56,000.
  2. Average sale: =AVERAGE(B1:B6) = 1,56,000/6 = 26,000.
  3. Lowest sale: =MIN(B1:B6) = 15,000 (February). …

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.