Microsoft Excel MCQs

Microsoft Excel MCQs contain set of 10 Microsoft Excel MCQ questions with answers which will help you to clear beginner level quiz.



1. Which area in an Excel window allows entering values and formulas?

• 1. Formula Bar
  2. Menu Bar
  3. Title Bar
  4. Standard Tool Bar

 
2. Multiple calculations can be made in a single formula using…..

• 1. Smart Formula
  2. Standard Formulas
  3. Complex Formulas
  4. Array Formula

 
3. Getting data from a cell located in a different sheet is called….

• 1. Updating
  2. Referencing
  3. Accessing
  4. Functioning

 
4. Concatenation of text can be done using

• 1. Apostrophe (‘)
  2. Exclamation (!)
  3. Ampersand (&)
  4. Hash (#)

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

• 1. Label
  2. Character
  3. Number
  4. Date/Time

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

• 1. Apostrophe (‘)
  2. Hash (#)
  3. Exclamation (!)
  4. Tilde (~)

7. Which elements of a worksheet can be protected from accidental modification?

• 1. Objects
  2. Contents
  3. Scenarios
  4. All of the above

8. Comments put in cells are called …..

• 1. Smart Tip
  2. Cell Tip
  3. Web Tip
  4. Soft Tip

 
9. Multiple calculations can be made in a single formula using…..

• 1. Array Formula
  2. Complex Formulas
  3. Smart Formula
  4. Standard Formulas

 
10. What does the LEN() function do?

• 1. Splits the Cell contents
  2. Counts the number of characters in a cell
  3. All of the choices
  4. Deletes Trailing spaces

 
11.  What is the purpose of the Add-In Manager?

• 1. To allow administrative control over all projects on the system
  2. To allow insertion or deletion of data over the internet
  3. To create and manage additional protocols and data types for use in custom forms
  4. To add or remove templates, macros and wizards