Chp 4- Libre office calc

In LibreOffice package, spreadsheet is called ...............

2 Mark(s)

Excel
Row
Column
Calc

What is the maximum number of characters in one cell in calc spreadsheet?

2 Mark(s)

6000
32767
255
1021

What is the file extension of LibreOffice Calc spreadsheet?

2 Mark(s)

.ods
..xlx
.odp
.odt

Which key is used to opens manage template in LibreOffice calc?

2 Mark(s)

Ctrl+T
Ctrl+F1
Ctrl+O
Ctrl+Shift+N

The combination of the column letter and row number for a cell in an Calc spreadsheet is called

2 Mark(s)

Cell across
Cell reference
Cell identify
Cell Identification number

Shortcut key used to opens the function wizard in LibreOffice Calc is ..................

2 Mark(s)

Alt+F1
Ctrl+F6
F2
Ctrl+F2

What is the output of the calc expression is = 100/10/2?

2 Mark(s)

5
25
50
200

Which shortcut key is used for reach to last edit cell in LibreOffice Calc?

2 Mark(s)

Ctrl+Home
Ctrl+End
Ctrl+H
Alt+Ctrl+O

LibreOffice Calc में function insert करने की shortcut key है?

2 Mark(s)

Shift + F3
Ctrl + F2
Ctrl + F3
Alt + F3

What is the shortcut key to increase the cell width in LibreOffice Calc?

2 Mark(s)

Alt + Left Arrow
Alt + Right Arrow
Ctrl + Right Arrow
None of Above

What is the shortcut command to open a new file in LibreOffice Calc?

2 Mark(s)

Ctrl + N
Ctrl + M
Ctrl + Shift + N
None of Above

How many spreadsheets on LibreOffice calc by default?

2 Mark(s)

0
1
2
3

What will result from adding = A1+A2 to calc?

2 Mark(s)

0
1
10
5

what is the maximum number of cell per spreadsheets in calc?

2 Mark(s)

6000
1000
1073741824
1048576

Which short cut key is used to insert function in LibreOffice Calc?

2 Mark(s)

Ctrl+F3
Ctrl+F1
Ctrl+F2
Ctrl+F4

=A1+10 displays the contents of cell A1 plus 10.

2 Mark(s)

True
False

Page down key is used to moves the viewable rows down one screen.

2 Mark(s)

True
False

Ctrl+F1 is used to display comments that is attached to the current cell.

2 Mark(s)

True 1
False

Ctrl+Shift+J is used for full screen mode in LibreOffice Calc.

2 Mark(s)

True
False

The LibreOffice Calc is similar to Microsoft Excel, with almost the same abilities.

2 Mark(s)

True
False

Which shortcut key is used to insert comment in LibreOffice Calc?

2 Mark(s)

Ctrl+Alt+C
Ctrl+Shift+J
Ctrl+Alt+S
None of the above

F7 key is used for spell check in the current sheet.

2 Mark(s)

True
False

What is the maximum zoom percentage in LibreOffice Calc?

2 Mark(s)

100%
200%
400%
500%

What is the maximum zoom percentage in LibreOffice Calc?

2 Mark(s)

100%
200%
400%
500%

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

2 Mark(s)

Home
Ctrl + Home
Alt + Home
None of above

What is the mail merge option in LibreOffice Calc?

2 Mark(s)

To mail a created file to someone
Used for mailing many people
Used to merge two mails together
None of Above

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

2 Mark(s)

Ctrl + 1
Ctrl + F2
Ctrl + 2
Ctrl + M

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

2 Mark(s)

Ctrl + ;
Ctrl + Shift + ;
Ctrl + T
None of the above

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

(A) F2

2 Mark(s)

F2
Ctrl + Shift + M
Ctrl + M
F3

What is the default file extension in LibreOffice Calc?

2 Mark(s)

.odt
.ods
.odp
.xlsx

What is the shortcut key of inserting function in LibreOffice Calc?

2 Mark(s)

Ctrl + F2
Ctrl + F4
Ctrl + F3
None of the above

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

2 Mark(s)

Ctrl + Shift + P
Ctrl + Shift + O
Ctrl + P
None of the above

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

2 Mark(s)

14
-14
5
None of the above

In LibreOffice Calc, Which symbol appears when a formula error occurs?

