Microsoft Office – MS Excel Spreadsheet Questions and Answers Set number 1. Mock test are useful for Computer General Knowledge, Interview, Practical Viva and Competitive Exams. Quiz question are bilingual (English and Hindi) for practice.

## Results

-

### #5. What is the correct result of this expression = LEN ("123456")? इस एक्सप्रेशन का सही परिणाम क्या है = LEN("123456")?

Excel expression = LEN (“1 2 3 4 5 6”)

### #6. The value of the Excel expression = SUM (5, 5 , TRUE, FALSE, TRUE, FALSE) is? एक्सेल एक्सप्रेशन = SUM (5, 5, TRUE, FALSE, TRUE, FALSE) का मान है।

Excel expression = SUM (5, 5 , TRUE, FALSE, TRUE, FALSE)

True =1
Therefore, Sum(5,5,1,0,1,0) =12

### #7. What is the correct result of =UPPER(Microsoft)? =UPPER (Microsoft) का सही परिणाम क्या है?

= CEILING (16, 5)

It rounded upto to nearest multiple of 5

i.e 20

### #10. Which of the following functions in MS Excel counts the cells in a range that are not empty? MS Excel में निम्नलिखित में से कौन सा फंक्शन किसी सीमा में उन सेल्स की गिनती करता है जो रिक्त नहीं है?

For more practice Set of MS Excel – click on below buttons

Click on this link for Topic wise CCC practice —> Here

Scroll to Top