MS Excel MCQ Questions and Answers – Part 1

MS Excel MCQ questions and answers for the preparation of tests, exams, and certifications. So you will find questions about the Workbook, Menu bar, Toolbar, Column headings, Row headings, Name box, Formula bar, and much more. This systematic learning method will easily prepare anyone to pass their exam.
 

 

1. Comments can be added to cells using ______

A Right click on the mouse then “Add a comment”.

B Right click on the mouse then “Insert a comment”.

C File -> Comments

D View -> Comments

Answer  

2. Getting data from a cell in another sheet is called ______

A Access

B Referencing

C Update

D Operation

Answer  

3. Which of the following is not a valid data type in Excel?

A Number

B Character

C Label

D Date/Time

Answer  
 

4. Which elements of a worksheet can be protected against accidental changes?

A Content

B Objects

C Scenarios

D All the answers are true

Answer  

5. A numeric value can be considered as a label value if it is preceded by _______.

A Apostrophe (‘)

B Exclamation (!)

C Sharp (#)

D Tilde (~)

Answer  

6. Text concatenation can be done using _______.

A Apostrophe (‘)

B Exclamation (!)

C Sharp (#)

D Ampersand (&)

Answer  
 

7. Which field in Excel is used to enter values and formulas?

A Title bar

B Menu bar

C Formula bar

D Standard toolbar

Answer  

8. Multiple calculations can be done in a single formula using _______

A Standard formulas

B Table formula

C Complex formulas

D Smart formula

Answer  

9. An Excel workbook is a collection of ______

A Notebooks

B Worksheet

C Charts

D Worksheet and Charts

Answer  
 

10. MS-EXCEL is based on _____?

A WINDOWS

B DOS

C UNIX

D OS/2

Answer  
MCQPractice competitive and technical Multiple Choice Questions and Answers (MCQs) with simple and logical explanations to prepare for tests and interviews.Read More