Manipulation of Cells and Sheet

Qus. 1 : How many types of cell references in Libreoffice Calc?

1. 1
2. 2
3. 3
4. 4

Qus. 2 : If the cell address changes after copying the formula, the address is known as ____?

1. Relative address
2. Absolute address
3. Mixed address
4. Dynamic address

Qus. 3 : Which shortcut key is used to open the Cell Formant dialog box in Libreoffice Calc?

1. Shift + 1
2. Ctrl + 1
3. Alt + 1
4. Ctrl + Alt + 1

Qus. 4 : Which key is used to enable editing the cell?

1. F2
2. Ctrl + Shift + M
3. Ctrl + M
4. F3

Qus. 5 : Which shortcut key is used to insert time in LibreOffice Calc?

1. Ctrl + ;
2. Ctrl + Shift + ;
3. Ctrl + T
4. None

Qus. 6 : In Libreoffice Calc, what is the value if there is a larger value than the cell (For Date Type)?

1. ###
2. The cell size increase automatically
3. ####
4. #Name?

Qus. 7 : Which shortcut key is used to delete a cell in LibreOffice Calc?

1. Ctrl + +
2. Ctrl + -
3. Ctrl + D
4. Delete

Qus. 8 : Which shortcut key is used to convert a number into currency format in LibreOffice Calc?

1. Ctrl + Shift + 1
2. Ctrl + Shift + 5
3. Ctrl + Shift + 4
4. Ctrl + Shift + 3

Qus. 9 : Which shortcut key is used to clear the formatting of Cell in LibreOffice Calc?

1. Ctrl + v
2. Ctrl + M
3. Ctrl + Shift + F
4. Ctrl + 1

Qus. 10 : Which shortcut key is used to move from one sheet to the next sheet in LibreOffice Calc?

1. Tab
2. Ctrl + Tab
3. Ctrl + Shift + Tab
4. Shift + Tab

Qus. 11 : Which shortcut key is used to highlights cells that containing values in LibreOffice Calc.

1. Ctrl + F6
2. Ctrl + H
3. Ctrl + F8
4. Ctrl + F1

Qus. 12 : What you do to generate a list from Monday to Sunday in LibreOffice Calc?

1. Type Monday, hold down right corner and pull down
2. Do inter press by writing monday
3. = week () uses the function
4. All of the above

Qus. 13 : Which shortcut key is used for Paste Special in LibreOffice Calc?

1. Ctrl + Shift + V
2. Ctrl + V
3. Ctrl + Alt + V
4. Shift + V

Qus. 14 : Which of the following technique can be used to allow only date value in cell ?

1. Data formatting
2. Data sorting
3. Data filtering
4. Data validation

Qus. 15 : We can replace multiple occurrences of a word using which of the following facilities of Calc?

1. Find and replace
2. By Copy only
3. By copy command
4. By preview command

Qus. 16 : What is the name of mechanism to arrange the data in a particular order?

1. Sorting
2. Searching
3. Filtering
4. Validating

Qus. 17 : Which mechanism is used to filter out unnecessary data in Calc LibreOffice?

1. Sorting
2. Searching
3. Filtering
4. Validating

Qus. 18 : In which of the following category of package Calc falls ?

1. Spreadsheet
2. Double sheet
3. Multi-sheet
4. Cannot determine

Qus. 19 : Which shortcut key is used to clear the formatting of cells in LibreOffice Calc

1. Ctrl + V
2. Ctrl + M
3. Ctrl + Shift + F
4. Ctrl + 1

Qus. 20 : What is the shortcut key to superscript in Libreoffice Calc?

1. Ctrl + Shift + B
2. Ctrl + Shift + P
3. Ctrl + Shift + +
4. None of these

Qus. 21 : Which character is use before starting the formula in LibreOffice calc?

1. =
2. *
3. /
4. -

Qus. 22 : Row is replaced in column by which option?

1. Change
2. Text
3. Transpose
4. Convert

Qus. 23 : What is included in Calc to prepare result analysis and merit list preparation ?

1. Calculating result
2. Sorting on result
3. Filtering on result
4. All of these

Qus. 24 : What is called to arrange data in order?

1. Sorting
2. Inserting
3. Filtering
4. Deleting

Qus. 25 : What is called to filter data?

1. Sorting
2. Inserting
3. Filtering
4. Deleting

Qus. 26 : What is called to arrange data in ascending or descending order?

1. Sorting
2. Filter
3. Inserting
4. Deleting

Qus. 27 : What is the correct way to enter a function in Calc?

1. Directly typing function name in a cell
2. Using function wizard or selecting from toolbar
3. Both (a) and (b)
4. Depends on the function

Qus. 28 : How many axes are presents in charts of LibreOffice Calc?

1. Two
2. Three
3. Four
4. Five

Qus. 29 : Which of the following are the features of spreadsheet software?

1. Instant messaging, address book, antivirus, mailing list
2. Forms, data analysis, conditional formatting, sorting and filtering
3. Graphics, templates, spell checker, thesaurus
4. Accessibility, multimedia, hyperlinks, updated

Qus. 30 : Which is not true for Flip action in LibreOffice Calc?

1. Flipping a selection convert it into a floating selection
2. Flip Horizontal flip the left side to the right side
3. Flip Horizontal flips the right to the left side
4. Flip vertical flips the top to the bottom

Qus. 31 : Comments in LibreOffice Calc can be____?

1. Edited
2. Shown
3. Deleted
4. All the above

Qus. 32 : in LibreOffice Calc Spreadsheet file can be emailed as

1. OpenDocument
2. Microsoft Excel
3. PDF
4. All the above

Qus. 33 : What is the shortcut key for cell edit mode?

1. Ctrl+F12
2. F2
3. Ctrl+1
4. Ctrl+F1

Programs

---

---

---

---

---

---

---

---