Unique Computer Education-Ronak Gupta

Question 1

In LibreOffice Calc and Writer Ctrl + D have the same function ?

(A) True

(B) False

Question 2

What is formed by intersection of rows and columns in LibreOffice Calc ?

(A) Cell

(B) Tabel

(C) Position

(D) Data

Question 3

How many total sheet does LibreOffice Calc have ?

(A) 1,048,576

(B) 10,000

(C) 16,384

(D) NOTA ( None of the above )

Question 4

What is called to arrange data in order ?

(A) Sorting

(B) Inserting

(C) Filtering

(D) Deleting

Question 5

Maximum Zoom in LibreOffice Calc is ?

(A) 500%

(B) 400%

(C) 350%

(D) 600%

Question 6

Are the Round and Trunc functions the same ?

(A) True

(B) False

Question 7

The maximum Zoom % in LibreOffice Calc is ?

(A) 300%

(B) 200%

(C) 400%

(D) 500%

Question 8

Which shortcut key do you use to insert time in LibreOffice Calc ?

(A) Ctrl + ;

(B) Ctrl + Shift + ;

(C) Ctrl + T

(D) None

Question 9

Shortcut key for insert the Current Date in LibreOffice is

(A) Ctrl + ;

(B) Shift + D

(C) Ctrl + D

(D) Alt + D

Question 10

Where does the address of a cell appear in LibreOffice Calc ?

(A) Formula Bar

(B) Address Book

(C) Name box

(D) None

Question 11

Which shortcut key is used to select the total row ?

(A) Ctrl + Space

(B) Shift + Space

(C) Ctrl + Shift + Page down

(D) None

Question 12

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

(A) 1

(B) 15

(C) 56

(D) -1

Question 13

Which key will be used to select the entire seat in LibreOffice Calc ?

(A) Ctrl + A

(B) Ctrl + shift + Space

(C) Ctrl + Shift + A

(D) A & B both

Question 14

Spreadsheets allow us to organise , analyse and store data in tabular form ?

(A) True

(B) False

Question 15

When we select Save As options in Calc which information will ask in dialog box ?

(A) File name

(B) Location where the file is to be saved

(C) Both A and B

(D) None of these

Question 16

What is the address of the last column in LibreOffice Calc ?

(A) AMJ

(B) XFD

(C) AMG

(D) EMJ

Question 17

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

(A) 35

(B) -35

(C) 12

(D) 2

Question 18

What is the shortcut key to clear the formatting of Cell in LibreOffice Calc ?

(A) Ctrl + v

(B) Ctrl + M

(C) Ctrl + Shift + F

(D) Ctrl + 1

Question 19

Which character is use before starting the formula ?

(A) =

(B) *

(C) /

(D) -

Question 20

Which type of program is Calc ?

(A) Word processor

(B) Spreadsheet

(C) Presentation

(D) Database

Question 21

= Value of ROUND (275, -2) ..... ?

(A) 200

(B) 300

(C) 00

(D) 2.75

Question 22

What will be the value of = product (5,2) ?

(A) 10

(B) 3

(C) 7

(D) 1

Question 23

Which shortcut key is used to select the entire row ?

(A) Ctrl + Space

(B) Shift + Space

(C) Ctrl + Shift + Page down

(D) None

Question 24

Which tools are available on Standard toolbar ?

(A) Bold, Italics, Underline

(B) Left, Center, Right, Justify

(C) Font Name, Font Size, Font Color

(D) None of These

Question 25

What is the shortcut key to exit from LibreOffice Calc current windows ?

(A) Ctrl + w

(B) Ctrl + Q

(C) Ctrl + Shift + C

(D) Shift + w

Question 26

What is the matching point of row and column called ?

(A) Cell

(B) Column

(C) Row

(D) Sheet

Question 27

What is the shortcut key to open the Cell Format dialog box in LibreOffice Calc ?

(A) Shift + 1

(B) Ctrl + 1

(C) Alt + 1

(D) Ctrl + Alt + 1

Question 28

Which type of formulas and functions are present in spreadsheet ?

(A) Mathematical

(B) Financial

(C) Statistical, logical

(D) All of these

Question 29

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

(A) Format

(B) Style

(C) Sheet

(D) Edit

Question 30

In LibreOffice Calc or Writer, specify the shortcut key for Clear Format

(A) Ctrl + C

(B) Ctrl + M

(C) Ctrl + Shift + M

(D) None

Question 31

Calc is capable for which of the following ?

(A) Store data

(B) Manipulate data

(C) Create graphical representation of data

