MCQ Question Bank - MCQ Sets

1 MCQ Question Microsoft excel 1/1/2014. Khanal Questions Multiple Choice Questions From Microsoft excel Collected & Composed By: MCQ Sets MCQ Bank for MS excel Visit for more materials 1. Which of the following methods can not be used to enter data in 10. To create a formula, you first: a cell a. Select the cell you want to place the formula into a. Pressing an arrow key b. Type the equals sign (=) to tell excel that you're about to enter a b. Pressing the Tab key formula c. Pressing the Esc key c. Enter the formula using any input values and the appropriate d. Clicking on the formula bar mathematical operators that make up your formula d. Choose the new command from the file menu 2. Which of the following will not cut information? a. Pressing Ctrl + C 11. To center worksheet titles across a range of cells, you must b. Selecting Edit>Cut from the menu a. Select the cells containing the title text plus the range over which c.

2 Clicking the Cut button on the standard the title text is to be centered d. Pressing Ctrl+X b. Widen the columns c. Select the cells containing the title text plus the range over which 3. Which of the following is not a way to complete a cell entry? the title text is to be enfettered a. Pressing enter d. Format the cells with the comma style b. Pressing any arrow key on the keyboard c. Clicking the Enter button on the Formula bar Q. Can I download the MCQ banks in d. Pressing spacebar a. Yes, do a search in site b. Yes, some files are offered to download free 4. You can activate a cell by c. has download sections a. Pressing the Tab key d. The downloads are available as PDF files b. Clicking the cell c. Pressing an arrow key 12. How do you delete a column? d. All of the above a. Select the column heading you want to delete and select the Delete Row button on the standard toolbar Q.

3 Will you answer my questions if I send them to you? b. Select the column heading you want to delete and select Insert a. There are some pages in MCQ Sets that offers you the form Delete from the menu b. If you send me questions using the forms in MCQ Sets c. Select the row heading you want to delete and select Edit>Delete c. I will try to include your questions in the respective series from the menu d. Get the most authentic answers for your subjective questions d. Right click the column heading you want to delet and select delete from the shortcut menu 5. Text formulas: a. Replace cell references 13. How can you find specific information in a list? b. Return ASCII values of characters a. Select Tools > Finder from the menu c. Concatenate and manipulate text b. Click the Find button on the standard toolbar d. Show formula error value c. Select Insert > Find from the menu d. Select Data > Form from the menu to open the Data Form dialog 6.

4 How do you insert a row? box and click the Criteria button a. Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu 14. When integrating word and excel , word is usually the b. Select the row heading where you want to insert the new row and a. Server select Edit >Row from the menu b. Destination c. Select the row heading where you want to insert the new row and c. Client click the Insert Row button on the standard toolbar d. Both b and c d. All of the above 15. When a label is too long to fit within a worksheet cell, you Q. Where can you find best quality multiple choice questions? typically must a. a. Shorten the label b. b. Increase the column width c. c. Decrease the column width d. d. Adjust the row height 7. Which of the following is not a basic step in creating a Q. Where can you find best quality multiple choice questions?

5 Worksheet? a. a. Save workbook b. b. Modifiy the worksheet c. c. Enter text and data d. d. Copy the worksheet 16. The name box 8. How do you select an entire column? a. Shows the location of the previously active cell a. Select Edit > Select > Column from the menu b. Appears to the left of the formula bar b. Click the column heading letter c. Appears below the status bar c. Hold down the shift key as you click anywhere in the column. d. Appears below the menu bar d. Hold down the Ctrl key as you click anywhere in the column 17. Comments put in cells are called Q. You can use for a. Smart tip a. Online quiz b. Cell tip b. MCQ Banks c. Web tip d. Subjective Questions & answers d. Soft tip 9. How can you print three copies of a workbook? 18. Which is used to perform what if analysis? a. Select File>Properties form the menu and type 3 in the Copies to a. Solver print text box. b. Goal seek b.

