Electronic Spreadsheet Quiz 10

Share with others

Welcome to your Electronic Spreadsheet Quiz 10

Q91. There are _____________ types of referencing in LibreOffice Calc.

Q92. =A1 + B1 is an example of _____________ referencing.

Q93. When you drag any formula in any row or column in any direction, the formula changes accordingly. This is a type of ____________referencing.

Q94. When the formula =C2 * D2 is dragged from cell E2 to E6 then the formula in cell E6 will be __________________

Q95. When the formula =C2 * D2 is dragged from cell E2 to G2 then the formula in cell G2 will be __________________

Q96. To view the formula used in a cell select ______________

Q97. C$14. This formula is an example of ____________ referencing.

Q98. When the formula = H2 + C$14 is dragged from cell J2 to J11 then the formula in cell J11 will be ________

Q99. Which of the following symbol is used in referencing, to freeze a column or a row.

Q100. A _________referencing is a referencing in which one cell address name is variable and one cell address is constant.


Share with others

Leave a Reply

error: Content is protected !!