Microsoft Excel MCQ Solved Paper for SBI PO

1. Which of the following is an absolute cell reference?
A. !A!1
B. $A$1
C. #a#1
D. A1
Answer : B

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

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

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

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

6. You can copy data or formulas
A. With the copy, paste and cut commands on the edit menu
B. With commands on the shortcut menu
C. With buttons on the standard toolbars
D. All of the above
Answer : D

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

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

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

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

11. You can select a single range of cells by
A. Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
B. Pressing the Ctrl key while dragging over the desired cells
C. Pressing the Shift key and an arrow key
D. Dragging over the desired cells
Answer : D

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. What do you mean by a Workspace?
A. Group of Columns
B. Group of Worksheets
C. Group of Rows
D. Group of Workbooks
Answer : D

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

15. Which would you choose to create a bar diagram?
A. Edit, Chart
B. Insert, Chart
C. Tools, Chart
D. Format, Chart
Answer : B

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

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

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

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

20. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
A. server
B. source
C. client
D. none
Answer : C

21. Which Chart can be created in Excel?
A. Area
B. Line
C. Pie
D. All of the above
Answer : D

22. Where can you change automatic or manual calculation mode in Excel?
A. Double CAL indicator on status bar
B. Go to Tools >> Options >> Calculation and mark the corresponding radio button
C. Both of above
D. None of above
Answer : B

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

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

25. You can auto fit the width of column by
A. double clicking on the column 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

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

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

28. When the formula bar is active, you can see
A. The edit formula button
B. The cancel button
C. The enter button
D. All of the above
Answer : D

29. To activate the previous cell in a pre-selected range, press
A. The Alt key
B. The Tab key
C. The Enter key
D. None of the above
Answer : D

30. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
A. None of these
B. Select Format > Money from the menu
C. Click the Currency Style button on the formatting toolbar
D. You have to retype everything and manually add the dollar signs, commas, and decimals
Answer : C

31. To center worksheet titles across a range of cells, you must
A. Select the cells containing the title text plus the range over which the title text is to be centered
B. Widen the columns
C. Select the cells containing the title text plus the range over which the title text is to be enfettered
D. Format the cells with the comma style
Answer : A

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

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

34. Which of the following methods cannot be used to enter data in a cell
A. Pressing an arrow key
B. Pressing the Tab key
C. Pressing the Esc key
D. Clicking on the formula bar
Answer : C

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

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

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

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

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

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

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

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

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

44. Which area in an excel window allows entering values and formulas
A. Title bar
B. Menu bar
C. Formula bar
D. Standard toolbar
Answer : C

45. A worksheet can have a maximum of …. Number of rows
A. 256
B. 1024
C. 32000
D. 65535
Answer : D

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

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

48. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
A. Press Ctrl +Home
B. Press Home
C. Press Shift + Home
D. Press Alt + Home
Answer : A

49. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
A. AutoFill
B. Auto correct
C. Auto sum
D. Auto format
Answer : C

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