MS EXCEL MCQ Multiple Choice Questions Answers

Q: 1. What is the short cut key to highlight the entire column ?

Correct Answer is: None of the above

Q: 2. How do you rearrange the data in ascending or descending order ?

Correct Answer is: None of the above

Q: 3. If 4/6 entered in a cell without applying any formats, Excel will treat this as

Correct Answer is: None of the above

Q: 6. Formatting a cell in Currency, you can specify

Correct Answer is: None of the above

Q: 7. Which is not the function of “Edit, Clear” command?

Correct Answer is: Delete formats

Q: 8. Which of the following is not an underline option in the format cells dialog box?

Correct Answer is: Double Accounting

Q: 9. Comments can be added to cells using

Correct Answer is: View â€“> Comments

Q: 10. Which would you choose to create a bar diagram?

Correct Answer is: Format, Chart

Q: 11. Which of the following options is appropriate to show the numbers 9779851089510 in a cell?

Correct Answer is: Place the character TX before the number

Q: 12. Which of the following shortcuts can be used to insert a new line in the same cell?

Correct Answer is: Shift + Enter

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?

MS EXCEL MCQ Questions for Practice

1. What is the short cut key to highlight the entire column ?

Ctrl + Space Bar
Ctrl + Enter
Ctrl + Right Arrow key
None of the above

2. How do you rearrange the data in ascending or descending order ?

Data, Sort
Data, Form
Data, Table
None of the above

3. If 4/6 entered in a cell without applying any formats, Excel will treat this as

Date
Text
Fraction
None of the above

4. How do you display current date and time in MS Excel?

date ()
Today ()
now ()
time ()

5. How do you display current date only in MS Excel?

date ()
Today ()
now ()
time ()

6. Formatting a cell in Currency, you can specify

Decimal Places
Currency Symbol
Percentage symbol
None of the above

7. Which is not the function of “Edit, Clear” command?

Delete contents
Delete notes
Delete cells
Delete formats

8. Which of the following is not an underline option in the format cells dialog box?

Double
Single Accounting
Double Accounting
Single Engineering

9. Comments can be added to cells using

Edit -> Comments
Insert -> Comment
File -> Comments
View â€“> Comments

10. Which would you choose to create a bar diagram?

Edit, Chart
Insert, Chart
Tools, Chart
Format, Chart

11. Which of the following options is appropriate to show the numbers 9779851089510 in a cell?

Enclose the number is brackets
Place the character T before the number
Place the character TX before the number
Apply the Text format in the cell and type the numbers

12. Which of the following shortcuts can be used to insert a new line in the same cell?

Enter
Alt + Enter
Ctrl + Enter
Shift + Enter

13. An Excel file is generally called a / an :

E-Spreadsheet
Woorksheet
Workbook
Sheet

14. Which of the following is the oldest spreadsheet package ?

Excel
StarCalc
VisiCalc
None of the above

15. Which key do you press to check spelling?

16. What is the keyboard shortcut for creating a chart from the selected cell range ?

17. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts ?

Financial
Statistical
Logical
None of the above

18. MS-EXCEL can be used to automate

Financial statements, Business forecasting
Transaction registers, inventory control
Accounts receivable, accounts payable
Any of the above

19. Which of the following format you can decide to apply or not in AutoFormat dialog box ?

Font format
Number format
Border format
All of the above

20. Which menu option can be used to split windows into two?

Format -> Window
View -> Window-> Split
Window -> Split
View â€“> Split

21. How do you wrap the text in a cell?

Format, cells, font
Format, cells, protection
format, cells, number
Format, cells, alignment

22. Which of the following you can paste selectively using Paste Special command ?

Formats
Validation
Formulas
All of the above

23. You can check the conditions against …………………………….when applying conditional formatting

Formula
Cell value
Both (A) and (B)
None of the above

24. A features that displays only the data in column (s) according to specified criteria

Formula
Sorting
Filtering
Pivot

25. What do you mean by a Workspace?

Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks

26. Which of the following function will use to find the highest number in a series of number ?

HIGH (B1:B3)
MAXIMUM (B1:B3)
MAX(B1:B3)
None of the above

27. How to restrict to run a macro automatically when starting Microsoft Excel?

Hold down the SHIFT key during startup
Hold down the CTRL key during startup
Hold down the ESC key during startup
Hold down the ALT key during startup

