Question

I.
A spreadsheet which is also known its worksheet is in electronic document in which data in
orgamsed in the cows and columns of a grid and can be used in calculations. The intersection of
each row and column is called cell li muy hold numbers, formulas, text! dute and ume etc. A
formula isitin equation that calculates the value to be displayed. A formula when used in a
worksheet must begin with an equal to 1=)sign. A cell address is recognised by column label and
row number. e.gi
: C2 where, G is a column label and 2 is a row number
Given following spreadshect.i write the appropriate formula/expression/function to be used for (i) to (v)
FRUIT NAME
MANGO
BANANA
APPLE
WATERMELON
GUAVA
TOTAL
MAXIMUM
QTY: (NUM) PRICE
120
60
10
50
12
30
15 100
ii.
Write formula to calculate the Total Qty (B2: B6) in Cell B7)
Write the feature used for arranging the price from highest to lowest.
To find the maximum price to be written in cell CR.
To find the maximum quantity to be written in cell B8,
Write the formula to calculate average of quantity!​

Answer 1

Answer:

75 of a good 5 a few years of age group is not working in our area in our prayers in this email in a few weeks and then the same as well but it will 5556ygr a good weekend to be there for me I can see that you can do 2 and then the following link below the following the instructions to get it is