UPSC IES - Microsoft Excel 1000+ MCQ [Solved] PDF Download

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

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

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

4. 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 word document must contain a hyperlink
D. The word document contains a copy of the actual data
Answer : B

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

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

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

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

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

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

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

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

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

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

15. In a worksheet you can select
A. The entire worksheet
B. Rows
C. Columns
D. All of the above
Answer : B

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

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

18. How many characters can be typed in a single cell in Excel?
A. 256
B. 1024
C. 32000
D. 65535
Answer : D

19. You can check the conditions against __________ when applying conditional formatting
A. Cell value
B. Formula
C. Both of above
D. None of above
Answer : C

20. Which of the following is not a way to complete a cell entry?
A. Pressing enter
B. Pressing any arrow key on the keyboard
C. Clicking the Enter button on the Formula bar
D. Pressing spacebar
Answer : D

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

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

23. How do you rearrange the data in ascending or descending order?
A. Data, Sort
B. Data,Form
C. Data, Table
D. Data Subtotals
Answer : A

24. Which of the following is not an example of a value?
A. 350
B. May 10, 2001
C. 0.57
D. Serial Number 50771
Answer : D

25. Right clicking something in Excel:
A. Deletes the object
B. Nothing the right mouse button is there for left handed people
C. Opens a shortcut menu listing everything you can do to the object
D. Selects the object
Answer : C

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

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

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

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

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

31. What is the short cut key to replace a data with another in sheet?
A. Ctrl + R
B. Ctrl + Shift + R
C. Ctrl + H
D. Ctrl + F
Answer : C

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

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

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

35. What is the short cut key to highlight the entire column?
A. Ctrl+C
B. Ctrl+Enter
C. Ctrl+Page Up
D. Ctrl+Space Bar
Answer : D

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

37. You can use the formula palette to
A. Format cells containing numbers
B. Create and edit formulas containing functions
C. Enter assumptions data
D. Copy a range of cells
Answer : B

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

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

40. Which area in an Excel window allows entering values and formulas?
A. Title Bar
B. Menu Bar
C. Formula Bar
D. Standard Tool Bar
Answer : C

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

42. The active cell:
A. is defined by a bold border around the cell
B. Receives the data the user enters
C. It is the formula bar
D. Only A and B
Answer : D

43. Excel probably considers the cell entry January 1, 2000 to be a
A. Label
B. Value
C. Formula
D. Text string
Answer : B

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

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

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