Microsoft Excel 1000+ MCQ with answer for NEET PG

1. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
A. Logical
B. Math & Trigonometry
C. Statistical
D. Financial
Answer : D

2. An excel workbook is a collection of
A. Workbooks
B. Worksheets
C. Charts
D. Worksheets and charts
Answer : D

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

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

5. B7:B9 indicates:
A. Cells B7 and cell B9 only
B. Cells B7 through B9
C. Cell B8 only
D. None of the above
Answer : B

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

7. If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
A. From Edit menu choose Clear and then Formats
B. From Edit menu choose Delete
C. Click on Remove Formatting tool on Standard Toolbar
D. Double click the Format Painter and then press Esc key in keyboard
Answer : A

8. Which of the following is a popular DOS based spreadsheet package?
A. Word
B. Smart cell
C. Excel
D. Lotus 1-2-3
Answer : D

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

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

11. 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, find 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

12. To edit in an embedded excel worksheet object in a word document
A. Use the excel menu bar and toolbars inside the word application
B. Edit the hyperlink
C. Edit the data in a excel source application
D. Use the word menu bar and toolbars
Answer : A

13. If you begin typing an entry into a cell and then realize that you dont want your entry placed into a cell, you:
A. Press the Erase key
B. Press Esc
C. Press the Enter button
D. Press the Edit Formula button
Answer : B

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

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

16. To create a formula, you first:
A. Select the cell you want to place the formula into
B. Type the equals sign (=) to tell Excel that youre about to enter a formula
C. Enter the formula using any input values and the appropriate mathematical operators that make up your formula
D. Choose the new command from the file menu
Answer : B

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

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

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

20. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
A. Right click on Sheet Tab of third sheet and choose Delete from the context menu
B. Click on Sheet 3 and from Edit menu choose Delete
C. Both of above
D. None of above
Answer : A

21. You want to track the progess 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

22. You can enter which types of data into worksheet cells?
A. Labels, values, and formulas
B. Labels and values but not formulas
C. Values and formulas but not labels
D. Formulas only
Answer : A

23. Which menu option can be sued to split windows into two
A. Format > window
B. View > window > split
C. Window > split
D. View > split
Answer : C

24. Excel displays the current cell address in the ........
A. Formula bar
B. Status Bar
C. Name Box
D. Title Bar
Answer : C

25. A typical worksheet has …. Number of columns
A. 128
B. 256
C. 512
D. 1024
Answer : B

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

27. Which menu option can be used to split windows into two?
A. Format -> Window
B. View -> Window-> Split
C. Window -> Split
D. View > Split
Answer : C

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

29. When you insert an excel file into a word document. The data are
A. Hyperlinked placed in a word table
B. Linked
C. Embedded
D. Use the word menu bar and toolbars
Answer : B

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

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

32. Multiple calculations can be made in a single formula using
A. standard formulas
B. array formula
C. complex formulas
D. smart formula
Answer : B

33. The Cancel and Enter buttons appear in the:
A. Title bar
B. Formula bar
C. Menu bar
D. Sheet tabs
Answer : B

34. How do you display current date and time in MS Excel?
A. date ()
B. Today ()
C. now ()
D. time ()
Answer : C

35. You can convert existing excel worksheet data an charts to an HTML document by using
A. FTP wizard
B. Internet assistant wizard
C. Intranet wizard
D. Import wizard
Answer : B

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

37. Which of the following is not the correct method of editing the cell content?
A. Press the Alt key
B. Press the F2 key
C. Click the formula bar
D. Double click the cell
Answer : A

38. What is the correct way to refer the cell A10 on sheet3 from sheet1?
A. sheet3!A10
B. sheet1!A10
C. Sheet3.A10
D. A10
Answer : A

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

40. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
A. An absolute cell address is created
B. Cell address will change when it is copied to another cell
C. The sheet tab is changed
D. The status bar does not display the cell address
Answer : A

41. Which of the following is not a term of MS-Excel?
A. Cells
B. Rows
C. Columns
D. Document
Answer : D

42. Which of the following methods can not be used to edit the contents of a cell?
A. Press the Alt key
B. Clicking the formula bar
C. Pressing the F2 key
D. Double clicking the cell
Answer : A

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

44. Which of the following is not true regarding Conditional Formatting?
A. You can add more than one condition to check
B. You can set condition to look for Bold and apply Italics on them
C. You can apply Font, border and pattern formats that meets the specified conditions
D. You can delete any condition from Conditional Formatting dialog box if it is not requried
Answer : B

45. Which of the following Excel screen components can NOT be turned on oroff?
A. Formula Bar
B. Status Bar
C. Tool Bar
D. None of above
Answer : D

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

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

48. Which of the following options is not located in the Page Setup dialog box?
A. Page Break Preview
B. Page Orientation
C. Margins
D. Headers and Footers
Answer : A

49. What does COUNTA () function do?
A. counts cells having alphabets
B. counts empty cells
C. counts cells having number
D. counts non-empty cells
Answer : D

50. MS-EXCEL is based on .........?
A. WINDOWS
B. DOS
C. UNIX
D. OS/2
Answer : A