Excel MCQs Set-1

 

Multiple choice question of Microsoft Excel

1-1. Comments put in cells are called …..

A. Smart Tip
B. Cell Tip
C. Web Tip
D. Soft Tip

1-2. Comments can be added to cells using …..

A. Edit -> Comments
B. Insert -> Comment   
C. File -> Comments
D. View –> Comments

1-3. Which menu option can be used to split windows into two?

A. Format -> Window
B. View -> Window-> Split
C. Window -> Split
D. View –> Split

1-4. Getting data from a cell located in a different sheet is called….

A. Accessing
B. Referencing
C. Updating
D. Functioning

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

A. Number
B. Character
C. Label
D. Date/Time

1-6. Which elements of a worksheet can be protected from accidental modification?

A. Contents
B. Objects
C. Scenarios
D. All of the above

1-7. A numeric value can be treated as label value if …… precedes it.

A. Apostrophe (‘)
B. Exclamation (!)
C. Hash (#)
D. Tilde (~)

1-8. Concatenation of text can be done using

A. Apostrophe (‘)
B. Exclamation (!)
C. Hash (#)
D. Ampersand (&)

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

A. Title Bar
B. Menu Bar
C. Formula Bar
D. Standard Tool Bar

1-10. Multiple calculations can be made in a single formula using…..

A. Standard Formulas
B. Array Formula
C. Complex Formulas
D. Smart Formula

---

Answers: 1 – B / 2 – B / 3 – C / 4 – B / 5 – B / 6 – D / 7 – A / 8 – D / 9 – C / 10 – B