Reading Mode - SSC(ENG)

MCQ 1 ALL

Which key is used to select the cells that are physically adjacent to each other ?

A Ctrl

B Alt

C shift

D Tab

MCQ 2 ALL

Which menu is used to arrange the data in ascending or descending order ?

A Tools

B Format

C Data

D Sort

MCQ 3 ALL

Which function key is used to get help in Calc ?

A F1

B F2

C F3

D F4

MCQ 4 ALL

Which of the following is the sign for Fill handle tool?

A +

B *

C #

D |

MCQ 5 ALL

Which function key is used to edit the content of an active cell?

A F1

B F2

C F3

D F4

MCQ 6 ALL

Which of the following technique arranges the data set in a particular order such as ascending or descending ?

A Data Formatting

B Data Validations

C Data Filtering

D Data Sorting

MCQ 7 ALL

Which of the following techniques can be used to allow only date values in a cell ?

A Data Formatting

B Data Validations

C Data Filtering

D Data Sorting

MCQ 8 ALL

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

A Find and Replace

B By Replace command

C By Copy command

D By Preview command

MCQ 9 ALL

Page Preview will also allow you to do which of the following setting ?

A Borders

B Margins

C Column and Row heading

D All of these

MCQ 10 ALL

Which of the following function key is used to check spelling in Calc ?

A F1

B F2

C F4

D F7

MCQ 11 ALL

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

A Sorting

B Searching

C Filtering

D Validating

MCQ 12 ALL

What is the name of mechanism to allow only valid data ?

A Sorting

B Searching

C Filtering

D Validating

MCQ 13 ALL

Which of the following is the shortcut key to open a new Calc worksheet ?

A Ctrl + N

B Ctrl + O

C Ctrl + D

D Ctrl + E

MCQ 14 ALL

Which type of information can be entered in a cell ?

A Data

B Formula

C Function

D All of these

MCQ 15 ALL

Which option is useful to insert a new worksheet ?

A File -> Sheet

B Insert -> Sheet

C Format -> Sheet

D Edit -> Sheet

MCQ 16 ALL

Which line is displayed under the wrongly entered words ?

A Green

B Blue

C Red

D Black

MCQ 17 ALL

Which is the short cut key for Find and Replace ?

A Ctrl + F

B Ctrl + E

C Ctrl + D

D Ctrl + R

MCQ 18 ALL

Which bar can be used to preview the document ?

A Print bar

B View bar

C Preview bar

D Page bar

MCQ 19 ALL

How many types of orientations are there in Page tab in Page Style dialog box ?

A 2

B 3

C 4

D 5

MCQ 20 ALL

Header and Footer part is divided into how many parts ?

A 3

B 4

C 5

D 6

MCQ 21 ALL

What is the background color for the selected sheet in the Sheet Tab ?

A White

B Black

C Red

D Green

MCQ 22 ALL

Which menu option is used to remove a worksheet ?

A File -> Sheet -> Delete

B File -> Delete -> Sheet

C Edit -> Sheet -> Delete

D Edit -> Delete -> Sheet

MCQ 23 ALL

A new Calc spreadsheet can be created

A with File New Spreadsheet

B by pressing CTRL + N keys together

C by clicking on New Document Icon of Standard toolbar

D All of the given

MCQ 24 ALL

An existing Calc spreadsheet can be opened _____

A with File Open menu and command

B by pressing CTRL+O keys together

C by clicking on Open Document Icon of the Standard toolbar

D All of the given

MCQ 25 ALL

Which of the following option is used to open an existing spreadsheet ?

A File→ Open

B Places → Documents

C Places → Search For Files

D All of the given

MCQ 26 ALL

_____menu and options are used to save Calc spreadsheet with some different name or different type.

A File→ Save

B File → Save As

C Edit→ Copy

D None of the given

MCQ 27 ALL

In which of the following format can Calc spreadsheet be stored/saved ?

A ODF spreadsheet, ODF spreadsheet template

B DBASE, Text CSV, Portable Document Format

C HTML document. Microsoft Excel 2007 XML. Microsoft Excel 2003

D All of the given

MCQ 28 ALL

Which file format has a text file containing comma separated values ?

