We designed Top 100 MS-Excel MCQ to help every professional and student. Practice these Top 100 MS-Excel MCQ to test and enhance your knowledge in Microsoft Excel.
Top 100 MS-Excel MCQ
Q1. What is Microsoft Excel primary used for?
a) Word Processing
b) Database Management
c) Spreadsheet Calculations and Data Analysis
d) Creating Presentations
Answer – [C]
Q2. Which area in an Excel Window allows entering values and formulas?
a) Standard Tool Bar
b) Title Bar
c) Formula Bar
d) None of the above
Answer – [C]
Q3. NOT, AND, OR and XOR are
a) Logical Operators
b) Arithmetic Operators
c) Relational Operators
d) None of the above
Answer – [A]
Q4. In the formula, which symbol specifies the fixed columns or rows?
a) $
b) *
c) %
d) ;
Answer – [A]
Q5. What is the extension of saved file in MS-Excel?
a) .xls
b) .xks
c) .xos
d) .xbs
Answer – [A]
Q6. How cells are named in MS-Excel?
a) Alphabetically
b) Numerically
c) Alphanumerically
d) Special Characters
Answer – [C]
Q7. How rows are numbered in MS-Excel?
a) Alphabetically
b) Numerically
c) Alphanumerically
d) Special Characters
Answer – [B]
Q8. How columns are named in MS-Excel?
a) Alphabetically
b) Numerically
c) Alphanumerically
d) Special Characters
Answer – [A]
Q9. Which function key is used to open Goto dialog box in MS-Excel?
a) F1
b) F5
c) F7
d) F11
Answer – [B]
Q10. Microsoft Excel was first time launched in ……….. by the Microsoft corporation.
a) 1985
b) 1991
c) 1995
d) 1998
Answer – [A]