Correct Answer is: Appears to the left of the formula bar

MS EXCEL MCQ Multiple Choice Questions Answers for Practice

Q: 2. How many worksheets can a workbook have?

Correct Answer is: none of above

Q: 14. Selecting the Column G & H then choose Insert->Columns. What will happen?

Correct Answer is: 2 Columns will be inserted after Column F

Q: 16. In Excel, a Data Series is defined as what ?

Correct Answer is: A collection of related data

Q: 17. In Excel, Columns are labelled as

Correct Answer is: A, B, C, etc

1. How many sheets are there, by default, when we create a new Excel file ?

2. How many worksheets can a workbook have?

3
8
255
none of above

3. What value will display if the formula = “$55.00″+5 is entered into a cell?

60
60
“$55.00″+5
$60.00

4. What will be the output if you format the cell containing 5436.8 as ‘#,##0.00’?

5430.00
5436.80
5436.80
6.8

5. The cell reference for cell range of G2 to M12 is

G2.M12
G2;M12
G2:M12
G2-M12

6. Formulas in Excel start with

7. In the formula, which symbol specifies the fixed columns or rows ?

&
%
$
All of the above

8. What is the symbol for multiplying?

9. How to specify cell range from A9 to A99 in Excel?

(A9, A99)
(A9 to A99)
(A9 : A99)
(A9 – A99)

10. What is the symbol for dividing?

11. What should be add before a fraction to avoid entering it as a date ?

//
Zero
Space
None of the above

12. Which of the following is correct ?

=POWER(2*3)
=POWER(2^3)
8
None of the above

13. Give me an example of a cell address.

11 25
911
41A
A21

14. Selecting the Column G & H then choose Insert->Columns. What will happen?

2 Columns will be inserted after Column F
2 Columns will be inserted after Column G
2 Columns will be inserted after Column H
2 Columns will be inserted after Column I

15. Where a row and a column meet, what do you call that?

A cell
A block
A box
None of the above

16. In Excel, a Data Series is defined as what ?

A collection of related data
A type of chart
A cell reference
None of the above

17. In Excel, Columns are labelled as

A, B, C, etc
1,2,3 etc
A1, A2, etc
$A$1, $A$2, etc.

18. In Excel, Rows are labelled as

A, B, C, etc
1,2,3 etc
A1, A2, etc
$A$1, $A$2, etc.

19. The cell reference for cell range of A2 to M12 is

A2!M12
A2.M12
A2;M12
A2:M12

20. The first cell in EXCEL worksheet is labeled as

21. Statistical calculations and preparation of tables and graphs can be done using

Adobe Photoshop
Excel
Notepad
Power Point

22. What is the shortcut key to insert new sheet in current workbook ?

Alt + F11
Ctrl + F11
Shift + F11
None of the above

23. What is the shortcut key to insert a new comment in a cell ?

Alt + F2
Ctrl + F2
Shift + F2
None of the above

24. Functions in MS Excel must begin with

An () sign
An Equal Sign
A Plus Sign
A > Sign

25. What happens when dollar signs ($) are entered in a cell address? (ex. $B$2:$B$10)

An absolute cell address is created.
Cell address will change when it is copied to another cell.
The sheet tab is changed.
The status bar does not display the cell address.

26. A numeric value can be treated as label value if …… precedes it.

Apostrophe (')
Exclamation (!)
Hash (#)
Tilde (~)

27. Concatenation of text can be done using

Apostrophe (')
Exclamation (!)
Hash (#)
Ampersand (&)

28. The name box

Appears below the status bar
Appears to the left of the formula bar
Shows the location of the previously active cell
None of the above

29. Which Chart can be created in Excel?

Area
Line
Pie
All of the above

30. The Greater Than sign is an example of …………………….. operator.

Arithmatic
Logical
Conditional
Greater

Mastering MS Excel through multiple-choice questions (MCQs) is essential for students and exam aspirants. These quizzes help reinforce key concepts and improve your proficiency in Excel, making you better prepared for exams and real-world applications.

About MS EXCEL MCQ Questions

MS Excel MCQs cover a wide range of topics, from basic functions like SUM and AVERAGE to advanced features such as pivot tables and macros. These questions are designed to test your understanding of Excel's core functionalities, data manipulation techniques, and problem-solving skills. Practicing these MCQs will enhance your ability to work efficiently with spreadsheets.

Why Practice MS EXCEL Objective Questions?

Practicing MS Excel objective questions offers several benefits. It helps you prepare for school and college exams, competitive tests, and job interviews. Regular practice improves your speed and accuracy, builds your confidence, and ensures you are well-versed in the practical applications of Excel. Whether you are a beginner or an advanced user, these MCQs are a valuable resource for honing your skills.

Who Should Use These MCQs?

Students preparing for school or college exams
Competitive exam aspirants
Candidates preparing for interviews