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

Refer to CBSE Class 10 Computer Science Data Editing and Formatting in Calc MCQs provided below. CBSE Class 10 Computers MCQs with answers available in Pdf for free download. The MCQ Questions for Class 10 Computers with answers have been prepared as per the latest syllabus, CBSE books and examination pattern suggested in Class 10 by CBSE, NCERT and KVS. Multiple Choice Questions for Data Editing and Formatting in Calc are an important part of exams for Class 10 Computers and if practiced properly can help you to get higher marks. Refer to more Chapter-wise MCQs for CBSE Class 10 Computers and also download more latest study material for all subjects

MCQ for Class 10 Computers Data Editing and Formatting in Calc

Class 10 Computers students should refer to the following multiple-choice questions with answers for Data Editing and Formatting in Calc in Class 10. These MCQ questions with answers for Class 10 Computers will come in exams and help you to score good marks

Data Editing and Formatting in Calc MCQ Questions Class 10 Computers with Answers

(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

More Study Material

CBSE Class 10 Computers Data Editing and Formatting in Calc MCQs

We hope students liked the above MCQs for Data Editing and Formatting in Calc designed as per the latest syllabus for Class 10 Computers released by CBSE. Students of Class 10 should download the Multiple Choice Questions and Answers in Pdf format and practice the questions and solutions given in above Class 10 Computers MCQs Questions on daily basis. All latest MCQs with answers have been developed for Computers by referring to the most important and regularly asked topics which the students should learn and practice to get better score in school tests and examinations. Studiestoday is the best portal for Class 10 students to get all latest study material free of cost.

MCQs for Computers CBSE Class 10 Data Editing and Formatting in Calc

Expert teachers of studiestoday have referred to NCERT book for Class 10 Computers to develop the Computers Class 10 MCQs. If you download MCQs with answers for the above chapter daily, you will get higher and better marks in Class 10 test and exams in the current year as you will be able to have stronger understanding of all concepts. Daily Multiple Choice Questions practice of Computers and its study material will help students to have stronger understanding of all concepts and also make them expert on all critical topics. You can easily download and save all MCQs for Class 10 Computers also from www.studiestoday.com without paying anything in Pdf format. After solving the questions given in the MCQs which have been developed as per latest course books also refer to the NCERT solutions for Class 10 Computers designed by our teachers

Data Editing and Formatting in Calc MCQs Computers CBSE Class 10

All MCQs given above for Class 10 Computers have been made as per the latest syllabus and books issued for the current academic year. The students of Class 10 can refer to the answers which have been also provided by our teachers for all MCQs of Computers so that you are able to solve the questions and then compare your answers with the solutions provided by us. We have also provided lot of MCQ questions for Class 10 Computers so that you can solve questions relating to all topics given in each chapter. All study material for Class 10 Computers students have been given on studiestoday.

Data Editing and Formatting in Calc CBSE Class 10 MCQs Computers

Regular MCQs practice helps to gain more practice in solving questions to obtain a more comprehensive understanding of Data Editing and Formatting in Calc concepts. MCQs play an important role in developing understanding of Data Editing and Formatting in Calc in CBSE Class 10. Students can download and save or print all the MCQs, printable assignments, practice sheets of the above chapter in Class 10 Computers in Pdf format from studiestoday. You can print or read them online on your computer or mobile or any other device. After solving these you should also refer to Class 10 Computers MCQ Test for the same chapter

CBSE MCQs Computers Class 10 Data Editing and Formatting in Calc

CBSE Class 10 Computers best textbooks have been used for writing the problems given in the above MCQs. If you have tests coming up then you should revise all concepts relating to Data Editing and Formatting in Calc and then take out print of the above MCQs and attempt all problems. We have also provided a lot of other MCQs for Class 10 Computers which you can use to further make yourself better in Computers

Where can I download latest CBSE MCQs for Class 10 Computers Data Editing and Formatting in Calc

You can download the CBSE MCQs for Class 10 Computers Data Editing and Formatting in Calc for latest session from StudiesToday.com

Can I download the MCQs of Data Editing and Formatting in Calc Class 10 Computers in Pdf

Yes, you can click on the links above and download topic wise MCQs Questions PDFs for Data Editing and Formatting in Calc Class 10 for Computers

Are the Class 10 Computers Data Editing and Formatting in Calc MCQs available for the latest session

Yes, the MCQs issued by CBSE for Class 10 Computers Data Editing and Formatting in Calc have been made available here for latest academic session

How can I download the Data Editing and Formatting in Calc Class 10 Computers MCQs

You can easily access the links above and download the Data Editing and Formatting in Calc Class 10 MCQs Computers for each topic

Is there any charge for the MCQs with answers for Class 10 Computers Data Editing and Formatting in Calc

There is no charge for the MCQs and their answers for Class 10 CBSE Computers Data Editing and Formatting in Calc you can download everything free

How can I improve my MCQs in Class 10 Computers Data Editing and Formatting in Calc

Regular revision of MCQs given on studiestoday for Class 10 subject Computers Data Editing and Formatting in Calc can help you to score better marks in exams

What are MCQs for Class 10 Computers Data Editing and Formatting in Calc

Multiple Choice Questions (MCQs) for Data Editing and Formatting in Calc Class 10 Computers are objective-based questions which provide multiple answer options, and students are required to choose the correct answer from the given choices.