Electronic Spreadsheet Quiz 6

Q51. Rename sheet option is available in ____________ menu.

Q52. Extension of LibreOffice Calc file is __________________

Q53. To insert the column before any column select _______________

Q54. When we drag a formula, address of the cell used in formula will automatically change.(T/F)

Q55. Evaluate the following expression, if cell A1, B1 and C1 has values 10, 20 and 30 respectively.

=A1 * B1 - C1

Q56. Evaluate the following expression, if cell A1, B2, C2 and D3 has values 10, 2, 2, 36.

=(D3/(A1+B2))^C2

Q57. ___________ is the function in LibreOffice Calc to get the sum of range of cells.

Q58. Which of the following will return the sum of Cell A1 to E1.

Q59. Which of the following is a formula ?

= D2+D3+D4+D5+D6+D7 –---- A

= A1 + B1 + SUM (D2:D7) ------ B

Q60. Which of the following function calculate the average in LibreOffice Calc?