1000+ Microsoft Excel MCQ for RRB Group D [Solved]

1. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
A. AutoFill
B. Auto correct
C. Auto sum
D. Auto format
Answer : C

2. A numeric value can be treated as label value if ...... precedes it.
A. Apostrophe ( )
B. Exclamation ( ! )
C. Hash ( # )
D. Tilde ( ~ )
Answer : A

3. It is acceptable to let long text flow into adjacent cells on a worksheet when
A. Data will be entered in the adjacent cells
B. No data will be entered in the adjacent cells
C. There is no suitable abbreviation of the text
D. There is not time to format the next
Answer : B

4. Comments put in cells are called
A. Smart tip
B. Cell tip
C. Web tip
D. Soft tip
Answer : B

5. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
A. Pie chart
B. Row chart
C. Line chart
D. Column chart
Answer : C

6. A worksheet range is a
A. A command used for data modeling
B. A range of values such as from 23 to 234
C. A group of cells
D. A group of worksheets
Answer : C

7. You can copy data or formulas
A. With the copy, paste and cut commands on the edit menu
B. With commands on the shortcut menu
C. With buttons on the standard toolbars
D. All of the above
Answer : D

8. What are the tabs that appear at the bottom of each workbook called?
A. Reference tabs
B. Position tabs
C. Location tabs
D. Sheet tabs
Answer : D

9. Which of the following is an absolute cell reference?
A. !A!1
B. $A$1
C. #a#1
D. A1
Answer : B

10. The Delete key of keyboard is assigned to which command in Excel?
A. Edit >> Clear >> Contents
B. Edit >> Clear >> All
C. Edit >> Delete
D. All of above
Answer : A

11. When a label is too long to fit within a worksheet cell, you typically must
A. Shorten the label
B. Increase the column width
C. Decrease the column width
D. Adjust the row height
Answer : B

12. Which of the following is the latest version of Excel
A. Excel 2000
B. Excel 2002
C. Excel ME
D. Excel XP
Answer : D

13. Which elements of a worksheet can be protected from accidental modification?
A. Contents
B. Objects
C. Scenarios
D. All of the above
Answer : D

14. Comments put in cells are called .....
A. Smart Tip
B. Cell Tip
C. Web Tip
D. Soft Tip
Answer : B

15. Multiple calculations can be made in a single formula using .......
A. Standard Formulas
B. Array Formula
C. Complex Formulas
D. Smart Formula
Answer : B

16. To save a workbook, you:
A. Click the save button on the standard toolbar from the menu
B. Press Ctrl+F5
C. Click Save on the Windows Start button
D. Select Edit>Save
Answer : A

17. Each excel file is called a workbook because
A. It can contain text and data
B. It can be modified
C. It can contain many sheets including worksheets and chart sheets
D. You have to work hard to create it
Answer : C

18. Which setting you must modify to print a worksheet using letterhead?
A. Paper
B. Margin
C. Layout
D. Orientation
Answer : B

19. Which is not the function of Edit, Clear command?
A. Delete contents
B. Delete notes
C. Delete cells
D. Delete formats
Answer : C

20. Which of the following is the oldest spreadsheet package?
A. VisiCalc
B. Lotus 1-2-3
C. Excel
D. StarCalc
Answer : C

21. Which function is not available in the Consolidate dialog box?
A. Pmt
B. Average
C. Max
D. Sum
Answer : A

22. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
A. None of these
B. Select Format > Money from the menu
C. Click the Currency Style button on the formatting toolbar
D. You have to retype everything and manually add the dollar signs, commas, and decimals
Answer : C

23. Which of the cell pointer indicates that you can fill series?
A. Doctors symbol (Big Plus)
B. small thin plus icon
C. Mouse Pointer with anchor at the tip
D. None of above
Answer : B

24. Comments can be added to cellsusing ......
A. Edit -> Comments
B. Insert -> Comment
C. File -> Comments
D. View > Comments
Answer : B

25. You can select a single range of cells by
A. Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
B. Pressing the Ctrl key while dragging over the desired cells
C. Pressing the Shift key and an arrow key
D. Dragging over the desired cells
Answer : D

26. A circular reference is
A. Geometric modeling tool
B. A cell that points to a drawing object
C. A formula that either directly or indirectly depends on itself
D. Always erroneous
Answer : C

27. Which Chart can be created in Excel?
A. Area
B. Line
C. Pie
D. All of the above
Answer : D

28. Concatenation of text can be done using
A. Apostrophe (&lsquo
B. Exclamation (!)
C. Hash (#)
D. Ampersand (&
Answer : D

29. Documentation should include
A. Destination and users of the output data
B. Source of input data
C. Information on the purpose of the workbook
D. All of the above
Answer : D

30. How do you wrap the text in a cell?
A. Format, cells, font
B. Format, cells, protection
C. Format, cells, number
D. Format, cells, alignment
Answer : D

31. Where can you change automatic or manual calculation mode in Excel?
A. Double CAL indicator on status bar
B. Go to Tools >> Options >> Calculation and mark the corresponding radio button
C. Both of above
D. None of above
Answer : B

32. To delete an embedded objects, first
A. Double click the object
B. Select the object by clicking it
C. Press the Shift + Delete keys
D. Select it and then press the delete key
Answer : D

33. Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
A. Square
B. Percentage
C. Goal Seek
D. Divide
Answer : D

34. Which would you choose to create a bar diagram?
A. Edit, Chart
B. Insert, Chart
C. Tools, Chart
D. Format, Chart
Answer : B

35. Microsoft Excel is a powerful ...........
A. Word processing package
B. Spreadsheet package
C. Communication S/W Package
D. DBMS package
Answer : B

36. To view a cell comment
A. click the edit comment command on the insert menu
B. click the display comment command on the window menu
C. position the mouse pointer over the cell
D. click the comment command on the view menu
Answer : C

37. Which of the following formulas will Excel Not be able to calculate?
A. =SUM(Sales)-A3
B. =SUM(A1:A5)*.5
C. =SUM(A1:A5)/(10-10)
D. =SUM(A1:A5)-10
Answer : A

38. You can set Page Border in Excel from
A. From Border tab in Format Cells dialog box
B. From Border tool in Formatting toolbar
C. From Line Style tool in Drawing toolbar
D. You can not set page border in Excel
Answer : D

39. You can use the drag and drop method to
A. Copy cell contents
B. Move cell contents
C. Add cell contents
D. a and b
Answer : D

40. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
A. F8
B. F9
C. F10
D. F11
Answer : B

41. The short cut key Ctrl + R is used in Excel to
A. Right align the content of cell
B. Remove the cell contents of selected cells
C. Fill the selection with active cells to the right
D. None of above
Answer : C

42. Getting data from a cell located in a different sheet is called ......
A. Accessing
B. Referencing
C. Updating
D. Functioning
Answer : B

43. You can auto fit the width of column by
A. double clicking on the column name on column header
B. Double click on the cell pointer in worksheet
C. Double clicking on column right border on column header
D. Double clicking on the column left border of column header
Answer : C

44. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
A. Use =if() function to format the required numbers red
B. Apply Conditional Formatting command on Format menu
C. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
D. All of above
Answer : B

45. Which of the following series type is not valid for Fill Series dialog box?
A. Linear
B. Growth
C. Autofill
D. Time
Answer : D

46. How can you delete a record?
A. Delete the column from the worksheet
B. Select Data > Form from the menu to open the Data Form dialog box, fnd the record and Click the Delete button
C. Select Data > Delete Record from the menu
D. Click the Delete button on the Standard toolbar
Answer : B

47. You can use the format painter multiple times before you turn it off by
A. You can use the format painter button on ly one time when you click it
B. Double clicking the format painter button
C. Pressing the Ctrl key and clicking the format painter button
D. Pressing the Alt key and clicking the format painter button
Answer : B

48. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
A. Unfreeze panes command on the window menu
B. Freeze panes command on the window menu
C. Hold titles command on the edit menu
D. Split command on the window menu
Answer : B

49. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
A. server
B. source
C. client
D. none
Answer : C

50. Which tool you will use to join some cells and place the content at the middle of joined cell?
A. From Format Cells dialog box click on Merge Cells check box
B. From Format Cells dialog box select the Centered alignment
C. From Format Cells dialog box choose Merge and Center check box
D. Click on Merge and Center tool on formatting toolbar
Answer : D