Question

Given the Following Spreadsheet, Write the appropriate Formula/ Expression/

Function to be used for (a) to (e)

a) Write formula to calculate the Total Qty(C4:C7)) in cell C8

b) Write the feature used for arranging the Price from Highest to Lowest

c) To find the Product with Maximum Price to be written in Cell D10

d) To find the Average Qty to be written in cell C9

e) Write formula to calculate the Total Amount in cell E8

Answer 1

A) Move to the cell C8.

Then write the formula SUM(C4:C7).

This formula will return the sum of the values present from cell C4 to C7.

B) The feature used for arranging the price from the highest to the lowest is called SORT.

The formula is =LARGE(data, ROWS(exp_rng)).

C) To find the product, move to cell no. C10.

Then use the formula = PRODUCT( num1, num2, ... num n )

D) To find the average, move to cell no. C9

Then write the formula =AVG(num1, num2, num3.....num n).

E) To calculate the total amount, move to the cell E8,

and write the formula = SUM(num1, num2, num3....num n).

Answer 2

Answer:

$12 \frac{ \frac{52 \times \frac{?}{?} \times \frac{?}{?} }{?} }{?}$

jcjlhkgjfhvjchcjxx