(D) All of these

Question 32

What is the last cell address in LibreOffice Calc ?

(A) $D$10

(B) AMJ1048576

(C) XFD1048576

(D) $AMD$1048576

Question 33

Which dialog box is open when we click Save As option in file menu ?

(A) Save As

(B) Save

(C) Save File

(D) Save As File

Question 34

What is the maximum number of worksheets in Calc ?

(A) 10000

(B) 1000

(C) 5000

(D) 255

Question 35

Which shortcut key do you use for cell formatting in LibreOffice Calc ?

(A) Ctrl + 1

(B) Ctrl + F2

(C) Ctrl + 2

(D) Ctrl + M

Question 36

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

(A) Data formatting

(B) Data sorting

(C) Data filtering

(D) Data validation

Question 37

LibreOffice is the shortcut to clear the direct format in Calc

(A) Ctrl + V

(B) Ctrl + M

(C) Ctrl + Shift + F

(D) Ctrl + 1

Question 38

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 39

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

(A) Format

(B) Style

(C) Sheet

(D) Edit

Question 40

There can be only one sheet in a spreadsheet of LibreOffice Calc ?

(A) True

(B) False

Question 41

What will be the value of =floor (1209,11) ?

(A) 1199

(B) 1210

(C) 1188

(D) None

Question 42

What will be the value of = round (247, -2) ?

(A) 247

(B) 200

(C) 240

(D) 200.47

Question 43

Which shortcut key you to highlights cells that containing values in LibreOffice Calc ?

(A) Ctrl + F6

(B) Ctrl + H

(C) Ctrl + F8

(D) Ctrl + F1

Question 44

Which key do you use to comment in LibreOffice ?

(A) Ctrl + Shift + C

(B) Ctrl + C

(C) Ctrl + Shift + T

(D) Ctrl + Alt + C

Question 45

LibreOffice Calc has number left alignment and alphabet right alignment ?

(A) True

(B) False

Question 46

What is the maximum number of worksheets LibreOffice Calc can have ?

(A) 256

(B) 1028

(C) 10000

(D) None of these

Question 47

What you do to write from Monday to Sunday in LibreOffice Calc ?

(A) 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 48

Which categories of functions are COS, EVEN, FACT, EXP in LibreOffice Calc ?

(A) Data

(B) Text

(C) Mathematical

(D) String

Question 49

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 t

(D) ####

Question 50

What is the default file extension of LibreOffice Calc ?

(A) .odt

(B) .ods

(C) .odp

(D) .xlsx

Question 51

In which format, spreadsheet gives permission for entering the data in it ?

(A) Horizontal

(B) Vertical

(C) Both A and B

(D) None of These

Question 52

Where is the name box located in LibreOffice Calc ?

(A) Bottom left of the menu bar

(B) Top left over menubar

(C) On the status bar

(D) Bottom right side of the menu bar

Question 53

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

(A) Sorting

(B) Searching

(C) Filtering

(D) Validating

Question 54

Which option is used to insert a chart ?

(A) Chart wizard

(B) Pie wizard

(C) Object

(D) Shap

Question 55

Which menu is used to toolbar can be turn off and on ?

(A) File

(B) Edit

(C) View

(D) Insert

Question 56

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

(A) Ctrl + Shift + P

(B) Ctrl + Shift + O

(C) Ctrl + P

(D) None of These

Question 57

Which type of facilities does spreadsheet gives to make the work easy ?

(A) To add data

(B) Formatting

(C) To add formula

(D) All of these

Question 58

What is included in Calc to prepare result analysis and merit list preparation ?

(A) Calculating result

(B) Sorting on result

(C) Filtering on result

(D) All of these

Question 59

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 60

What is called to filter data ?

(A) Sorting

(B) Inserting

(C) Filtering

(D) Deleting

Question 61

Which options are available in in scroll button on LibreOffice Calc ?

(A) Up and Down scroll

(B) Right and left

(C) Horizontal and Vertical

(D) All of above

Question 62

What is the default name of File in LibreOffice Calc ?

(A) Untitled1

(B) Calc1

(C) Spreadsheet1

(D) None of These

Question 63

Which of the following type of package does Calc refer to ?

(A) Spreadsheet

(B) Double sheet

(C) Multi-sheet

(D) Cannot determine

Question 64

Before printing we see the document on screen, what is called this process ?

(A) Print View

(B) Print Preview

(C) Print Screen

(D) Print Document

Question 65

What is the shortcut key to superscript in LibreOffice Calc ?

(A) Ctrl + Shift + B

