1000+ Microsoft Excel MCQ for IBPS Clerk [Solved]
Thursday 9th of March 2023
Sharing is caring
1. Which of the following is not a valid data type in Excel?
A. Number
B. Character
C. Label
D. Date/Time
Answer : B
A. Number
B. Character
C. Label
D. Date/Time
Answer : B
2. Which of the following formulas is not entered correctly?
A. =10+50
B. 10+50
C. =10+50
D. =B7+14
Answer : B
A. =10+50
B. 10+50
C. =10+50
D. =B7+14
Answer : B
3. 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
A. Hyperlinked placed in a word table
B. Linked
C. Embedded
D. Use the word menu bar and toolbars
Answer : B
4. A worksheet can have a maximum of …. Number of rows
A. 256
B. 1024
C. 32000
D. 65535
Answer : D
A. 256
B. 1024
C. 32000
D. 65535
Answer : D
5. 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
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
6. How do you select an entire column?
A. Select Edit > Select > Column from the menu
B. Click the column heading letter
C. Hold down the shift key as you click anywhere in the column
D. Hold down the Ctrl key as you click anywhere in the column
Answer : B
A. Select Edit > Select > Column from the menu
B. Click the column heading letter
C. Hold down the shift key as you click anywhere in the column
D. Hold down the Ctrl key as you click anywhere in the column
Answer : B
7. 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
A. One sheet is selected
B. When many sheets are selected
C. When no sheet is selected
D. None of above
Answer : B
8. 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
A. Option buttons
B. List boxes
C. Text boxes
D. Combo boxes
Answer : C
9. 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
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
10. 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
A. Ctrl + R
B. Ctrl + Shift + R
C. Ctrl + H
D. Ctrl + F
Answer : C
11. To copy cell contents using drag and drop press the
A. End key
B. Shift key
C. Ctrl key
D. Esc key
Answer : A
A. End key
B. Shift key
C. Ctrl key
D. Esc key
Answer : A
12. Excel probably considers the cell entry January 1, 2000 to be a
A. Label
B. Value
C. Formula
D. Text string
Answer : B
A. Label
B. Value
C. Formula
D. Text string
Answer : B
13. 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
A. Cell value
B. Formula
C. Both of above
D. None of above
Answer : C
14. What will be the output if you format the cell containing 5436.8 as #,##0.00'?
A. 5430
B. 5436.80
C. 5436.8
D. 6.8
Answer : B
A. 5430
B. 5436.80
C. 5436.8
D. 6.8
Answer : B
15. The spelling dialog box can be involved by choosing spelling from ________ menu.
A. insert
B. file
C. tools
D. view
Answer : C
A. insert
B. file
C. tools
D. view
Answer : C
16. 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
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
17. 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
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
18. 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
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
19. You can use the formula pallette to
A. format cells containing numbers
B. create and edit formula containing functions
C. enter assumptions data
D. copy a range of cells
Answer : B
A. format cells containing numbers
B. create and edit formula containing functions
C. enter assumptions data
D. copy a range of cells
Answer : B
20. Concatenation of text can be done using
A. Apostrophe (&lsquo
B. Exclamation (!)
C. Hash (#)
D. Ampersand (&
Answer : D
A. Apostrophe (&lsquo
B. Exclamation (!)
C. Hash (#)
D. Ampersand (&
Answer : D
21. How can you show or hide the gridlines in Excel Worksheet?
A. Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
B. Click Gridline tool on Forms toolbar
C. Both of above
D. None of above
Answer : C
A. Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
B. Click Gridline tool on Forms toolbar
C. Both of above
D. None of above
Answer : C
22. 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
A. AutoFill
B. Auto correct
C. Auto sum
D. Auto format
Answer : C
23. 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
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
24. Which is used to perform what if analysis?
A. Solver
B. Goal seek
C. Scenario Manager
D. All of above
Answer : D
A. Solver
B. Goal seek
C. Scenario Manager
D. All of above
Answer : D
25. Which of the following is not information you can specify using the solver?
A. Input cells
B. Constraints
C. Target cell
D. Changing cells
Answer : A
A. Input cells
B. Constraints
C. Target cell
D. Changing cells
Answer : A
26. How many characters can be typed in a single cell in Excel?
A. 256
B. 1024
C. 32000
D. 65535
Answer : D
A. 256
B. 1024
C. 32000
D. 65535
Answer : D
27. 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
A. A type of chart
B. A cell reference
C. A collection of related data
D. A division of results
Answer : C
28. Microsoft Excel is a powerful ...........
A. Word processing package
B. Spreadsheet package
C. Communication S/W Package
D. DBMS package
Answer : B
A. Word processing package
B. Spreadsheet package
C. Communication S/W Package
D. DBMS package
Answer : B
29. 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
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
30. 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
A. Cells B7 and cell B9 only
B. Cells B7 through B9
C. Cell B8 only
D. None of the above
Answer : B
31. What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
A. XY Chart
B. Line Chart
C. Pie Chart
D. Column Chart
Answer : C
A. XY Chart
B. Line Chart
C. Pie Chart
D. Column Chart
Answer : C
32. 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
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
33. 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
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
34. 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
A. Format, cells, font
B. Format, cells, protection
C. Format, cells, number
D. Format, cells, alignment
Answer : D
35. 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
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
36. Which menu option can be used to split windows into two?
A. Format -> Window
B. View -> Window-> Split
C. Window -> Split
D. View > Split
Answer : C
A. Format -> Window
B. View -> Window-> Split
C. Window -> Split
D. View > Split
Answer : C
37. While Finding and Replacing some data in Excel, which of the following statement is valid?
A. You can Find and Replace within the sheet or workbook
B. Excel does not have option to match case for find
C. Both are valid
D. None are valid
Answer : A
A. You can Find and Replace within the sheet or workbook
B. Excel does not have option to match case for find
C. Both are valid
D. None are valid
Answer : A
38. 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
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
39. 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
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
40. 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
A. Press the Alt key
B. Clicking the formula bar
C. Pressing the F2 key
D. Double clicking the cell
Answer : A
41. Which of the following you can paste selectively using Paste Special command?
A. Validation
B. Formats
C. Formulas
D. All of above
Answer : D
A. Validation
B. Formats
C. Formulas
D. All of above
Answer : D
42. Which setting you must modify to print a worksheet using letterhead?
A. Paper
B. Margin
C. Layout
D. Orientation
Answer : B
A. Paper
B. Margin
C. Layout
D. Orientation
Answer : B
43. Hyperlinks can be
A. Text
B. Drawing objects
C. Pictures
D. All of above
Answer : D
A. Text
B. Drawing objects
C. Pictures
D. All of above
Answer : D
44. 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
A. The edit formula button
B. The cancel button
C. The enter button
D. All of the above
Answer : D
45. How do you display current date and time in MS Excel?
A. date ()
B. Today ()
C. now ()
D. time ()
Answer : C
A. date ()
B. Today ()
C. now ()
D. time ()
Answer : C
46. 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
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
47. Which is not the function of Edit, Clear command?
A. Delete contents
B. Delete notes
C. Delete cells
D. Delete formats
Answer : C
A. Delete contents
B. Delete notes
C. Delete cells
D. Delete formats
Answer : C
48. 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
A. Press the Alt key
B. Press the F2 key
C. Click the formula bar
D. Double click the cell
Answer : A
49. Which symbol must all formula begin with?
A. =
B. +
C. (
D. @
Answer : A
A. =
B. +
C. (
D. @
Answer : A
50. 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
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
Sharing is caring
Related Post
Choosing the correct sentence MCQ Solved Paper for RBI Grade B officer
1000+ Microsoft Word Multiple Choice Question Answer [Solved]
1000+ Data Structure Multiple Choice Question Answer [Solved]
Chemical Process MCQ Solved Paper for UPSC CDS
1000+ WAN MCQ for DRDO [Solved]
Cell - the unit of life MCQ Solved Paper for GRE