Microsoft Excel MCQ Solved Paper for NEET

1. Comments can be added to cells using
A. Edit > Comments
B. Insert > Comments
C. File > Comments
D. View > Comments
Answer : B

2. How many worksheets can a workbook have?
A. 3
B. 8
C. 255
D. none of above
Answer : D

3. The chart wizard term data series refers to
A. A chart legend
B. A collection of chart data markers
C. A set of values you plot in a chart
D. A data label
Answer : B

4. 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

5. How can you find specific information in a list?
A. Select Tools > Finder from the menu
B. Click the Find button on the standard toolbar
C. Select Insert > Find from the menu
D. Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
Answer : D

6. You can use the horizontal and vertical scroll bars to
A. Split a worksheet into two panes
B. View different rows and columns edit the contents of a cell
C. Edit the contents of a cell
D. view different worksheets
Answer : B

7. 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

8. 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

9. Edit >> Delete command
A. Deletes the content of a cell
B. Deletes Formats of cell
C. Deletes the comment of cell
D. Deletes selected cells
Answer : D

10. To center worksheet titles across a range of cells, you must
A. Select the cells containing the title text plus the range over which the title text is to be centered
B. Widen the columns
C. Select the cells containing the title text plus the range over which the title text is to be enfettered
D. Format the cells with the comma style
Answer : A

11. To copy cell contents using drag and drop press the
A. End key
B. Shift key
C. Ctrl key
D. Esc key
Answer : A

12. 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

13. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
A. ROUND ( )
B. FACT ( )
C. MOD ( )
D. DIV ( )
Answer : C

14. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
A. Press Ctrl +Home
B. Press Home
C. Press Shift + Home
D. Press Alt + Home
Answer : A

15. You can move a sheet from one workbook into new book by
A. From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
B. From Edit menu choose Move of Copy then choose (Move to end) and click OK
C. From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
D. None of above
Answer : C

16. Which command will you choose to convert a column of data into row?
A. Cut and Paste
B. Edit >> Paste Special >> Transpose
C. Both of above
D. None of above
Answer : B

17. 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

18. What symbol is used before a number to make it a label?
A. ( quote )
B. = ( equal )
C. _ ( underscore )
D. ( apostrophe )
Answer : D

19. You can activate a cell by
A. Pressing the Tab key
B. Clicking the cell
C. Pressing an arrow key
D. All of the above
Answer : D

20. Which is used to perform what if analysis?
A. Solver
B. Goal seek
C. Scenario Manager
D. All of above
Answer : D

21. Tab scrolling button
A. Allow you to view a different worksheet
B. Allow you to view additional worksheet rows down
C. Allow you to view additional worksheet columns to the right
D. Alow you to view additional sheets tabs
Answer : D

22. 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

23. 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

24. Excel files have a default extension of
A. Xls
B. Xlw
C. Wk1
D. 123
Answer : A

25. You can edit a cell by
A. Clicking the formula button
B. Double clicking the cell to edit it in-place
C. Selecting Edit>Edit Cell from the menu
D. None of above
Answer : B

26. 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

27. In Excel, a Data Series is defined as what?
A. A type of chart
B. A cell reference
C. A collection of related data
D. A division of results
Answer : C

28. The Name box on to the left of formula bar
A. shows the name of workbook currently working on
B. shows the name of worksheet currently working on
C. shows the name of cell or range currently working on
D. None of above
Answer : C

29. We can save and protect the workbook by
A. Write Reservation Password
B. Protection Password
C. Read-only Recommended
D. Any of the above
Answer : D

30. MS Excel provides the default value for step in Fill Series dialog box
A. 0
B. 1
C. 5
D. 10
Answer : B

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

32. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?
A. Custom List
B. Auto Fill Options
C. Fill Across Worksheet
D. Fill Series
Answer : A

33. 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

34. The Chart wizard term data categories refers to;
A. A chart plot area
B. A horizontal axis
C. The organization of individual values with a charts data series
D. The data range that supply chart data
Answer : B

35. While Finding and Replacing some data in Excel, which of the following statement is valid?
A. You can Find and Replace within the sheet or workbook
B. Excel does not have option to match case for find
C. Both are valid
D. None are valid
Answer : A

36. Which symbol must all formula begin with?
A. =
B. +
C. (
D. @
Answer : A

37. When a row of data is to be converted into columns
A. Copy the cells in row, select the same number of cells in row and paste
B. Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
C. Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
D. Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK
Answer : D

38. Which of the cell pointer indicate that you can move the content to other cell?
A. Doctors symbol (Big Plus)
B. small thin plus icon
C. Mouse Pointer with anchor at the tip
D. None of above
Answer : C

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

40. 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

41. What is represented by the small, black square in the lower-right corner of an active cell or range?
A. Copy handle
B. Fill handle
C. Insert handle
D. Border
Answer : B

42. 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

43. When you link data maintained in an excel workbook to a word document
A. The word document cannot be edit
B. The word document contains a reference to the original source application
C. The wrd document must contain a hyperlink
D. The word document contains a copy of the actual data
Answer : B

44. When integrating word and excel, word is usually the
A. Server
B. Destination
C. Client
D. Both b and c
Answer : D

45. The command Edit >> Fill Across Worksheet is active only when
A. One sheet is selected
B. When many sheets are selected
C. When no sheet is selected
D. None of above
Answer : B

46. Tab scroll buttons are place on Excel screen
A. towards the bottom right corner
B. towards the bottom left corner
C. towards the top right corner
D. towards the top left corner
Answer : B

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

48. Status indicators are located on the
A. Vertical scroll bar
B. Horizontal scroll bar
C. Formula bar
D. Standard toolbar
Answer : C

49. What do you mean by a Workspace?
A. Group of Columns
B. Group of Worksheets
C. Group of Rows
D. Group of Workbooks
Answer : D

50. In the formula, which symbol specifies the fixed columns or rows?
A. $
B. *
C. %
D. &
Answer : A