Microsoft Exel mcq Microsoft Exel mcq and answers


Q1. The tab of the active sheet in a workbook is always………. .

a. bold 
b. italics
c. underlined
d. simple

 

 

Q2. The worksheet names appear on tabs at the ……… of the workbook window.

a. top
b. bottom 
c. center
d. left

 

 


Q3. In a spreadsheet, a ……… is a number you will use in a calculation.

a. label
b. cell
c. field
d. value 

 

 


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

a. Number
b. Text
c. Character 
d. Date/Time

 

 


Q5. A numeric value can be treated as a label value if it precedes with

a. Apostrophe (’) 
b. Exclamation (!)
c. Hash (#)
d. Tilde (~)

 

 


Q6. Which of the following is not an example of a value?

a. 350
b. May 2, 2013
c. 64%
d. Serial no. 50771

 

 


Q7. In Excel, the contents of the active cell are displayed in the

a. footer bar
b. toolbar
c. task bar
d. formula bar 

 

IBPS Clerk 2011; SBI Clerk 2009

 

 


Q8. When you enter text in a cell in Excel, it also appears in the

a. status bar
b. formula bar 
c. row heading
d. name box

 

IBPS Clerk 2011

 

 


Q9. In MS-Excel Book1 is an example of, how ……… is numbered and named during each work session.

a. active cell
b. formula bar
c. menu bar
d. name box 

 

 


Q10. ……… appear at the bottom of the Excel Window.

a. Work sheet tabs 
b. Name box
c. Formula bar
d. Title bar

 

IBPS Clerk 2011

 

 


 

1       2       3       4        5      6       7       8     

 


Next Page

 

DEAR READERS IF YOU FIND ANY ERROR/TYPING MISTAKE PLEASE LET ME KNOW IN THE COMMENT SECTION OR E-MAIL: [email protected]