(B) Ctrl + Shift + P

(C) Ctrl + Shift + +

(D) None of these

Question 66

How many rows and columns does LibreOffice Calc have ?

(A) 1048576 or 1024

(B) 1048576 or 16384

(C) 16384 or 1048576

(D) 1024 or 1048576

Question 67

LibreOffice Calc has alphabet right and numbers left align ?

(A) True

(B) False

Question 68

What is the shortcut to insert function in LibreOffice Calc ?

(A) Shift + F3

(B) Ctrl + F2

(C) Ctrl + F3

(D) Alt + F3

Question 69

How many number of row in LibreOffice Calc ?

(A) 1024

(B) 1048576

(C) 16384

(D) None

Question 70

Which key is used to edit the cell in edit mode ?

(A) F2

(B) Ctrl + Shift + M

(C) Ctrl + M

(D) F3

Question 71

Which sign is visible when there is a formula error in LibreOffice Calc ?

(A) $

(B) *

(C) /

(D) #

Question 72

Which key do you use 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 73

Dates and times stored in LibreOffice Calc internally treated as numbers ?

(A) True

(B) False

Question 74

In LibreOffice Calc A formula always starts with a symbol ?

(A) %

(B) $

(C) &

(D) =

Question 75

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

(A) Center

(B) Split

(C) Split and merge

(D) Merge and center

Question 76

How many cell does LibreOffice Calc contain ?

(A) 1072741823

(B) 1072741824

(C) 10482576

(D) 1073741824

Question 77

In Calc, most common commands present in which Bar ?

(A) Title bar

(B) Standard Toolbar

(C) Formatting Toolbar

(D) Formula Bar

Question 78

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

(A) Sorting

(B) Filter

(C) Inserting

(D) Deleting

Question 79

What is the shortcut key for Paste Special ?

(A) Ctrl + Shift + V

(B) Ctrl + V

(C) Ctrl + Alt + V

(D) Shift + V

Question 80

What is the name of mechanism to filter out unnecessary data ?

(A) Sorting

(B) Searching

(C) Filtering

(D) Validating

Question 81

In LibreOffice Calc, what is the value if there is a larger value than the cell (For Date Type)) ?

(A) ###

(B) सेल बड़ी हो जाती है और मान सही आता है

(C) ####

(D) #Name?

Question 82

= What will be the value of Ceiling (97,7) ?

(A) 98

(B) 97

(C) 91

(D) None

Question 83

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

(A) 400

(B) 6.25

(C) 7

(D) 500

Question 84

How many number of columns in LibreOffice Calc ?

(A) 1024

(B) 1048576

(C) 16384

(D) None

Question 85

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 86

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

(A) Find and replace

(B) By Copy only

(C) By copy command

(D) By preview command

Question 87

What will be the result of the formula =COUNT(B1: B3) ? Where B1 = 5, B2 = 4, B3 = 6 ?

(A) 15

(B) 3

(C) 4

(D) 5

Question 88

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 89

Which of the following program is a example of OpenOffice suit ?

(A) Calc

(B) Write

(C) Publisher

(D) Excel

Question 90

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 91

What is the default File Name of LibreOffice Clac ?

(A) Untitled1

(B) Calc1

(C) Spreadsheet1

(D) None

Question 92

What is the default file extension for a spreadsheet in LibreOffice Calc ?

(A) .odp

(B) .ods

(C) .odd

(D) .odt

Question 93

Which key do you use to move to the next seat ?

(A) Tab

(B) Ctrl + Tab

(C) Ctrl + Shift + Tab

(D) Shift + Tab

Question 94

How many seats we can insert in LibreOffice Calc ?

(A) 32000

(B) 48000

(C) 60000

(D) None of these

Question 95

Where are the options like line, curve, Polygon are available ?

(A) Shape

(B) Object

(C) Chart

(D) Pie

Question 96

LibreOffice Cal can convert entire cell into a single cell ?

(A) True

(B) False

Question 97

What is a spreadsheet in LibreOffice ?

(A) Draw

(B) Impress

(C) Calc

(D) Writer

Question 98

How many types of cell references are there in LibreOffice Calc ?

(A) 1

(B) 2

(C) 3

(D) 4

Question 99

What is Filter in LibreOffice Calc ?

(A) To view specific rows

(B) To see specific posts

(C) To view a specific cell

(D) All of the above

Question 100

In LibreOffice Calc, the shortcut key of formatting the cell is :

(A) Ctrl + 1

(B) Ctrl + F2

(C) Ctrl + 2

(D) Ctrl + M