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- 1
Q.1. Which of the following methods can not be used to enter data in a cell?
A) Pressing an arrow key
B) Pressing the tab key
C) Pressing the Esc key
D) Clicking the enter button to the formula bar
E) None of these
B) Pressing the tab key
C) Pressing the Esc key
D) Clicking the enter button to the formula bar
E) None of these
Q.2. Which of following syntax is correct regarding sum function in Excel?
A) = SUM(A1, A2)
B) = SUM(A1:A6)
C) = SUM(A1:A5, B2:B6)
D) All above
E) None of these
B) = SUM(A1:A6)
C) = SUM(A1:A5, B2:B6)
D) All above
E) None of these
Q.3. Which among following is types of excel data types ?
A) Numbers, Formulas, Labels
B) Data, Words, Numbers
C) Words, Number, Labels
D) Equations, Data, Numbers
E) None of these
B) Data, Words, Numbers
C) Words, Number, Labels
D) Equations, Data, Numbers
E) None of these
Q.4. What function displays row data in a column or column data in a row?
A) Hyperlink
B) Index
C) Transpose
D) Rows
E) None of these
B) Index
C) Transpose
D) Rows
E) None of these
Q.5. What is the shortcut key to hide whole column in MS Excel?
A) Ctrl + H
B) Ctrl + 0
C) Ctrl + 3
D) Ctrl + S
E) None of these
B) Ctrl + 0
C) Ctrl + 3
D) Ctrl + S
E) None of these
Q.6. One cell format can be copied to another cell by using ?
A) Format Painter
B) Format Setting
C) Format Showing
D) Format Checking
E) None of these
B) Format Setting
C) Format Showing
D) Format Checking
E) None of these
Q.7. When you insert an Excel file into a Word document, the data is-
A) Hyperlinked
B) Placed in a word table
C) Show error
D) Embedded
E) None of these
B) Placed in a word table
C) Show error
D) Embedded
E) None of these
Q.8. Selecting the columns B and C than choose 'insert column'. What will happen?
A) Two columns will be inserted after B
B) Two columns will be inserted before B
C) Two columns will be inserted after C
D) Two columns will be inserted before C
E) None of these
B) Two columns will be inserted before B
C) Two columns will be inserted after C
D) Two columns will be inserted before C
E) None of these
Q.9. You will use which feature in excel, if you want to work with one record at a time ?
A) Auto Complete
B) Auto Filter
C) Sub Totals
D) Data Form
E) None of these
B) Auto Filter
C) Sub Totals
D) Data Form
E) None of these
Q.10. Macros are “run” or executed from which menu in MS Excel?
A) Insert
B) Format
C) Tools
D) Data
E) None of these
B) Format
C) Tools
D) Data
E) None of these
Answers of above questions:
- C
- D
- A
- C
- B
- A
- B
- B
- D
- C
Recommended Posts:
- 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