18-05-23

Which shortcut key is used to select the all row?

• Ctrl+Space

• Shift+Space

• Ctrl+Shift+Pagedown

• None

Cos,Even, Fact, Exp are the function of which category in Libreoffice Calc?

• Data

• Text

• Mathematical

• String

What is the name of mechanism to arrange the data in a particular order?

• Sorting

• Searching

• Filtering

• Validating

We can replace multiple occurrences of a word using which of the following facilities of calc?

• Find and Replace

• BY copy only

• By copy command

• By Preview Command

Are the Round and Trunc functions the same?

• True

• False

• Round

• Trunc

Answer explanation

=round(4.7)give the result 5 where = trunc(4.7) gives the 4 round function rounds the number where trunc remove(truncate) the decimal value.

LIbreoffice Calc can Convert entire cell into a single cell?

• True

• False

Libreoffice Calc has alphabet right and numbers left align?

• False

• True

LibreOffice calc has number left alignment and alphabat right alignment?

• True

• False

What will be the value of =Product(7,8)?

• 1

• 15

• 56

• 216

What will be the value of =10*20/4*8 in LibreOffice Calc?

• 6.25

• 7

• 500

• 400