Reading Mode - SSC(ENG)

MCQ 1 ALL

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

A Word processor

B Spreadsheet

C Presentation

D Database SUN

MCQ 2 ALL

In Calc,a function or formula can start with which of the following sign ?

A =

B @

C #

D &

MCQ 3 ALL

Which of the following is the extension of a worksheet created in Calc?

A .odc

B .odt

C .ods

D .odb

MCQ 4 ALL

By default, Calc spreadsheet contains how many worksheets?

A 2

B 3

C 4

D 5

MCQ 5 ALL

Which of the following will be inserted in a worksheet if =starcalcteam() is inserted in a Calc cell ?

A Stars

B Photograph of Calc developer team

C Calc license information

D Calc license information

MCQ 6 ALL

Which of the following applications are not suitable for Calc?

A Balance sheet preparation

B Result analysis

C Presenting an idea about a product

D All of these

MCQ 7 ALL

How can one calculate total of values entered in a worksheet in a Calc document ?

A By manual entry

B By AutoSum

C By formula

D All of these

MCQ 8 ALL

How many maximum worksheet in spreadsheet document ?

A 24

B 64

C 256

D 65536

MCQ 9 ALL

How many menu is available in Calc ?

A 6

B 7

C 8

D 9

MCQ 10 ALL

Which sign is available on bottom right side of the active cell ?

A +

B #

C -

D *

MCQ 11 ALL

How many rows in Calc ?

A 65516

B 65526

C 65536

D 65546

MCQ 12 ALL

How many columns in Calc ?

A 226

B 236

C 246

D 256

MCQ 13 ALL

Which is the basic element of a spreadsheet ?

A Cell

B Worksheet

C Workbook

D Row and Column

MCQ 14 ALL

In which form scroll bar is seen in Calc ?

A Horizontal

B Vertical

C Both (A) and (B)

D None of these

MCQ 15 ALL

To add or remove toolbar which option is used ?

A File -> Toolbars

B Insert -> Toolbars

C View -> Toolbars

D Format -> Toolbars

MCQ 16 ALL

Which menu option is used to rename a worksheet ?

A Format -> Sheet -> Rename

B Format -> Sheet -> Modify

C Edit -> Sheet -> Rename

D Edit -> Sheet -> Modify

MCQ 17 ALL

Which key is pressed to see the result after entering formula in Calc ?

A Insert key

B Ctrl key

C Enter key

D Shift key

MCQ 18 ALL

Which of the following option is used to add the values between cell A1 to A5 in Calc ?