28. Which of the following is not an option of the spelling dialog box?

Ignore
Ignore all
Edit
Change

29. The spelling dialog box can be involved by choosing spelling from ……………………...menu.

insert
file
tools
view

30. You accidentally erased a record in the sheet. What command can be used to restore it immediately?

Insert
Copy
Undo
Replace

MS EXCEL MCQ Multiple Choice Questions Answers | Quiz for Practice

About MS EXCEL MCQ Questions

Why Practice MS EXCEL Objective Questions?

Who Should Use These MCQs?

MS EXCEL MCQ Questions for Practice

1. What is the short cut key to highlight the entire column ?

2. How do you rearrange the data in ascending or descending order ?

3. If 4/6 entered in a cell without applying any formats, Excel will treat this as

4. How do you display current date and time in MS Excel?

5. How do you display current date only in MS Excel?

6. Formatting a cell in Currency, you can specify

7. Which is not the function of “Edit, Clear” command?

8. Which of the following is not an underline option in the format cells dialog box?

9. Comments can be added to cells using

10. Which would you choose to create a bar diagram?

11. Which of the following options is appropriate to show the numbers 9779851089510 in a cell?

12. Which of the following shortcuts can be used to insert a new line in the same cell?

13. An Excel file is generally called a / an :

14. Which of the following is the oldest spreadsheet package ?

15. Which key do you press to check spelling?

16. What is the keyboard shortcut for creating a chart from the selected cell range ?

17. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts ?

18. MS-EXCEL can be used to automate

19. Which of the following format you can decide to apply or not in AutoFormat dialog box ?

20. Which menu option can be used to split windows into two?

21. How do you wrap the text in a cell?

22. Which of the following you can paste selectively using Paste Special command ?

23. You can check the conditions against …………………………….when applying conditional formatting

24. A features that displays only the data in column (s) according to specified criteria

25. What do you mean by a Workspace?

26. Which of the following function will use to find the highest number in a series of number ?

27. How to restrict to run a macro automatically when starting Microsoft Excel?

28. Which of the following is not an option of the spelling dialog box?

29. The spelling dialog box can be involved by choosing spelling from ……………………...menu.

30. You accidentally erased a record in the sheet. What command can be used to restore it immediately?

Your Score

Related Quiz Topics

Recent Articles

Looking to post on our portal?

MS EXCEL MCQ Multiple Choice Questions Answers | Quiz for Practice

About MS EXCEL MCQ Questions

Why Practice MS EXCEL Objective Questions?

Who Should Use These MCQs?

MS EXCEL MCQ Questions for Practice

1. What is the short cut key to highlight the entire column ?

2. How do you rearrange the data in ascending or descending order ?

3. If 4/6 entered in a cell without applying any formats, Excel will treat this as

4. How do you display current date and time in MS Excel?

5. How do you display current date only in MS Excel?

6. Formatting a cell in Currency, you can specify

7. Which is not the function of “Edit, Clear” command?

8. Which of the following is not an underline option in the format cells dialog box?

9. Comments can be added to cells using

10. Which would you choose to create a bar diagram?

11. Which of the following options is appropriate to show the numbers 9779851089510 in a cell?

12. Which of the following shortcuts can be used to insert a new line in the same cell?

13. An Excel file is generally called a / an :

14. Which of the following is the oldest spreadsheet package ?

15. Which key do you press to check spelling?

16. What is the keyboard shortcut for creating a chart from the selected cell range ?

17. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts ?

18. MS-EXCEL can be used to automate

19. Which of the following format you can decide to apply or not in AutoFormat dialog box ?

20. Which menu option can be used to split windows into two?

21. How do you wrap the text in a cell?

22. Which of the following you can paste selectively using Paste Special command ?

23. You can check the conditions against …………………………….when applying conditional formatting

24. A features that displays only the data in column (s) according to specified criteria

25. What do you mean by a Workspace?

26. Which of the following function will use to find the highest number in a series of number ?

27. How to restrict to run a macro automatically when starting Microsoft Excel?

28. Which of the following is not an option of the spelling dialog box?

29. The spelling dialog box can be involved by choosing spelling from ……………………...menu.

30. You accidentally erased a record in the sheet. What command can be used to restore it immediately?

Your Score

Related Quiz Topics

Recent Articles

Login at Quizforum