A HTML

B XML

C CSV

D DBASE

MCQ 29 ALL

Which menu is used to rename the worksheet ?

A Edit

B File

C Format

D Insert

MCQ 30 ALL

Which menu is used to change the colour of worksheet tab ?

A Edit

B Insert

C Tools

D Format

MCQ 31 ALL

Which of the following can be inserted in a worksheet?

A Sheet

B Row

C Column

D All of the given

MCQ 32 ALL

Which menu is used to delete a column or row from a worksheet ?

A Edit

B Insert

C View

D File

MCQ 33 ALL

Which menu is used to change column width or row height ?

A Edit

B Format

C Insert

D View

MCQ 34 ALL

Which menu and commands are used to freeze a selected area of worksheet ?

A Window→ Freeze

B Edit → Select All → Freeze

C Insert→ Row → Freeze

D None of the given

MCQ 35 ALL

_____key is used to select the cells that are not physically adjacent to each other.

A Tab

B Shift

C CTRL

D Alt

MCQ 36 ALL

_____option of Delete contents dialog box deletes text contents from the selected cell/cell range.

A Date & Time

B Text

C Numbers

D Notes

MCQ 37 ALL

_____option of Delete contents dialog box deletes numbers from the selected cell/cell range.

A Date & Time

B Text

C Numbers

D Notes

MCQ 38 ALL

_____option of Delete contents dialog box deletes notes if added. from a selected cell/cell range.

A Date & Time

B Text

C Numbers

D Notes

MCQ 39 ALL

_____option of Delete contents dialog box deletes formulas and outcomes from the selected cell/cell range

A Formats

B Formula

C Objects

D Notes

MCQ 40 ALL

Which of the following options when selected deletes all data validations ?

A Format

B Delete All

C Both A and B

D Delete Formula

MCQ 41 ALL

_____ option of Delete contents dialog box deletes cell formatting but keeps data.

A Format

B Formulas

C Objects

D Notes

MCQ 42 ALL

_____option of Delete contents dialog box deletes additional elements of a cell such as images from selected cell/cell range.

A Format

B Objects

C Formulas

D Notes

MCQ 43 ALL

_____key is used to edit the content of an active cell

A ESC

B CTRL

C F2

D TAB 22.

MCQ 44 ALL

Which of the following is used to get series such as 10, 20, 30...?

A AutoSum

B AutoFill

C AutoFormat

D None of the given

MCQ 45 ALL

Which of the following is the sign for Fill handle ?

A ↕

B ↔

C +

D =

MCQ 46 ALL

When a formula is copied to another cell. Calc automatically changes the address of cells included in a formula as _____ cell address is used in it

A relative.

B absolute

C irrelative

D both B and C

MCQ 47 ALL

The _____ cell address does not change when the formula is copied or moved.

A relative

B absolute

C Irrelative

D none of the given

MCQ 48 ALL

Which of the following is/are relative cell address ?

A "=B2*C2"

B 2 2

C I + 1

D Both B and C

MCQ 49 ALL

_____of the following is an absolute cell address.

A "= AI +BI"

B A2 B2

C 1 + 1

D Both A and B

MCQ 50 ALL

In which of the following cell address, column is having absolute cell address ?

A A = A1 + B1

B "= A$1+B1"

C "= A1+ B$1"

D #REF!

MCQ 51 ALL

_____tab of Format → Cells dialog box shows typical number formatting options for cells containing numbers

A Alignment

B Number

C Font

D Borders

MCQ 52 ALL

Various font effects of the selected cell/cell range/worksheet can be changed using the various options of_____ tab of Format → Cells dialog box.

A Alignment

B Number

C Font

D Borders

MCQ 53 ALL

Which menu is used to arrange the data in ascending or descending order

A File

B View

C Data

D Window

MCQ 54 ALL

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

A Sorting

B Searching

C Filtering

D Validating

MCQ 55 ALL

Which of the following technique arranges the data set in a particular order such as ascending or descending ?

A Data formatting

B Data validations

C Data filtering

D Data sorting

MCQ 56 ALL

Upto which level is data sorting possible ?

A 1

B 2

C 3

D 5

