CLAT PG - Microsoft Excel 1000+ MCQ [Solved] PDF Download

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

2. Long text can be broken down into many lines within a cell. You can do this through
A. Wrap Text in Format >> Cells
B. Justify in Edit >> Cells
C. Text Wraping in Format >> Cells, Layout tab
D. All of above
Answer : A

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

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

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

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

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

8. In Excel, the Fill Color button on the Formatting toolbar is used for what?
A. To insert a background
B. To add borders
C. To select a distribution of figures
D. To add shading or color to a cell range
Answer : D

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

10. How can you remove borders applied in cells?ACC
A. Choose None on Border tab of Format cells
B. Open the list on Border tool in Formatting toolbar then choose first tool (no border)
C. Both of above
D. None of above
Answer : C

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 format you can decide to apply or not in AutoFormat dialog box?
A. Number format
B. Border format
C. Font format
D. All of above
Answer : D

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

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

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

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

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

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

19. Where can you set the shading color for a range of cells in Excel?
A. Choose required color form Patterns tab of Format Cells dialog box
B. Choose required color on Fill Color tool in Formatting toolbar
C. Choose required color on Fill Color tool in Drawing toolbar
D. All of above
Answer : D

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

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

22. An Excel Workbook is a collection of .......
A. Workbooks
B. Worksheets
C. Charts
D. Worksheets and Charts
Answer : D

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

24. Which of the following is invalid statement?
A. Sheet tabs can be colored
B. Some picture can be applied as a background of a heet
C. You can set the column width automatically fit the amount of text
D. The width of a row and be specified manually or fit automatically
Answer : D

25. Which of the following is not true about Find and Replace in Excel
A. You can search for bold and replace with italics
B. You can decide whether to look for the whole word or not
C. You can search in formula too
D. You can search by rows or columns or sheets
Answer : D

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

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

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

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

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

31. Concatenation of text can be done using
A. Apostrophe (&lsquo
B. Exclamation (!)
C. Hash (#)
D. Ampersand (&
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. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
A. Option buttons
B. List boxes
C. Text boxes
D. Combo boxes
Answer : C

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

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

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

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

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

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

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

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

42. To select an entire column in MS-EXCEL, press?
A. CTRL + C
B. CTRL + Arrow key
C. CTRL + S
D. None of the above
Answer : D

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

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

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

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

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