Question

3 Choose the correct option.
a. A4 represents which
type
of referencing?
i. Relative
ii. Absolute
iii. Mixed
iv. None of these
b. Which function is used to find the average of a list of values?
i. AVG
ii. AVERAGE
iii. AV
iv. None of these
C. If cell C1 has the formula =A1+B1 and it is copied to cell E1, then what will be the formula
in cell E1?
i. =A1+B1
ii. =B1+C1
iii. =C1+D1
iv. None of these
d. If cell B2 has the formula =A1* A2* $D$2 and it is copied to cell C2, then what will be the
formula in cell C2?
i. =A1* A2 * $D$2
ii. =B1*B2* $D$2
iii. =A1*B2* $D$2
iv. =B1*A2* $D$2
e. Which symbol is used for concatenation of text values?
iv. @
III. &
i. $
1. #​

Answer 1

Answer:

gm hm hm gj ung udhhjdbhahnbxhiwbbudbbxjinq jdubsb63-873&7-₹+73-+₹!+83-76478

Answer 2

Answer:

which symbol is used for concatenation of text values