MCQ 57 ALL

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

A Sorting

B Searching

C Filtering

D Validating

MCQ 58 ALL

_____is used when only a part of required information need to be display from large amount of data.

A Data sorting

B Data validation

C Data searching

D Data filtering

MCQ 59 ALL

_____ is a sort of condition used on the list of data which filters out the records as per the condition.

A Filter

B Search

C Validation

D Sorting

MCQ 60 ALL

Which of the following techniques can be used to allow only date values in a cell ?

A Data formatting

B Data validations

C Data filtering

D Data sorting

MCQ 61 ALL

What is the name of mechanism to allow only valid data ?

A Sorting

B Searching

C Filtering

D Validating

MCQ 62 ALL

_____Is used to avoid errors in entering data.

A Data sorting

B Data validation

C Data searching

D Data filtering

MCQ 63 ALL

Which of the following function key is used to check spelling in Calc ?

A FI

B F2

C F4

D F7

MCQ 64 ALL

In calc, the words spelled incorrectly will be underlined with _____line.

A red

B green

C purple

D black

MCQ 65 ALL

Which of the following is/are underlined with red line in Calc ?

A Words that are spelled incorrect

B Local words (such as your name, city name, name of the place)

C Incorrect formulas

D Both A and B

MCQ 66 ALL

Which menu is used to obtain spelling and grammar option ?

A Tools

B Format

C View

D Insert

MCQ 67 ALL

We can replace multiple occurences of a word using which of the following facility of Calc ?

A Find & Replace

B By replace only

C By copy command

D By preview command

MCQ 68 ALL

Find & Replace command of worksheet and replace text or numbers in cells fully or partially. menu are used to quickly find data in a

A Tools

B Format

C Edit

D View

MCQ 69 ALL

Which menu is used to obtain find & Replace option ?

A File

B Edit

C Format

D Data

MCQ 70 ALL

_____menu helps in displaying and modifying page breaks.

A File

B Edit

C Insert

D View

MCQ 71 ALL

_____menu and commands shows all possible actions that user can take to preview the document.

A File →Print

B File →Page Preview

C File → Preview

D All of the given

MCQ 72 ALL

Page preview will also allow you to do which of the following setting ?

A Borders

B Margins

C Column and row heading

D All of the given

MCQ 73 ALL

[6] netx Various options provided by _____ tab of Page Style dialog box allows you to set paper format, margines, orientation, etc.

A Page paper sizes.

B Sheet

C Borders

D Header

MCQ 74 ALL

In Page Style dialog box._____ option of Page tab shows various paper size.

A Format

B Margin

C Paper tray

D Page layout

MCQ 75 ALL

In Page Style dialog box,_____ option of Page tab allows you to set left. right. top and bottom margins.

A Format

B Margin

C Paper tray

D Page layout

MCQ 76 ALL

In Page Style dialog box,_____ option of Page tab specifies from where the paper comes to the printer (from upper/lower tray).

A Format

B Margin

C Paper tray

D Page layout

MCQ 77 ALL

In Page Style dialog box_____ tab is used to print column and row headers with grid.

A Organizer

B Sheet

C Borders

D Background

MCQ 78 ALL

In Page Style dialog box._____ tab is used to select border type, border colour and border thickness along with other options to set borders.

A Borders

B Sheet

C Page

D Header

MCQ 79 ALL

______ option of Page Style dialog box is used to create page header

A Borders

B Page

C Sheet

D Header

MCQ 80 ALL

The header and footer areas in Calc are divided in_____ areas

A 3

B 4

C 5

D 2

MCQ 81 ALL

Which of the following function key is used to get help in Calc ?

A F1

B F2

C F4

D F7

📖 Reading Mode: SSC(ENG) - GSEB Board

Which key is used to select the cells that are physically adjacent to each other ?

Which menu is used to arrange the data in ascending or descending order ?

Which function key is used to get help in Calc ?

Which of the following is the sign for Fill handle tool?

Which function key is used to edit the content of an active cell?

Which of the following technique arranges the data set in a particular order such as ascending or descending ?

Which of the following techniques can be used to allow only date values in a cell ?

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

Page Preview will also allow you to do which of the following setting ?

