Microsoft Excel 1000+ MCQ with answer for NMAT

1. 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. Allow you to view additional sheets tabs
Answer : D

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

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

4. Which of the following is not a basic step in creating a worksheet?
A. Save workbook
B. Modifiy the worksheet
C. Enter text and data
D. Copy the worksheet
Answer : D

5. Files created with Lotus 1-2-3 have an extension
A. DOC
B. XLS
C. 123
D. WK1
Answer : C

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

7. The first cell in EXCEL worksheet is labeled as
A. AA
B. A1
C. Aa
D. A0
Answer : B

8. Excel uniquely identifies cells within a worksheet with a cell name
A. Cell names
B. Column numbers and row letters
C. Column letters and row numbers
D. Cell locator coordinates
Answer : C

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

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

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

12. When a range is selected, how can you activate the previous cell?
A. Press the Alt key
B. Press Tab
C. Press Enter
D. None of above
Answer : D

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

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

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

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

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

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

19. When you want to insert a blank imbedded excel object in a word document you can
A. Click the object command on the insert menu
B. Click the office links button on the standard toolbar
C. Click the create worksheet button on the formatting toolbar
D. Click the import excel command on the file menu
Answer : A

20. The Paste Special command lets you copy and paste:
A. Multiply the selection by a copied value
B. Cell comments
C. Formatting options
D. The resulting values of a formula instead of the actual formula
Answer : D

21. Which of the following is not a valid data type in Excel?
A. Number
B. Character
C. Label
D. Date/Time
Answer : B

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

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

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

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

26. Which of the following you can paste selectively using Paste Special command?
A. Validation
B. Formats
C. Formulas
D. All of above
Answer : D

27. When you copy a formula
A. Excel erases the original copy of the formula
B. Excel edits cell references in the newly copied formula
C. Excel adjusts absolute cell references
D. Excel doesnt adjust relative cell references
Answer : B

28. You cannot link excel worksheet data to a word document
A. With the right drag method
B. With a hyperlink
C. With the copy and paste special commands
D. With the copy and paste buttons on the standard toolbar
Answer : D

29. How do you insert a row?
A. Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
B. Select the row heading where you want to insert the new row and select Edit >Row from the menu
C. Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
D. All of the above
Answer : A

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

31. Data can be arranged in a worksheet in a easy to understand manner using
A. auto formatting
B. applying styles
C. changing fonts
D. all of above
Answer : D

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

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

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

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

36. Rounding errors can occur
A. When you use multiplication, division, or exponentiation in a formula
B. When you use addition and subtraction in a formula
C. Because excel uses hidden decimal places in computation
D. When you show the results of formulas with different decimal places that the calculated results
Answer : A

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

38. Which of the following is a correct order of precedence in formula calculation?
A. Multiplication and division exponentiation positive and negative values
B. Multiplication and division, positive and negative values, addition and subtraction
C. Addition and subtraction, positive and negative values, exponentiation
D. All of above
Answer : D

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

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

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

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

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

44. 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. Decreasethe column width
D. Adjust the row height
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. The name box
A. Shows the location of the previously active cell
B. Appears to the left of the formula bar
C. Appears below the status bar
D. Appears below the menu bar
Answer : B

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

48. The spelling dialog box can be involved by choosing spelling from ________ menu.
A. insert
B. file
C. tools
D. view
Answer : C

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

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