MS EXCEL MCQ Quiz - Multiple Choice Questions & Answers

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

1. Ctrl + Space Bar
2. Ctrl + Enter
3. Ctrl + Right Arrow key
4. None of the above

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

1. Data, Sort
2. Data, Form
3. Data, Table
4. None of the above

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

1. Date
2. Text
3. Fraction
4. None of the above

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

1. date ()
2. Today ()
3. now ()
4. time ()

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

1. date ()
2. Today ()
3. now ()
4. time ()

6. Formatting a cell in Currency, you can specify

1. Decimal Places
2. Currency Symbol
3. Percentage symbol
4. None of the above

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

1. Delete contents
2. Delete notes
3. Delete cells
4. Delete formats

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

1. Double
2. Single Accounting
3. Double Accounting
4. Single Engineering

9. Comments can be added to cells using

1. Edit -> Comments
2. Insert -> Comment
3. File -> Comments
4. View –> Comments

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

1. Edit, Chart
2. Insert, Chart
3. Tools, Chart
4. Format, Chart