CBSE Class 10 Computer Science Data Editing and Formatting in Calc MCQs

(1) ........is the basic unit data for storing data in spreadsheet.

(A) Worksheet (B) Cell (C) Row (D) Column

(2) What is horizontal line known as ?

(A) Column (B) Row (C) Cell (D) Worksheet

(3) What is vertical line known as ?

(A) Worksheet (B) Cell (C) Row (D) Column

(4) What is the intersection of row and column known as ?

(A) Row (B) Column (C) Worksheet (D) Cell

(5) ........type of information can be entered in a cell.

(A) Data (B) Formula (C) Function (D) All of these

(6) What is modifying the data known as ?

(A) Data formatting (B) Data deleting (C) Data editing (D) Data inserting

(7) To arrange the data in attractive and proper manner is known as

(A) data formatting  (B) data deleting (C) data editing (D) data inserting

(8) Spreadsheet is known as ........ the other name.

(A) mastersheet (B) basesheet (C) worksheet (D) workingsheet

(9) ........ operation is done many times for the worksheet.

(A) Opening a new or an existing spreadsheet (B) Saving the spreadsheet

(C) Adding/deleting worksheets (D) All of these

(10) ........ menu option is used to open a worksheet.

(A) File -» Spreadsheet (B) File -> New -» Spreadsheet

(C) File -> Open -> Spreadsheet (D) File -> Add -> Spreadsheet

(11) ........ is the shortcut key to open a new document.

(A) Ctrl + D (B) Ctrl + F (C) Ctrl + M (D) Ctrl + N

(12) By default how many worksheet are displayed ?

(A) 2 (B) 3 (C) 4 (D) 5 (13) ........is the combination of so many rows and columns.

(A) Grid (B) Grass (C) Grill (D) Grace

(14) ........is the option to open a document.

(A) File -> Open (B) File -> Start (C) File -> Display (D) File -> New

(15) ........is the short cut key to open a document.

(A) Ctrl + N (B) Ctrl + D (C) Ctrl + O (D) Ctrl + X

(16) ........ feature is given by ubuntu to search a file.

(A) Search utility (B) Find (C) Replace (D) Navigation

(17) ........ button is pressed after giving information in Search for Files dialog box.

(A) Search (B) Look (C) Find (D) Invent

(18) What is displayed as a result of Search for Files ?

(A) List of files (B) List of folders (C) List of directories (D) List of networks

(19) ........option is useful to save the worksheet.

(A) File -> Save (B) File -> Store (C) File -> Copy (D) File -» Worksheet

(20) To save the file with some other name ........ is useful.

(A) File -» Save (B) File -» Save As (C) File -> Store (D) File -> Store As

(21) ........is to be entered if the file to be saved for the first time.

(A) File name (B) Path to save file (C) Both (A) and (B) (D) None of these

(22) ........is used to close the opened spreadsheet.

(A) File -» Close (B) File -> End (C) File -» Shut (D) File -» Lock

(23) ........is the extension of the file in calc.

(A) .ode (B) .ods (C) .odb (D) .odg

(24) ........is the extension for template format in calc.

(A) .dbf (B) .ots (C) .ods (D) .csv

(25) ........ is the extension for files which are typically used for data exchange among various programs.

(A) .html (B) .pdf  (C) .csv   (D) .xlsx

(26)........ is the extension of HTML file.

(A) .html (B) .pdf (C) .xlsx (D) .xls

(27).......is the extension for the portable document.

(A) .html (B) .pdf (C) .xlsx (D) .xls

(28)........ is the format most frequently used.

(A) PDF (B) PPT (C)XLS (D) DOC

(29)........ option is the worldwide adobe file format.

(A) .html (B) .pdf (C).xlsx (D) .xls

(30)........ is useful to insert a new worksheet.

(A) File -> Sheet (B) Format -> Sheet (C)Edit -> Sheet (D) Insert -> Sheet

(31) How many worksheets can be added at time in Insert Sheet dialog box ?

(A) 1 (B) 2 (C) 3 (D) Many

(32) To insert a new worksheet........is selected by right clicking on the sheet tab.

(A) New Sheet (B) Add Sheet (C) Insert Sheet (D) Put Sheet

(33) ........ is the option to insert a new row in worksheet.

(A) File -» Rows (B) Edit -» Rows (C) Format -» Rows (D) Insert -> Rows

(34) ........ is the default width of column in centimeters.

