Computer MCQ . (1 Marks)

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

_____Is used to avoid errors in entering data.

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

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

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

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

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

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

The header and footer areas in Calc are divided in_____ areas

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

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

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

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,_____ option of Page tab allows you to set left. right. top and bottom margins.

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

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

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

_____menu helps in displaying and modifying page breaks.

Which menu is used to obtain find & Replace option ?

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

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

Which menu is used to obtain spelling and grammar option ?

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

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

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

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

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

Upto which level is data sorting possible ?

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

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

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

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

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

_____of the following is an absolute cell address.

Which of the following is/are relative cell address ?

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

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

Which of the following is the sign for Fill handle ?

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

_____key is used to edit the content of an active cell

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

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

_____option of Delete contents dialog box deletes formulas and outcomes 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 numbers from the selected cell/cell range.

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

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

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

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

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