O Level Exam

QUIZ ON : INFORMATION TECHNOLOGY TOOLS AND NETWORK BASIS - LIBREOFFICE CALC

LIBREOFFICE CALC

00:00:00

Question No# : 01 out of 20

What is the result of the formula = MAX (B1: B3) + MIN (B1: B3)? Where B1 = 5, B2 = 2, B3 = 7

A. 7,2

B. 7+2

C. 9

D. 5,7

Question No# : 02 out of 20

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

A. Sorting

B. Searching

C. Filtering

D. Validating

Question No# : 03 out of 20

Which shortcut key is used to exit from Worksheet in LibreOffice Calc?

A. Ctrl + w

B. Ctrl + Q

C. Ctrl + Shift + C

D. Shift + w

Question No# : 04 out of 20

How many columns does LibreOffice Calc contain

A. 1024

B. 1048576

C. 16384

D. None of These

Question No# : 05 out of 20

What you use to break (Split) a merged Cell in Libreoffice Calc

A. Center

B. Split Cells

C. Split and merge

D. Merge and center

Question No# : 06 out of 20

How many types of cell references in Libreoffice Calc?

A. 1

B. 2

C. 3

D. 4

Question No# : 07 out of 20

What you do to generate a list from Monday to Sunday in LibreOffice Calc?

A. Type Monday, hold down right corner and pull down

B. Do inter press by writing monday

C. = week () uses the function

D. All of the above

Question No# : 08 out of 20

Which program is used for fast and accurate calculations as well as formatting of data in a document ?

A. Calc

B. Base

C. Writer

D. Impress

Question No# : 09 out of 20

Row is replaced in column by which option?

A. Change

B. Text

C. Transpose

D. Convert

Question No# : 10 out of 20

What is the default file extension of LibreOffice Calc File ?

A. .odt

B. .ods

C. .odp

D. .xlsx

Question No# : 11 out of 20

What will happen if the Excel formula bar does not contain = before the formula?

A. #name?

B. #name

C. Whatever is written in a formula will remain the same

D. ####

Question No# : 12 out of 20

Which key do Libreoffice Calc use to move to the left (one step back) of the cell?

A. Alt +Tab

B. Tab

C. Alt

D. Shift + Tab

Question No# : 13 out of 20

If the cell address changes after copying the formula, the address is known as ____?

A. Relative address

B. Absolute address

C. Mixed address

D. Dynamic address

Question No# : 14 out of 20

In which menu is the Merge Cells command found in LibreOffice Calc?

A. Format

B. Style

C. Sheet

D. Edit

Question No# : 15 out of 20

From the following, which options are available in Edit menu?

A. Cut, Copy, Paste

B. Find and Replace

C. Select All

D. All of these

Question No# : 16 out of 20

Which key is used to enable editing the cell?

A. F2

B. Ctrl + Shift + M

C. Ctrl + M

D. F3

Question No# : 17 out of 20

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

A. Ctrl + Shift + 1

B. Ctrl + Shift + 5

C. Ctrl + Shift + 4

D. Ctrl + Shift + 3

Question No# : 18 out of 20

What is called to arrange data in ascending or descending order?

A. Sorting

B. Filter

C. Inserting

D. Deleting

Question No# : 19 out of 20

What is the intersection of rows and columns in libreoffice Calc?

A. Cell

B. Tabel

C. Position

D. Data

Question No# : 20 out of 20

Which shortcut key is used to select the total row?

A. Ctrl + Space

B. Shift + Space

C. Ctrl + Shift + Page down

D. None