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- 3
Q.1. How do you change column width to fit the contents?
A) Single-click the boundary to the left to the column heading
B) Double click the boundary to the right of the column heading
C) Press Alt and single click anywhere in the column
D) All of above
E) None of these
B) Double click the boundary to the right of the column heading
C) Press Alt and single click anywhere in the column
D) All of above
E) None of these
Q.2. A smart tag will be removed from the cell when-
A) Data in the cell is changed or deleted
B) Cell is moved
C) Formatting of the cell is changed
D) Cell is hidden
E) None of these
B) Cell is moved
C) Formatting of the cell is changed
D) Cell is hidden
E) None of these
Q.3. Shortcut to enter current date in a cell in MS Excel is-
A) Home + ;
B) Shift + ;
C) Alt + ;
D) Ctrl + ;
E) None of these
B) Shift + ;
C) Alt + ;
D) Ctrl + ;
E) None of these
Q.4. When you link data maintained in Excel workbook to a Word document-
A) The Word document cannot be edited
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
E) None of these
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
E) None of these
Q.5. Which of the following function will return a value of 6?
A) ROUNDUP (5.499, 0)
B) ROUNDDOWN (5.499, 0)
C) ROUND (5.499, 0)
D) Both A and B
E) None of these
B) ROUNDDOWN (5.499, 0)
C) ROUND (5.499, 0)
D) Both A and B
E) None of these
Q.6. When the formula bar is activated, you can see-
A) The Edit Formula button
B) The Cancel button
C) The Enter button
D) All of above
E) None of these
B) The Cancel button
C) The Enter button
D) All of above
E) None of these
Q.7. When you see a cell with a red triangle in the top right corner in MS Excel, what does this signify?
A) There is an error in the cell
B) There is a comment associated with the cell
C) The font color for text in the cell is red
D) A formula cannot be entered into the cell
E) None of these
B) There is a comment associated with the cell
C) The font color for text in the cell is red
D) A formula cannot be entered into the cell
E) None of these
Q.8. What should be added before a number to avoid it to be added as a date in Microsoft Excel?
A) Zero
B) Backslash
C) Zero Space
D) Semi-colon
E) None of these
B) Backslash
C) Zero Space
D) Semi-colon
E) None of these
Q.9. Style sheet formats can be applied from ?
A) Table -> Autoformat
B) Format -> Autoformat
C) Table -> Cells
D) Fromat -> Cells
E) None of these
B) Format -> Autoformat
C) Table -> Cells
D) Fromat -> Cells
E) None of these
Q.10. A function inside another function is called-
A) Nested function
B) Round function
C) Sum function
D) Text function
E) None of these
B) Round function
C) Sum function
D) Text function
E) None of these
Answers of above questions:
- B
- A
- D
- B
- D
- D
- B
- C
- B
- A
Recommended Posts:
- Microsoft Excel Practice Question Paper- 1 with Answer Key
- Microsoft Excel Practice Question Paper- 2 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