Home

Microsoft Excel MCQ Solved Paper for RBI Grade B officer

Thursday 9th of March 2023

Sharing is caring

Downlaod Microsoft Excel MCQ PDF
1. 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
2. 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
3. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
A. Right click on Sheet Tab of third sheet and choose Delete from the context menu
B. Click on Sheet 3 and from Edit menu choose Delete
C. Both of above
D. None of above
Answer : A
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. The autofill feature
A. extends a sequential series of data
B. automatically adds range of cell values
C. applies a boarder around the selected cells
D. none of the above
Answer : D
6. 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
7. The Name box on to the left of formula bar
A. shows the name of workbook currently working on
B. shows the name of worksheet currently working on
C. shows the name of cell or range currently working on
D. None of above
Answer : C
8. 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
9. 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
10. 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
11. 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
12. Comments can be added to cells using ......
A. Edit -> Comments
B. Insert -> Comment
C. File -> Comments
D. View > Comments
Answer : B
13. Which of the following is not a worksheet design criterion?
A. Efficiency
B. Aditibility
C. Description
D. Clarity
Answer : C
14. 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
15. 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
16. What symbol is used before a number to make it a label?
A. ( quote )
B. = ( equal )
C. _ ( underscore )
D. ( apostrophe )
Answer : D
17. 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
18. In the formula, which symbol specifies the fixed columns or rows?
A. $
B. *
C. %
D. &
Answer : A
19. 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
20. Multiple calculations can be made in a single formula using
A. standard formulas
B. array formula
C. complex formulas
D. smart formula
Answer : B
21. How do you display current date only in MS Excel?
A. date ()
B. Today ()
C. now ()
D. time ()
Answer : B
22. When a row of data is to be converted into columns
A. Copy the cells in row, select the same number of cells in row and paste
B. Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
C. Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
D. Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK
Answer : D
23. Which is not the function of Edit, Clear command?
A. Delete contents
B. Delete notes
C. Delete cells
D. Delete formats
Answer : C
24. Which is used to perform what if analysis?
A. Solver
B. Goal seek
C. Scenario Manager
D. All of above
Answer : D
25. 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
26. 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
27. Which key do you press to check spelling?
A. F3
B. F5
C. F7
D. F9
Answer : C
28. 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
29. Which of the following you can paste selectively using Paste Special command?
A. Validation
B. Formats
C. Formulas
D. All of above
Answer : D
30. Which of the following is the latest version of Excel
A. Excel 2000
B. Excel 2002
C. Excel ME
D. Excel XP
Answer : D
31. 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
32. 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
33. Which would you choose to create a bar diagram?
A. Edit, Chart
B. Insert, Chart
C. Tools, Chart
D. Format, Chart
Answer : B
34. 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
35. 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
36. 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
37. Which of the following is an absolute cell reference?
A. !A!1
B. $A$1
C. #a#1
D. A1
Answer : B
38. How can you print three copies of a workbook?
A. Select File > Properties form the menu and type 3 in the Copies to print text box
B. Select File > Print from the menu and type 3 in the Number of copies text box
C. Click the Print button on the standard toolbar to print the document then take it to Kinkos and have 2 more copies made
D. Press Ctrl+P+3
Answer : B
39. 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
40. Hyperlinks can be
A. Text
B. Drawing objects
C. Pictures
D. All of above
Answer : D
41. What is represented by the small, black square in the lower-right corner of an active cell or range?
A. Copy handle
B. Fill handle
C. Insert handle
D. Border
Answer : B
42. Which Chart can be created in Excel?
A. Area
B. Line
C. Pie
D. All of the above
Answer : D
43. How many worksheets can a workbook have?
A. 3
B. 8
C. 255
D. none of above
Answer : D
44. Which setting you must modify to pint a worksheet using letterhead?
A. Paper
B. Margin
C. Layout
D. Orientation
Answer : B
45. How can you find specific information in a list?
A. Select Tools > Finder from the menu
B. Click the Find button on the standard toolbar
C. Select Insert > Find from the menu
D. Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
Answer : D
46. Which elements of worksheet can be protected from accidental modification
A. Contents
B. Objects
C. Scenarios
D. All of above
Answer : D
47. Which of the following formulas is not entered correctly?
A. =10+50
B. 10+50
C. =10+50
D. =B7+14
Answer : B
48. 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
49. 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
50. An excel workbook is a collection of
A. Workbooks
B. Worksheets
C. Charts
D. Worksheets and charts
Answer : D
Downlaod Microsoft Excel MCQ PDF

Sharing is caring

Related Post