(A) 2.23 cm (B) 2.25 cm (C) 2.27 cm (D) 2.29 cm

(35) ........is the default height of row in centimeters.

(A) 0.41cm (B) 0.43 cm (C) 0.45 cm (D) 0.47 cm

(36) ........ is useful to change width of column.

(A) Edit -> Column -f Width (B) Format -» Column -» Width

(C) Tools -» Column -» Width (D) Insert -> Column -> Width

(37) ........is useful to change height of row.

(A) Format -» Row -» Height (B) File -> Row -» Height

(C) Insert -» Row -» Height (D) Edit -> Row -» Height

(38) ........ is clicked to select the column.

(A) Column header (B) Column footer (C) Column cell (D) Column sheet

(39) ........is the option to keep row/column header visible.

(A) Window -> Freeze up (B) Window -» Freeze stop

(C) Window —» Freeze view (D) Window -> Freeze

(40) ........ type of data can be entered in a cell.

(A) Text (B) Formula (C) Relative cells (D) All of these

(41) ........ key is used to select random cells.

(A) Shift (B) Alt (C) Ctrl (D) Tab

(42) ........ is used to select the whole worksheet.

(A) Click on last button of row header (B) Click on last button of column header

(C) Click on last button of row header and column header

(D) Click on beginning button of row header and column header

(43) ........ type of data can be entered in a cell.

(A) Text (B) Formula (C) Relative cells (D) Any of these

(44) ........is used to fill the data automatically in cells.

(A) Autofill (B) Automatic (C) Autofit (D) Autotype

(45) The series created by autofill is known as.........

(A) serial series (B) predefined series (C) sequential series (D) autofill series

(46) ........shows the sequential series.

(A) 1, 2, 3, 4, 5... (B) 10, 20, 30, 40, 50, ... (C) 25, 50, 75, 100, 125, .... (D) All of these

(47) If we copy the cells made of formulas , the addresses .........

(A) are changed by calc itself. (B) are not changed by calc.

(C) are suggested to be changed. (D) are replaced by other cells.

(48) If the address of the cell change by copying the formula is known as ........ .

(A) absolute address (B) relative address

(C) both (A) and (B) (D) none of these

(49) If the address of the cell does not change by copying the formula is known as .........

(A) absolute address (B) relative address (C) both (A) and (B) (D) none of these

(50) ........sign is used to create absolute cell address.

(A) # (B) % (C) $ (D) &

(51) ........suggests the exact location of the cell.

(A) Absolute address (B) Relative address (C) both (A) and (B) (D) None of these

(52) ........ category is form numbers in Format Cells dialog box.

(A) Number, Percent (B) Date, Time (C) Currency, Scientific (D) All of these

(53) ........ category is available in numbers tab of Format Cells dialog box.

(A) English (USA) (B) English (India) (C) English (UK) (D) English (US)

(54) What is the arrangement of data known as ?

(A) Data filtering (B) Data sorting (C) Data inserting (D) Data validation

(55) ........ arranges the data in ascending or! descending order.

(A) Data filtering (B) Data sorting (C) Data inserting (D) Data validation

(56) Data can be sorted in ........order.

(A) ascending (B) descending (C) both (A) and (B) (D) none of these

(57) ........is useful to sort the data.

(A) Format -» Sort (B) Edit -» Sort (C) Tools -» Sort (D) Data -» Sort

(58) Sorting can be done on.........

(A) only text (B) numeric data (C) date information (D) all of these

(59) What is extracting the data known as ?

(A) Data validation (B) Data sorting (C) Data inserting (D) Data filtering

(60) ........ is useful to display the content as per user's wish.

(A) Data validation (B) Data sorting (C) Data inserting (D) Data filtering

(61) ........ is useful for filtering data.

(A) File -> Filter -> Auto Filter (B) Tools -> Filter -> Auto Filter

(C) Data -> Filter -> Auto Filter (D) Format -> Filter -> Auto Filter

(62) ........is useful to close the filter.

(A) File -> Filter -» Auto Filter (B) Tools -> Filter -> Auto Filter

(C) Date -> Filter -» Auto Filter (D) Format -» Filter -» Auto Filter

(63) ........ type of condition is displayed in Standard Filter dialog box.

(A) =, <, >, <=, >=, <> (B) Largest, Smallest (C) Constains, Begins With, Ends with (D) All of these

(64) To avoid errors in entering data, we may use ............

(A) data validations  (B) data sorting (C) data inserting (D) data filtering