2 Mark(s)

$
*
#

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

2 Mark(s)

Cell
Table
Position
Data

What is the last column in LibreOffice Calc?

2 Mark(s)

AMJ
XFD
AMG
EMJ

In which menu, merge cells command is found?

2 Mark(s)

Format
Style
Sheet
Edit

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

2 Mark(s)

Ctrl + +
Ctrl + -
Ctrl + D
Delete

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

2 Mark(s)

###
Cell enlarges and result comes correctly
####
#Name?

which shortcut key is used for current date?

2 Mark(s)

Ctrl +:
Ctrl + ;
Ctrl + shift :
None of above

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

2 Mark(s)

1100
1173
1200
None of Above

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

2 Mark(s)

100
173
200
None of Above

How many total charts in LibreOffice Calc?

2 Mark(s)

8
5
10
None of Above

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

2 Mark(s)

Ctrl + +
Ctrl + -
Ctrl + D
Delete

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

2 Mark(s)

Ctrl + Home
Ctrl + End
Ctrl + Shift + Home
Ctrl + Shift + Home

How many maximum characters in one cell in LibreOffice Calc?

2 Mark(s)

32767
1048576
16384
1024

How many total rows are there in LibreOffice Calc?

2 Mark(s)

1024
1048576
16384
None of Above

How many total columns are there in LibreOffice Calc?

2 Mark(s)

1024
1048576
16384
None of Above

What is the minimum zoom in LibreOffice Calc?

2 Mark(s)

10
15
8
20

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

2 Mark(s)

Alt + Tab
Tab
Alt
Shift + Tab

Chp 4- Libre office calc : Question 1 of 50

In LibreOffice package, spreadsheet is called ...............

In LibreOffice package, spreadsheet is called ...............

What is the maximum number of characters in one cell in calc spreadsheet?

What is the maximum number of characters in one cell in calc spreadsheet?

What is the file extension of LibreOffice Calc spreadsheet?

What is the file extension of LibreOffice Calc spreadsheet?

Which key is used to opens manage template in LibreOffice calc?

Which key is used to opens manage template in LibreOffice calc?

The combination of the column letter and row number for a cell in an Calc spreadsheet is called

The combination of the column letter and row number for a cell in an Calc spreadsheet is called

Shortcut key used to opens the function wizard in LibreOffice Calc is ..................

Shortcut key used to opens the function wizard in LibreOffice Calc is ..................

What is the output of the calc expression is = 100/10/2?

What is the output of the calc expression is = 100/10/2?

Which shortcut key is used for reach to last edit cell in LibreOffice Calc?

Which shortcut key is used for reach to last edit cell in LibreOffice Calc?

How many spreadsheets on LibreOffice calc by default?

How many spreadsheets on LibreOffice calc by default?

What will result from adding = A1+A2 to calc?

What will result from adding = A1+A2 to calc?

what is the maximum number of cell per spreadsheets in calc?

what is the maximum number of cell per spreadsheets in calc?

Which short cut key is used to insert function in LibreOffice Calc?

Which short cut key is used to insert function in LibreOffice Calc?

=A1+10 displays the contents of cell A1 plus 10.

=A1+10 displays the contents of cell A1 plus 10.

Page down key is used to moves the viewable rows down one screen.

Page down key is used to moves the viewable rows down one screen.

Ctrl+F1 is used to display comments that is attached to the current cell.

Ctrl+F1 is used to display comments that is attached to the current cell.

Ctrl+Shift+J is used for full screen mode in LibreOffice Calc.

Ctrl+Shift+J is used for full screen mode in LibreOffice Calc.

The LibreOffice Calc is similar to Microsoft Excel, with almost the same abilities.

The LibreOffice Calc is similar to Microsoft Excel, with almost the same abilities.

Which shortcut key is used to insert comment in LibreOffice Calc?

Which shortcut key is used to insert comment in LibreOffice Calc?

F7 key is used for spell check in the current sheet.

F7 key is used for spell check in the current sheet.

What is the maximum zoom percentage in LibreOffice Calc?

What is the maximum zoom percentage in LibreOffice Calc?

What is the maximum zoom percentage in LibreOffice Calc?

What is the maximum zoom percentage in LibreOffice Calc?