Comprehension

The monthly sales of a company for the first six months are given below in Rupees (₹):

Write the formulae to calculate Sales:

Question: 1

Find the total sale for the six months.

Show Hint

Use SUM() to add a range of values in Excel.
Updated On: Feb 16, 2026
Hide Solution
collegedunia
Verified By Collegedunia

Solution and Explanation

The SUM function is used to calculate the total sales of all six months by adding the values in cells B2 to B7.
Was this answer helpful?
0
0
Question: 2

Find the average sale of the six months.

Show Hint

AVERAGE() gives the mean value of selected cells.
Updated On: Feb 16, 2026
Hide Solution
collegedunia
Verified By Collegedunia

Solution and Explanation

The AVERAGE function calculates the mean of the sales values for the six months.
Was this answer helpful?
0
0
Question: 3

Find the lowest sale of the six months.

Show Hint

MIN() returns the smallest value from a given range.
Updated On: Feb 16, 2026
Hide Solution
collegedunia
Verified By Collegedunia

Solution and Explanation

The MIN function is used to find the lowest sales value among the six months.
Was this answer helpful?
0
0
Question: 4

Find the highest sale of the six months.

Show Hint

MAX() returns the largest value from a given range.
Updated On: Feb 16, 2026
Hide Solution
collegedunia
Verified By Collegedunia

Solution and Explanation

The MAX function is used to find the highest sales value among the six months.
Was this answer helpful?
0
0

Top Questions on Data Handling

View More Questions

Questions Asked in PSEB exam

View More Questions