10th

Jun

Jun

# LibreOffice Calc MCQ

- Admin
- 10th Jun, 2022
- 663 Followers

#### Latest MCQ Tests

#### Pratice HR Questions

## LibreOffice Calc MCQ Online Test

Following are mostly asked

**Libreoffice calc MCQ test**that are designed for professionals like you to crack you interviews. You can take this**Libreoffice calc online test**before appearing to you real interview. This**Libreoffice calc quiz**there are around 30+ multiple choice questions on Libreoffice calc with four options.### 1) How many columns are there in libreoffice calc:

### 2) The shortcut key to insert a function in libreoffice calc?

### 3) COS, EVEN, FACT, EXP are functions of which category in Libreoffice Calc?

### 4) To break a merged cell in Libreoffice Calc, you have to select that cell and click on the ……… button?

### 5) Which sign is visible when there is a Formula Error in Libreoffice Calc?

Download Free : LibreOffice Calc MCQ PDF

### 6) LibreOffice Calc by default provides an auto calculator feature that displays as if in a selected range range?

### 7) What will be the value of = 10 * 20/4 * 8 in libreoffice calc?

### 8) In LibreOffice Calc, the shortcut key of going at the last of left of the cell is?

### 9) What is the last column in LibreOffice Calc?

### 10) What is the combination of row and column in LibreOffice Calc?

### 11) What will be the result of product (7,-2)?

### 12) What is the shortcut key of print preview in LibreOffice Calc?

### 13) What is the shortcut key of edit mode of a cell in LibreOffice Calc?

### 14) What is the shortcut key of inserting time in LibreOffice Calc?

### 15) What is the shortcut key of formatting of the cell in LibreOffice Calc?

### 16) In which menu, merge cells command is found?

### 17) What is the shortcut key of deleting of the cell in LibreOffice Calc?

### 18) In LibreOffice Calc, if the value is larger than the cell space, what result comes?

### 19) What is maximum zoom in LibreOffice Calc?

### 20) What is the minimum zoom in LibreOffice Calc?

### 21) How many total rows are there in LibreOffice Calc?

### 22) How many maximum characters in one cell in LibreOffice Calc?

### 23) What is the shortcut key to reach of last cell of a spreadsheet in LibreOffice Calc?

### 24) What is the shortcut key for adding cell in LibreOffice Calc?

### 25) How many total charts in LibreOffice Calc?

### 26) What is the value of =round (175,-2)?

### 27) What is the value of =round (1175,-2)?

### 28) Which shortcut key is used for current date?

### 29) What is the mail merge option in LibreOffice Calc?

### 30) What is the shortcut key to reach first column in LibreOffice Calc?

### 31) What is the default file extension of LibraOffice Calc?

### 32) Libra Office Calc is the spreadsheet component of LibreOffice.

### 33) ___ allows us to organise, analyse and store data in tabular form.

### 34) In LibreOffice Calc a formula start with a symbol ____.

### 35) What will be the result of the formula MAX(B1:B3)+MIN(B1:B3) if B1=5, B2=2, B3=7?

### 36) In LibreOffice Calc the address of any Cell is shown in ___.

### 37) What is the shortcut key to close the Libra Office Calc's Current Window?

### 38) Which of the following displays the contents of the cell B1 plus B2?

### 39) Which of the following formula calculates sum of the cells B10 to B14?

### 40) Which of the following formula displays the result of the multiplication of A1 and A2?

### 41) Which of the following used for displaying and editing data functions(such as sum, percentage, etc)?

### 42) Formatting toolbar contains text formatting controls.

### 43) ___ displays the information about the current status of a program,

### 44) ___, as opposed to ____, determines a fixed location of the cell.

### 45) In LibreOffice Calc, ____ are predefined expressions (formulas) that perform a calculation using values called function arguments.

#### Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.