(65) ........ tab is useful for controlling the invalid data.

(A) Criteria (B) Input Help (C) Error Alert (D) Any of these

(66) ........ tab is used to give the help to the user for entering valid data.

(A) Criteria (B) Input Help (C) Error Alert (D) Any of these

(67) ........tab is used to give some alert message if wrong data is entered.

(A) Criteria (B) Input Help (C) Error Alert (D) Any of these

(68) ........ displays the tool button for Auto Spellcheck.

(A) Formatting toolbar (B) Drawing toolbar (C) Standard toolbar (D) Master toolbar

(69) ........ line is displayed under the wrongly entered words.

(A) Green (B) Red (C) Blue (D) Yellow

(70) Which type of button is Auto Spellcheck ?

(A) Toggle button (B) Twin button (C) Dongle button (D) Double button

(71) The button which can be turned on or off is known as ........ type of button.

(A) On/Off button (B) Twin button (C) Dual button (D) Toggle button

(72) By........on the wrong spelling, list of options is displayed.

(A) Clicking (B) Double Clicking (C) Right Clicking (D) Drag and Drop

(73) ........ is used for spell check in Calc.

(A) Encyclopedia (B) Dictionary (C) Internet (D) All of these

(74) ........ function key is for spell check.

(A) F5 (B) F6 (C) F7 (D) F8

(75) ........button is used to add a new word in the dictionary of Calc.

(A) Attach (B) Add (C) Put (D) Append

(76) Which option is used to search the data and replace ?

(A) Find & Change (B) Search & Replace (C) Find & Replace (D) Search & Change

(77) Which is the short cut key for Find & Replace ?

(A) Ctrl + F (B) Ctrl + R (C) Ctrl + D (D) Ctrl + E

(78) Which option is useful to find the data and replace ?

(A) File -> Find & Replace (B) Format —> Find & Replace

(C) Edit -> Find & Replace (D) View —> Find & Replace

(79) Which is the option to search the data in Find & Replace dialog box ?

(A) Search for (B) Find (C) Find All (D) All of these

(80) Before printing the document........option is advisable.

(A) Print (B) Print Preview (C) Page Setup (D) Page Preview

(81) Print Preview provides view of spreadsheet with........ option.

(A) page break (B) margin (C) both (A) and (B) (D) none of these

(82) Which option is useful for print preview ?

(A) View -» Page Preview (B) Format -> Page Preview

(C) File -» Page Preview (D) Edit —> Page Preview

(83) Which are the orientation Page tab in Page Style dialog box ?

(A) Portrait (B) Landscape (C) both (A) and (B) (D) None of these

(84) Which type of margin can be set Page tab in Page style dialog box ?

(A) Top, Bottom (B) Left Side, Right Side

(C) both (A) and (B) (D) None of these

(85) What is the border of the cell known as ?

(A) Cell grid (B) Cell grill (C) Cell grade (D) Cell grace

(86) Which option is used to print document ?

(A) Format -> Print (B) File -» Print (C) Edit -» Print (D) Data -» Print

(87) Which tool button is used to print the document ?

(A) Print (B) Print Preview (C) Page Setup (D) Print Setup

(88) What is the shortcut key to print the document ?

(A) Ctrl + R (B) Ctrl + T (C) Ctrl + P (D) Ctrl + L

(89) ........ can be done using Page Break Preview option.

(A) See the page end mark (B) Change the page end mark

(C) both (A) and (B) (D) None of these

(90) ........is useful to see the general view of page

(A) File -> Normal (B) Edit -* Normal (C) View -> Normal (D) Format -> Normal

(91) The upper part of the page is known as........

(A) header (B) heading (C) topping (D) upper part

(92) The lower part of the page is known as........

(A) bottom (B) footer (C) base (D) down part

(93) Header and footer part is divided into how many parts ?

(A) 3 (B) 4 (C) 5 (D) 6

(94) Which part holds the header and footer part ?

(A) Left area (B) Center area (C) Right area (D) All of these

(95) ........ is displayed by default in Center area of header part.

(A) Sheet area (B) Sheet name (C) Sheet data (D) Sheet row or column

(96) Which option is useful to get help ?

(A) File -> OpenOffice.org Help (B) View —> OpenOffice.org Help

(C) Data —> OpenOffice.org Help (D) Help -> OpenOffice.org Help

(97) ........ is the function key to get help.

(A) Fl (B) F2 (C) F3 (D) F4