Q1. Comments put in cells are called …..
A. Smart Tip
B. Cell Tip
C. Web Tip
D. Soft Tip

Q2. Comments can be added to cells using …..
A. Edit -> Comments
B. Insert -> Comment
C. File -> Comments
D. View –> Comments

Q3. Which menu option can be used to split windows into two?
A. Format -> Window
B. View -> Window-> Split
C. Window -> Split
D. View –> Split

Q4. Getting data from a cell located in a different sheet is called….
A. Accessing
B. Referencing
C. Updating
D. Functioning

Q5. Which of the following is not a valid data type in Excel?
A. Number
B. Character
C. Label
D. Date/Time

Q6. Which elements of a worksheet can be protected from accidental modification?
A. Contents
B. Objects
C. Scenarios
D. All of the above

Q7. A numeric value can be treated as label value if …… precedes it.
A. Apostrophe (‘)
B. Exclamation (!)
C. Hash (#)
D. Tilde (~)

Q8. Concatenation of text can be done using
A. Apostrophe (‘)
B. Exclamation (!)
C. Hash (#)
D. Ampersand (&)

Q9. Which area in an Excel window allows entering values and formulas?
A. Title Bar
B. Menu Bar
C. Formula Bar
D. Standard Tool Bar

Q10. . Multiple calculations can be made in a single formula using…..
A. Standard Formulas
B. Array Formula
C. Complex Formulas
D. Smart Formula

Q11. An Excel Workbook is a collection of …….
A. Workbooks
B. Worksheets
C. Charts
D. Worksheets and Charts

Q12. What do you mean by a Workspace?
A. Group of Columns
B. Group of Worksheets
C. Group of Rows
D. Group of Workbooks

Q13. MS-EXCEL is based on ……….?
D. OS/2

Q14. In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?
A. AutoFill
B. Auto correct
C. Auto sum
D. Auto format

Q15. To select an entire column in MS-EXCEL, press?
B. CTRL + Arrow key
D. None of the above

Important  Instructions

While submitting answers below in the " Message " Section MAKE SURE you type Question Number and Answer (For Example : 1. A , 2. B , 3.C ) and also mention the part number(For example: part 1, or part 2, or part 3 ) of the questions you are answering.

We will mail you your result in 10 seconds.Mention Course Name as Subject

Your Name (required)

Your Email (required)

Your Number (required)


Your Message