6 Select File >Print from the menu and type 3 in the Number of c. Scenario Manager copies text box. d. All of above c. Click the Print button on the standard toolbar to print the document then take it to Kinko's and have 2 more copies made These multiple choice questions are composed to comply with PSC syllabus d. Press Ctrl+P+3. Visit for more multiple choice questions and download MCQ Banks 4. MCQ Bank for MS excel Visit for more materials 19. You can use the horizontal and vertical scroll bars to Q. How reliable are MCQs in MCQ Sets? a. Split a worksheet into two panes a. I've paid utmost care in correctness b. View different rows and columns edit the contents of a cell b. These are tested questions and answers c. Edit the contents of a cell c. However, if you discover any mistakes d. view different worksheets d. Mail me at 20. Multiple calculations can be made in a single formula using 29.

7 To hold row and column titles in place so that they do not scroll a. standard formulas when you scroll a worksheet click the b. array formula a. Unfreeze panes command on the window menu c. complex formulas b. Freeze panes command on the window menu d. smart formula c. Hold titles command on the edit menu d. Split command on the window menu 21. Hyperlinks can be a. Text 30. To edit in an embedded excel worksheet object in a word b. Drawing objects document c. Pictures a. Use the excel menu bar and toolbars inside the word application d. All of above b. Edit the hyperlink c. Edit the data in a excel source application Q. Can I download the MCQ banks in d. Use the word menu bar and toolbars a. Yes, do a search in site b. Yes, some files are offered to download free Q. Will you answer my questions if I send them to you? c. has download sections a. There are some pages in MCQ Sets that offers you the form d.

8 The downloads are available as PDF files b. If you send me questions using the forms in MCQ Sets c. I will try to include your questions in the respective series 22. To activate the previous cell in a pre-selected range, press d. Get the most authentic answers for your subjective questions a. The Alt key b. The Tab key 31. To create a formula, you can use: c. The Enter key a. Values but not cell references d. None of the above b. C ell references but not values c. Values or cell references although not both at the same time 23. Which button do yu click to add up a series of numbers? d. Value and cell references a. The autosum button b. The Formula button Q. Where can you find best quality multiple choice questions? c. The quicktotal button a. d. The total button b. c. 24. When the formula bar is active, you can see d. a. The edit formula button b. The cancel button 32. Status indicators are located on the c.

9 The enter button a. Vertical scroll bar d. All of the above b. Horizontal scroll bar c. Formula bar Q. Will you answer my MCQ Questions in Facebook d. Standard toolbar a. I don't answer questions in Facebook b. You can post your questions in 33. Which of the following is the oldest spreadsheet package? c. Answering in Facebook kills my a lot of time a. VisiCalc d. If you save my time I'll be able to produce more useful materials b. Lotus 1-2-3. 25. To copy formatting from one area in a worksheet and apply it c. excel to another area you would use: d. StarCalc a. The Edit>Copy Format and Edit>Paste Format commands form the menu. 34. Rounding errors can occur b. The Copy and Apply Formatting dialog box, located under the a. When you use multiplication, division, or exponentiation in a Format>Copy and Apply menu. formula c. There is no way to copy and apply formatting in excel You have b.

10 When you use addition and subtraction in a formula to do it manually c. Because excel uses hidden decimal places in computation d. The Format Painter button on the standard toolbar d. When you show the results of formulas with different decimal places that the calculated results 26. In a worksheet you can select a. The entire worksheet 35. You can copy data or formulas b. Rows a. With the copy, paste and cut commands on the edit menu c. Columns b. With commands on ta shortcut menu d. All of the above c. With buttons on the standard toolbars d. All of the above 27. When you link data maintained in an excel workbook to a word document 36. You can not link excel worksheet data to a word document a. The word document can not be edit a. With the right drag method b. The word document contains a reference to the original source b. With a hyperlink application c. With the copy and paste special commands c.