Here we have published 10 questions of MS Excel for preparation of computer awareness section asked in IBPS, SBI, banking exams and other exams. MS Excel is one of the most important part of MS Office and used widely for handling data and fast calculations for official and personal record. Good knowledge of Microsoft Excel is must for office jobs.
Computer Knowledge MS Excel MCQs Test Paper- 5
Q.1. Shortcut to Switch between open workbooks is-
A) Ctrl + F2
B) Ctrl + F6
C) Ctrl + F8
D) Ctrl + F10
E) None of these
B) Ctrl + F6
C) Ctrl + F8
D) Ctrl + F10
E) None of these
Q.2. Shortcut to delete selected column is-
A) Ctrl + -
B) Alt + -
C) Shift + -
D) Ctrl + Shift + -
E) None of these
B) Alt + -
C) Shift + -
D) Ctrl + Shift + -
E) None of these
Q.3. You can use the formula palette to-
A) Format cells containing numbers
B) Create and edit formula containing functions
C) Enter assumptions data
D) Copy a range of cells
E) None of these
B) Create and edit formula containing functions
C) Enter assumptions data
D) Copy a range of cells
E) None of these
Q.4. 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) Shows the name of workbook and cell currently working on
E) None of these
B) Shows the name of worksheet currently working on
C) Shows the name of cell or range currently working on
D) Shows the name of workbook and cell currently working on
E) None of these
Q.5. Which of the cell pointer indicate that you can move the content to other cell?
A) Doctor’s symbol (Big Plus)
B) Small thin plus icon
C) Mouse Pointer with anchor at the tip
D) Mouse pointer with time glass at the tip
E) None of these
B) Small thin plus icon
C) Mouse Pointer with anchor at the tip
D) Mouse pointer with time glass at the tip
E) None of these
Q.6. Which of the cell pointer indicates you that you can make selection?
A) Mouse pointer with time glass at the tip
B) Mouse Pointer with anchor at the tip
C) Small thin plus icon
D) Doctor’s symbol (Big Plus)
E) None of these
B) Mouse Pointer with anchor at the tip
C) Small thin plus icon
D) Doctor’s symbol (Big Plus)
E) None of these
Q.7. Which of the following option is not available in Paste Special dialog box?
A) Add
B) Subtract
C) Divide
D) SQRT
E) None of these
B) Subtract
C) Divide
D) SQRT
E) None of these
Q.8. What happens when you press Ctrl + X after selecting some cells in Excel?
A) The cell content of selected cells disappear from cell and stored in clipboard
B) The cells selected are marked for cutting
C) The selected cells are deleted and the cells are shifted left
D) The selected cells are deleted and cells are shifted up
E) None of these
B) The cells selected are marked for cutting
C) The selected cells are deleted and the cells are shifted left
D) The selected cells are deleted and cells are shifted up
E) None of these
Q.9. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
A) F9
B) F10
C) F3
D) F4
E) None of these
B) F10
C) F3
D) F4
E) None of these
Q.10. How do you change column width to fit the contents ?
A) Press Alt and single click anywhere in the column
B) Single-click the boundary to the left to the column heading
C) Double click the boundary to the right of the column heading
D) All of above
E) None of these
B) Single-click the boundary to the left to the column heading
C) Double click the boundary to the right of the column heading
D) All of above
E) None of these
Answers of above questions:
- B
- A
- B
- C
- C
- D
- D
- B
- A
- C
Recommended Posts:
- Microsoft Excel Practice Question Paper- 1 with Answer Key
- Microsoft Excel Practice Question Paper- 2 with Answer Key
- Microsoft Excel Practice Question Paper- 3 with Answer Key
- Microsoft Excel Practice Question Paper- 4 with Answer Key
- Click for More Computer Knowledge/ Computer Awareness Question Papers
- List of Best and Recommended Books for Computer Awareness.
- Click to Subscribe and Get Updates of Computer Knowledge Question Papers in your Inbox.
We have tried our best to present only
important computer awareness questions with correct answer key. Any suggestion or update
about any erroneous entry or answer is always appreciable. Please comment your score or any suggestion in comment section below or you can write to us at careerguide.co@gmail.com. We will be glad to help you.
Want to Stay in Contact !
Get new posts and updates in your inbox. Subscribe through our Feedburner Email subscription.
No comments:
Post a Comment