Question

1
Choose the correct option,
i. If you enter the following in cell C5 of sheet 3: =sheet1!G5 which of the following
will happen?
a. Formula in cell G5 of sheet 1 will get copied to cell C5 of sheet 3.
b. Formula in cell C5 of sheet 3 will get copied to cell G5 of sheet 1.
C Data in cell G5 of sheet 1 will get copied to cell C5 of sheet 3.
d. Data in cell C5 of sheet 3 will get copied to cell G5 of sheet 1.​

Answer 1

Answer:

a is correct option

Explanation:

wheat flour and sisters and brothers of America

Answer 2

A correct option is (a).

Formulas of Excel:

• In excel "=" sign is used before the formula and select the cell range in which we want to apply the formula
• If we want to add the cell range from A1 to A10, we use the formula "=A1+A10" and then press enter
• If we want to edit the formula click on the formula bar on excel
• We also use various functions in excel like count, counta, sumif, concatenate, countif, etc.
• To select all the columns of A, we use the formula =(A: A)