3 Choose the correct option. a. A4 represents whichtypeof referencing?i. Relativeii. Absoluteiii. Mixediv. None of theseb. Which function is used to find the average of a list of values?i. AVGii. AVERAGEiii. AViv. None of theseC. If cell C1 has the formula =A1+B1 and it is copied to cell E1, then what will be the formulain cell E1?i. =A1+B1ii. =B1+C1iii. =C1+D1iv. None of thesed. If cell B2 has the formula =A1* A2* $D$2 and it is copied to cell C2, then what will be theformula in cell C2?i. =A1* A2 * $D$2ii. =B1*B2* $D$2iii. =A1*B2* $D$2iv. =B1*A2* $D$2e. Which symbol is used for concatenation of text values?iv. @III. &i. $1. #

3 Choose the correct option. a. A4 represents whichtypeof referencin

1.	3 Choose the correct option. a. A4 represents whichtypeof referencing?i. Relativeii. Absoluteiii. Mixediv. None of theseb. Which function is used to find the average of a list of values?i. AVGii. AVERAGEiii. AViv. None of theseC. If cell C1 has the formula =A1+B1 and it is copied to cell E1, then what will be the formulain cell E1?i. =A1+B1ii. =B1+C1iii. =C1+D1iv. None of thesed. If cell B2 has the formula =A1* A2* $D$2 and it is copied to cell C2, then what will be theformula in cell C2?i. =A1* A2 * $D$2ii. =B1B2 $D$2iii. =A1B2 $D$2iv. =B1A2 $D$2e. Which symbol is used for concatenation of text values?iv. @III. &i. $1. #
Answer» GM HM hm GJ UNG udhhjdbhahnbxhiwbbudbbxjinq jdubsb63-873&7-₹+73-+₹!+83-76478