Which of the following function key is used to check spelling in Calc ?

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

What is the name of mechanism to allow only valid data ?

Which of the following is the shortcut key to open a new Calc worksheet ?

Which type of information can be entered in a cell ?

Which option is useful to insert a new worksheet ?

Which line is displayed under the wrongly entered words ?

Which is the short cut key for Find and Replace ?

Which bar can be used to preview the document ?

How many types of orientations are there in Page tab in Page Style dialog box ?

Header and Footer part is divided into how many parts ?

What is the background color for the selected sheet in the Sheet Tab ?

Which menu option is used to remove a worksheet ?

A new Calc spreadsheet can be created

An existing Calc spreadsheet can be opened _____

Which of the following option is used to open an existing spreadsheet ?

_____menu and options are used to save Calc spreadsheet with some different name or different type.

In which of the following format can Calc spreadsheet be stored/saved ?

Which file format has a text file containing comma separated values ?

Which menu is used to rename the worksheet ?

Which menu is used to change the colour of worksheet tab ?

Which of the following can be inserted in a worksheet?

Which menu is used to delete a column or row from a worksheet ?

Which menu is used to change column width or row height ?

Which menu and commands are used to freeze a selected area of worksheet ?

_____key is used to select the cells that are not physically adjacent to each other.

_____option of Delete contents dialog box deletes text contents from the selected cell/cell range.

_____option of Delete contents dialog box deletes numbers from the selected cell/cell range.

_____option of Delete contents dialog box deletes notes if added. from a selected cell/cell range.

_____option of Delete contents dialog box deletes formulas and outcomes from the selected cell/cell range

Which of the following options when selected deletes all data validations ?

_____ option of Delete contents dialog box deletes cell formatting but keeps data.

_____option of Delete contents dialog box deletes additional elements of a cell such as images from selected cell/cell range.

_____key is used to edit the content of an active cell

Which of the following is used to get series such as 10, 20, 30...?

Which of the following is the sign for Fill handle ?

When a formula is copied to another cell. Calc automatically changes the address of cells included in a formula as _____ cell address is used in it

The _____ cell address does not change when the formula is copied or moved.

Which of the following is/are relative cell address ?

_____of the following is an absolute cell address.

In which of the following cell address, column is having absolute cell address ?

_____tab of Format → Cells dialog box shows typical number formatting options for cells containing numbers

Various font effects of the selected cell/cell range/worksheet can be changed using the various options of_____ tab of Format → Cells dialog box.

Which menu is used to arrange the data in ascending or descending order

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

Which of the following technique arranges the data set in a particular order such as ascending or descending ?

Upto which level is data sorting possible ?

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

_____is used when only a part of required information need to be display from large amount of data.

_____ is a sort of condition used on the list of data which filters out the records as per the condition.

Which of the following techniques can be used to allow only date values in a cell ?

What is the name of mechanism to allow only valid data ?

_____Is used to avoid errors in entering data.

Which of the following function key is used to check spelling in Calc ?

In calc, the words spelled incorrectly will be underlined with _____line.

Which of the following is/are underlined with red line in Calc ?

Which menu is used to obtain spelling and grammar option ?

We can replace multiple occurences of a word using which of the following facility of Calc ?

Find & Replace command of worksheet and replace text or numbers in cells fully or partially. menu are used to quickly find data in a

Which menu is used to obtain find & Replace option ?

_____menu helps in displaying and modifying page breaks.

_____menu and commands shows all possible actions that user can take to preview the document.

Page preview will also allow you to do which of the following setting ?

[6] netx Various options provided by _____ tab of Page Style dialog box allows you to set paper format, margines, orientation, etc.

In Page Style dialog box._____ option of Page tab shows various paper size.

In Page Style dialog box,_____ option of Page tab allows you to set left. right. top and bottom margins.

In Page Style dialog box,_____ option of Page tab specifies from where the paper comes to the printer (from upper/lower tray).

In Page Style dialog box_____ tab is used to print column and row headers with grid.

In Page Style dialog box._____ tab is used to select border type, border colour and border thickness along with other options to set borders.

______ option of Page Style dialog box is used to create page header