A (=A1+A2+A3+A4+A5

B (=SUM(A1:A5)

C S button

D All of these

MCQ 19 ALL

On which bar S symbol does appear ?

A Title bar

B Formula bar

C Symbol bar

D Format bar

MCQ 20 ALL

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

A Spreadsheet

B Multi-sheet

C Double sheet

D Cannot be determined

MCQ 21 ALL

which of the following are basic components of spreadsheet.

A Workbook, worksheet

B Row, column

C Cell

D All of the given

MCQ 22 ALL

Worksheet is a collection of

A row

B column

C workbook

D Both A and B

MCQ 23 ALL

Which of the following represents an entity

A workbook

B worksheet

C column

D row

MCQ 24 ALL

Which of the following represents an records

A workbook

B worksheet

C column

D row

MCQ 25 ALL

What is an intersection of row and column.

A workbook

B worksheet

C cell

D all of the given

MCQ 26 ALL

For which of the following application, spreadsheet package is useful ?

A Balance sheet preparation

B Result analysis

C Statistical data analysis

D All of the given

MCQ 27 ALL

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

A Spreadsheet

B Multi-sheet

C Double sheet

D all of the given

MCQ 28 ALL

which bar shows name of the program

A Formatting

B Title

C Tool

D Formula

MCQ 29 ALL

The default name given to the Calc file is

A defaulti

B untitled1

C Calc1

D all of the given

MCQ 30 ALL

Which menu contains the commands to operate the entire document such as creating a new document, saving file,printing, print preview, etc.

A File

B Edit

C View

D Insert

MCQ 31 ALL

which menu contains editing commands such as cut, copy, paste, find and replace etc

A File

B Edit

C View

D Insert

MCQ 32 ALL

Which of the following menu is used for adding or removing elements of the user interface, page break preview, etc.?

A File

B Edit

C View

D Insert

MCQ 33 ALL

Which of the following can be done using Format menu?

A Cell formatting

B Grouping of elements

C Sorting, Conditional formatting

D All of the given

MCQ 34 ALL

When any option of submenu contains shape, that means there are more suboptions available with the option.

A ▶

B ◀

C >

D <

MCQ 35 ALL

The Cale worksheet contains

A 65536

B 65256

C 1048576

D 16.256.536

MCQ 36 ALL

The Cale worksheet contains columns

A 1024

B 256

C 16256

D 65536

MCQ 37 ALL

The cell whose border is thick and dark black is known as

A A dark cell

B active cell

C formula cell

D none of the given

MCQ 38 ALL

By default. Cale spreadsheet contains worksheets.

A 1

B 2

C 3

D 4

MCQ 39 ALL

In Calc. displays the name of an active cell.

A formula bar

B name box

C column header

D row header

MCQ 40 ALL

There are maximum_______ worksheets per Cale spreadsheet document.

A 255

B 256

C 250

D 265

MCQ 41 ALL

The headers which are numbered are called in ______Cale.

A column header

B row header

C workbook header

D name header

MCQ 42 ALL

The height of the cow can be increased or decreased with sign

A +

B ↕

C ↔

D ↑

MCQ 43 ALL

The width of the column can be increased or decreased with

A +

B ↕

C ↔

D ↑

MCQ 44 ALL

Which of the following is the extension of a worksheet created in cale?

A ods

B odd

C xls

D obj

MCQ 45 ALL

_______are stored in the left side of the cell in Calc.

A number

B formuls

C letter

D all of the given

MCQ 46 ALL

Which mem is used in change the name of the sheet ?

A number

B formuls

C letter

D all of the given

MCQ 47 ALL

The formula in Cale should start with _____ sign.

A edit

B format

C View

D tools

MCQ 48 ALL

How can one calculate total of values entered in a worksheet in a Calc document ?

A ?

B >

C =

D <

MCQ 49 ALL

Which of the following icons are there on standard toolbar ?

A By manual

B By autosum

C By formula

D all of given

MCQ 50 ALL

Which of the following icons are there on standard toolbar ?

A creating new Cale document, opening an existing document

B Checking spelling within the document

C Cutting and pasting content, printing document

D all of given

MCQ 51 ALL

Which menu and options are used to turn off/on the toolbars ?

A view toolbars

B insert toolbars

C tools toolbar

D help toolsbars

MCQ 52 ALL

Which of the following is seen on the status bar ?

A A Present status

B Page style

C Selection mode & unsaved changes

D All of the given

MCQ 53 ALL

Which of the following menu is used to save and close Calic document and ope an extating Calc document ?

A file

B Window

C Data

D View

MCQ 54 ALL

Which of the following menu is used to save and close Cale document and open an existing Calc document ?

A file

B Window

C data

D View

MCQ 55 ALL

If we move a cell containing a formula having reference to another cell in the worksheet, what will happen to the cell numbers used in formula ?

A The cell row and column sarech anged at destination

B The cell row numbers are changed at destination.

C The cell column numbers are changed at destination.

D Nothing will be changed.

MCQ 56 ALL

When we use cell reference _________ .

A weneednothavetomanuallyperformarithmeticoperation.

B result of the formula will automatically be changed when there is a change in values of a cell.

C the reference in the formula will automatically be changed when data block is moved.

D all of the given

MCQ 57 ALL

In spreadsheets, a cell range is denoted by the address of the first cell and the address of the last cell, separated by a _______ .

A ;

B :

C >

D !

MCQ 58 ALL

The right corner of the active cell is highlighted with _________ when cell pointer is placed on it..

A Auto Fill handle

B cell handle

C AutoSum handle

D none of the given

MCQ 59 ALL

The zoom tool is used to_________ a worksheet.

A zoomin

B zoom out

C both A and b

D activate

MCQ 60 ALL

The empty grid of cells forms _________ .

A cellrange

B workspace

C function wizard

D chart wizard

MCQ 61 ALL

The current worksheet tab has _________ background by default.

A black

B grey

C white

D pink

MCQ 62 ALL

The tab other than the current worksheet tab has _________ background by default.

A black

B grey

C white

D pink

MCQ 63 ALL

_________ presents facilities for entering and editing formula within a cell.

A Formulatoolbar

B Formatting toolbar

C Standard toolbar

D All of the given

MCQ 64 ALL

Which of the following works as a navigation tool in a worksheet ?

A statusbar

B scroll bar

C sheet tab

D zoom tool

MCQ 65 ALL

_________ sign on the sheet tab takes you to the very first worksheet ?

A ►

B ◄

C ►I

D I◄

MCQ 66 ALL

Which of the following will be inserted in a worksheet if =starcalcteam( )is inserted in a Calc cell ?

A Stars

B Photograph of Calc developer

C Calc licence Information

D Cale version Information

MCQ 67 ALL

_________ is an electronic spreadsheet package from the OpenOffice suits.

A Calc

B Writer

C Excel

D Lotus 123

📖 Reading Mode: SSC(ENG) - GSEB Board

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

In Calc,a function or formula can start with which of the following sign ?

Which of the following is the extension of a worksheet created in Calc?

By default, Calc spreadsheet contains how many worksheets?

Which of the following will be inserted in a worksheet if =starcalcteam() is inserted in a Calc cell ?

Which of the following applications are not suitable for Calc?

How can one calculate total of values entered in a worksheet in a Calc document ?

How many maximum worksheet in spreadsheet document ?

How many menu is available in Calc ?

Which sign is available on bottom right side of the active cell ?

How many rows in Calc ?

How many columns in Calc ?

Which is the basic element of a spreadsheet ?

In which form scroll bar is seen in Calc ?

To add or remove toolbar which option is used ?

Which menu option is used to rename a worksheet ?

Which key is pressed to see the result after entering formula in Calc ?

Which of the following option is used to add the values between cell A1 to A5 in Calc ?

On which bar S symbol does appear ?

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

which of the following are basic components of spreadsheet.

Worksheet is a collection of

Which of the following represents an entity

Which of the following represents an records

What is an intersection of row and column.

For which of the following application, spreadsheet package is useful ?

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

which bar shows name of the program

The default name given to the Calc file is

Which menu contains the commands to operate the entire document such as creating a new document, saving file,printing, print preview, etc.

which menu contains editing commands such as cut, copy, paste, find and replace etc

Which of the following menu is used for adding or removing elements of the user interface, page break preview, etc.?

Which of the following can be done using Format menu?

When any option of submenu contains shape, that means there are more suboptions available with the option.

The Cale worksheet contains

The Cale worksheet contains columns

The cell whose border is thick and dark black is known as

By default. Cale spreadsheet contains worksheets.

In Calc. displays the name of an active cell.

There are maximum_______ worksheets per Cale spreadsheet document.

The headers which are numbered are called in ______Cale.

The height of the cow can be increased or decreased with sign

The width of the column can be increased or decreased with

Which of the following is the extension of a worksheet created in cale?

_______are stored in the left side of the cell in Calc.

Which mem is used in change the name of the sheet ?

The formula in Cale should start with _____ sign.

How can one calculate total of values entered in a worksheet in a Calc document ?

Which of the following icons are there on standard toolbar ?

Which of the following icons are there on standard toolbar ?

Which menu and options are used to turn off/on the toolbars ?

Which of the following is seen on the status bar ?

Which of the following menu is used to save and close Calic document and ope an extating Calc document ?

Which of the following menu is used to save and close Cale document and open an existing Calc document ?

If we move a cell containing a formula having reference to another cell in the worksheet, what will happen to the cell numbers used in formula ?

When we use cell reference _________ .

In spreadsheets, a cell range is denoted by the address of the first cell and the address of the last cell, separated by a _______ .

The right corner of the active cell is highlighted with _________ when cell pointer is placed on it..

The zoom tool is used to_________ a worksheet.

The empty grid of cells forms _________ .

The current worksheet tab has _________ background by default.

The tab other than the current worksheet tab has _________ background by default.

_________ presents facilities for entering and editing formula within a cell.

Which of the following works as a navigation tool in a worksheet ?

_________ sign on the sheet tab takes you to the very first worksheet ?

Which of the following will be inserted in a worksheet if =starcalcteam( )is inserted in a Calc cell ?

_________ is an electronic spreadsheet package from the OpenOffice suits.

⚠️ Report Question Issue