IBPS SO - Microsoft Excel 1000+ MCQ [Solved] PDF Download

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

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

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

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

5. Which of following is Not one of Excels what-if function?
A. Goal seek
B. Solver
C. Scenario manager
D. Auto Outline
Answer : D

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

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

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

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

10. Which of the following you can paste selectively using Paste Special command?
A. Validation
B. Formats
C. Formulas
D. All of above
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. Which of the following is not a valid data type in Excel?
A. Number
B. Character
C. Label
D. Date/Time
Answer : B

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

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

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

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

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

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

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

20. Which of the following is invalid statement?
A. Sheet tabs can be colored
B. Some picture can be applied as a background of a sheet
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

21. To copy formatting from one area in a worksheet and apply it to another area you would use:
A. The Edit > Copy Format and Edit>Paste Format commands form the menu
B. The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu
C. There is no way to copy and apply formatting in Excel You have to do it manually
D. The Format Painter button on the standard toolbar
Answer : D

22. You can auto fit the width of column by
A. double clicking on the olumn name on column header
B. Double click on the cell pointer in worksheet
C. Double clicking on column right border on column header
D. Double clicking on the column left border of column header
Answer : C

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

24. To create a formula, you can use:
A. Values but not cell references
B. Cell references but not values
C. Values or cell references although not both at the same time
D. Value and cell references
Answer : D

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

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

27. Ctrl + D shortcut key in Excel will
A. Open the font dialog box
B. Apply double underline for the active cell
C. Fill down in the selection
D. None of above
Answer : C

28. It is acceptable to let long text flow into adjacent cells on a worksheet when
A. data will be entered in the adjecent cells
B. no data will be entered in the adjacent cells
C. there is no suitable abbrevition for the text
D. there is not time to format the text
Answer : B

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

30. A worksheet range is a
A. A command used for data modeling
B. A range of values such as from 23 to 234
C. A group of cells
D. A group of worksheets
Answer : C

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

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

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

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

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

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

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

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

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

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

42. Text formulas:
A. Replace cell references
B. Return ASCII values of characters
C. Concatenate and manipulate text
D. Show formula error value
Answer : C

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

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

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

46. You can move a sheet from one workbook into new book by
A. From Edit menu choose Move orCopy 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

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

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

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

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