Electronic Spreadsheet Quiz 10

Share with others

Welcome to your Electronic Spreadsheet Quiz 10

Name
Email
School Name
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