CS001 MCQs

CS001 Mcqs:

1: The comment can be attached using the new comment option in the _ _ _ _ tab. Data File Home Review 2: When cell addresses are changed in copying a formula it is called _ _ _ _ like = sum (A1, B1). Relative cell referencing Duplicate cell referencing Absolute cell referencing

3: How many worksheets an MS excel document contains by default? 10 worksheet 1 worksheet 2 worksheet 3 worksheet 4: Which of the following bar shows the content of cell of MS Excel sheet? Menu bar Formula bar Content bar Name bar 5: Relative reference is useful when we need to apply _ _ _ _ type of calculations. Simple Mathematical Complex Same 6: Which one is not a relational operator in the given options? 7: We can make the group of worksheets by pressing and holding the _ _ _ _ key and selecting the sheets we want to add in the group. Home Shift Alt Ctrl 8: Columns of MS Excel are represented by _ _ _ _. Alphabets Marks Names Numbers 9: You can enter different types of data in spreadsheet like _ _ _ _. All of given Symbols Letters Numeric data 10: When cell addresses are not changed in copying a formula it is called _ _ _ _ like = $ A $ 2 + $ B $ 2.

Mix cell reference Absolute cell reference Single cell reference 11: The function library in Microsoft Excel is available under _ _ _ _ tab. Home Data Formula Insert 12: Rows of MS Excel are represented by _ _ _ _. Numbers Marks Names Alphabets 13: _ _ _ _ displays the help task pane in MS Excel. F4 F2 F1 F3 14: In MS Excel data can be sorted as following Select the data, you need to sort: Go to file < sort

Select the data, you need to sort: Go to data < sort Select the data, you need to sort: Go to edit < sort 15: To remove the contents of several cells at once, you can _ _ _ _. Press Esc button Select the cells and drag the fill handle back up over them Select the cells and press Delete Select the cells and choose Edit | Clear … | Contents 16: If you press _ _ _ _, the cell accepts your typing as his contents. Tab Esc Enter Back-space 17: If more than one operator is involved in any formula so which one has the highest priority? * And /

• And +