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- 2
Q.1. When creating a vertical page break ?
A) The active cell must be in row 1
B) The active cell must be A1
C) The active cell must be in row 10
D) The active cell must be in column A
E) None of these
B) The active cell must be A1
C) The active cell must be in row 10
D) The active cell must be in column A
E) None of these
Q.2. Each excel file is called a workbook because-
A) It can contain text and data
B) It can be modified
C) It can contain many sheets including worksheets and chart sheets
D) All of the above
E) None of these
B) It can be modified
C) It can contain many sheets including worksheets and chart sheets
D) All of the above
E) None of these
Q.3. How can we restrict values of a cell so that only whole numbers between 1 and 99 can be entered in the cell?
A) Data -> Filter
B) Data -> Validation
C) Data -> Consolidate
D) Format -> Conditional formatting
E) None of these
B) Data -> Validation
C) Data -> Consolidate
D) Format -> Conditional formatting
E) None of these
Q.4. Where are the status indicators located in MS Excel?
A) Horizontal Scroll
B) Vertical Scroll
C) Address Bar
D) Formula Bar
E) None of these
B) Vertical Scroll
C) Address Bar
D) Formula Bar
E) None of these
Q.5. How should you print a selected area of a worksheet, if you’ll want to print a different area next time?
A) File -> print -> set print area
B) File-> print -> selection
C) View -> custom views -> add
D) All of above
E) None of these
B) File-> print -> selection
C) View -> custom views -> add
D) All of above
E) None of these
Q.6. By pressing a 'Delete' key in MS Excel, the keyboard will clear?
A) Text only
B) Format only
C) Content only
D) Both content and format
E) None of these
B) Format only
C) Content only
D) Both content and format
E) None of these
Q.7. We can cancel marquee by pressing ?
A) Ctrl + Esc
B) Alt + Esc
C) Shift + Esc
D) Esc
E) None of these
B) Alt + Esc
C) Shift + Esc
D) Esc
E) None of these
Q.8. What term refers to a specific set of values saved with the workbook?
A) Range
B) Scenario
C) Trend line
D) What-if analysis
E) None of these
B) Scenario
C) Trend line
D) What-if analysis
E) None of these
Q.9. The shortcut to create new line in the existing cell is-
A) Enter
B) Ctrl + Enter
C) Shift + Enter
D) Alt + Enter
E) None of these
B) Ctrl + Enter
C) Shift + Enter
D) Alt + Enter
E) None of these
Q.10. Which of the following methods cannot be used to edit the content of cell ?
A) Pressing F2
B) Clicking the formula bar
C) Pressing the Alt key
D) Double clicking the cell
E) None of these
B) Clicking the formula bar
C) Pressing the Alt key
D) Double clicking the cell
E) None of these
Answers of above questions:
- A
- C
- B
- D
- B
- C
- D
- B
- D
- C
Recommended Posts:
- Microsoft Excel Practice Question Paper- 1 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.
Comments
Post a Comment