excel

 Ms Excel

Ribbon

Home Ribbon

Groups :- 

1. Clipboard ( cut , copy, format painter, paste)
2. Font (font, size, highlighter, border, .)
3. Alignment
1. alignment
2. Wrap text
3. Merge & Center
4. Number ( format)
5. Styles 
1. Conditional formatting
2. format as table
3. cell styles
6. Cell
1. Insert 
2. Delete
3. format
7. Editing
1. Auto sum
2. Fill
3. Clear
4. sort & Filter
5. Find & Select

Insert Ribbon

Group 

1. Table
1. Pivot table
2. table   
2. Illustrations
1. picture
2. Clip Art
3. Shape
4. Smart art
3. Chart
1. Column
2. Line
3. Pie
4. bar
5. Area
6. Scatter  
4. Links
1. Hyperlink
5. Text
1. Text Box
2. Header and Footer
3. Word Art
4. Signature
5. Object
6. Symbol 

Page Layout

1. Themes
2. Page Setup
3. Page Setup
1. Margin
2. orientation
3. Size
4. Area Print
5. Break
6. Background
7. Print Titles
4. Scale to Fit
1. Width
2. Height
3. Scale
5. Sheet Option
1. gridlines
2. Headings
6. Arrange
1. bring front , send back
2. Group, Rotate

formula

1. Formula Library
1. Text
2. Logical
3. Data & Time
4. Financial
5. Look Up 
6. math
2. Define Names
1. Name Manager
3. formula Auditing
1. error Checking 
2. trace Precedents
3. Watch Window
4. calculation
1. Calculate 
2. Calculate Sheet
5.     

data

Data gropu

1. Get External Data
1. From Access
2. From Web
3. From Text
4. From other source
5. Existing Connection
2. Connection
1. Connection
3. Sort & Filter
4. Data tools
1. Text to column
2. Remove Duplicate
3. data validation
4. Consolidate
5. What if analysis
5. Outline
1. Group 
2. ungroup
3. Subtotal

review

Group

1. Proofing
1. Spelling
2. Research
3. Thesaurus
4. Translate
2. Comment
3. Changes
1. Protect Sheet/Workbook
2. Track changes

view

1. Work Book View
1. normal
2. page layout
3. Page Break
4. Custom view
5. Full Screen
2. Show/Hide
1. Ruler
2. Formula
3. Heading
4. gridlines
5. message bar
3. Zoom
4. Windows
1. Arrange all
2. Freeze Pane
3. Switch Window
4. Macro

Detail Explanation

Formula

IS FUNCTIONS

ISBLANK

ISERR

ISERROR

ISEVEN

ISODD

ISFORMULA

ISLOGICAL

ISNA

ISNUMBER

ISREF

ISTEXT

ISNONTEXT

Ms Word - Top 10 MCQ -1

 

1.   निम्न में से कौन सा word processing software है

A) MS Word
B)  Note Pad
C)  Painting
D)  excel

ANSWER=  MS Word
Explain:- 

 

2. अंतिम परिवर्तन को किसके द्वारा नियंत्रित किया जाता है ?

A)Redo
B) Undo
C)) A & B
D) All

ANSWER=  Undo
Explain:-

 

3. इनमें से कौन सा Font type नहीं है

A) Italic
B) Arial
C) Impact
D) Times New Roman

ANSWER= Italic
Explain:-

 

4. यदि किसी text में grammatical error हो तो उस text के नीचे किस color line आती है

A) Red

B) Green
C) Blue
D) All

ANSWER= C)Green
Explain:-

 

5.MS word में कितने प्रकार के Alignment  होते हैं

B) 2
C)3
D)4

ANSWER=D) 4
Explain:-

 

6. Header & Footer को insert करने का Column किस tab में मिलता है?

A) Edit

B)  View
C) Insert
D) Format

ANSWER= (C) Insert
Explain:-

 

7.............. Application आपको personal letter, form letter, brochure Fax और business manual जैसे विभिन्न प्रकार के निम्नलिखित Document तैयार करने में मदद करता है

A) Word Processor
B) Notepad
C) Paint
D) None

ANSWER= (A) Word Processor
Explain:-

 

8. Document को automatic सही करने के लिए हम ..........   का प्रयोग करते हैं

A) Auto Correct
B) Auto Complete
C) Formatting 
D) Building Block

ANSWER= 2) Auto Correct
Explain:-

 

9.  Subscript का उदाहरण है ?

A)  X²
B) X₂
C) X2
D) XX

ANSWER= B) X₂
Explain:-

 

10. बाई(Left) तरफ से किसी अकेले Character को मिटाने के लिए कौन सी Key press करते हैं?

A) Backspace
B) Space
C) Delete
D)  Enter

ANSWER=  A) Backspace
Explain:-

 

11.  Hyperlink inset करवाने की shortcut Key क्या है

A) Ctrl + K

B)   Ctrl + H
C)  Ctrl + E
D)   Ctrl + l

ANSWER=  A) Ctrl + K
Explain:- 

 

12. ....., Same शब्दों की Dictionary है जिसका उपयोग synonyms शब्दों को खोजने के लिए किया जाता है?

A) Thesaurus
B) Research
C)) Translate
D) All

ANSWER=   A) Thesaurus
Explain:-

 

13. Ms word 2010 में कौन से Tab पर click करने पर open Commands आती है?

A) File TAB

B) Office Button
C) View Ribbon
D) None

ANSWER=  A) File TAB
Explain:-

 

14. Document में किसी निश्चित Location पर पहुंचने के लिए कौन से option का use किया जाता है -

A) Bookmarks

B) Cross-Refrence
C) Hyperlink
D) Chat

ANSWER= A) Bookmarks
Explain:-

 

15.MS word वर्ड में फाइल क्या कहलाती है -

A) Document
B) Sheet
C) Slide
D) Pictuer

ANSWER= A) Document
Explain:-

 

16.  एक विषय सूची है जो Document में अपने से संबंधित Reference page के साथ उपस्थित होती हैं?

A) Table of Contents
B) Track Change

C)  Index
D) Insert Citation

ANSWER= (C)  A) Table of Contents
Explain:-

 

7.  MS word  वर्ड में gutter की position को निम्न रूप से manage किया जा सकता है?

A) Left &Top

B) Top & Right
C) Left

D) Bottom

ANSWER= A) Left &Top
Explain:-

 

18. Word wrap क्या अर्थ होता है

A)शब्दों के बीच Space रखना.
B) शब्दों को दाएं मार्जिन से सीधा करता है. 
C)  Text को Automatic अगली लाइन में पहुंचाता है.
D) None

ANSWER= C)  Text को Automatic अगली लाइन में पहुंचाता है.
Explain:-

 

19. .cut, Copy, Paste Keyboard shortcut order

A) Ctrl+X , Ctrl +C. Ctrl +V
B) Ctrl+X , Ctrl +C. Ctrl +P
C)Ctrl+X , Ctrl +P. Ctrl +V
D) None

ANSWER= A) Ctrl+X , Ctrl +C. Ctrl +V
Explain:-

 

20. Which memory is both static and non-volatile ?

A) CACHE
B) ROM
C)BIOS
D)  RAM

ANSWER= B) ROM
Explain:-

 

21.  Blowfish is a type of -

A) Symmetric Encryption Algorithm
B)  Hashing Algorithm
C)  Digital Signature Algorithm
D)  Asymmetric Encryption Algorithm

ANSWER=  Digital Signature Algorithm
Explain:- 

 

22. What does XML stand for?

A)Example Markup Language
B) Extensible Markup Language
C)) X Markup Language
D) Extra Modern Link

ANSWER=  Extensible Markup Language
Explain:-

 

23. Which is not a type of secondary memory?

A) Solid State Drive
B) Hard Disk
C)Random Access Memory (RAM)
D) USB Pen Drive

ANSWER= Random Access Memory (RAM)
Explain:-

 

24. IPv6 protocol defines an IP address of -

A) 32 bit
B)64 bit
C)128 bit
D) 256 bit

ANSWER= C)128 bit
Explain:-

 

25.A social network can be represented as -

A) Graph
B) Tree
C)Star
D)Ring

ANSWER=B) Tree
Explain:-

 

26. Who among the following is known as the father of computing?

A) Charles Babbage
B) Tim Berners Lee
C)Philip Don Estridge
D) ames Gosling

ANSWER= (C) चार्ल्स बैबेज
Explain:-

 

27. Which of the following keyboard shortcuts displays the start menu in the Windows operating system?

A) Ctrl + Z
B) Alt + Spacebar
C)Ctrl + Esc
D) Alt + Enter

ANSWER= (C) Ctrl + Esc
Explain:-

 

28. A system program designed to aid the programmer in finding and correcting errors or bugs is known as -

A) Evaluator
B) Debugger
C) Quarantiner
D) Corrector

ANSWER= 2) Debugger
Explain:-

 

29.  Microsoft Excel is a - ?

A) MS office package
B) Electronic Spreadsheet
C)Graphic package
D) Financial planning package

ANSWER= Electronic Spreadsheet
Explain:-

 

30. Which memory is both static and non-volatile ?

A) CACHE
B) ROM
C)BIOS
D)  RAM

ANSWER= B) ROM
Explain:-

 

31.  Blowfish is a type of -

A) Symmetric Encryption Algorithm
B)  Hashing Algorithm
C)  Digital Signature Algorithm
D)  Asymmetric Encryption Algorithm

ANSWER=  Digital Signature Algorithm
Explain:- 

 

32. What does XML stand for?

A)Example Markup Language
B) Extensible Markup Language
C)) X Markup Language
D) Extra Modern Link

ANSWER=  Extensible Markup Language
Explain:-

 

33. Which is not a type of secondary memory?

A) Solid State Drive
B) Hard Disk
C)Random Access Memory (RAM)
D) USB Pen Drive

ANSWER= Random Access Memory (RAM)
Explain:-

 

34. IPv6 protocol defines an IP address of -

A) 32 bit
B)64 bit
C)128 bit
D) 256 bit

ANSWER= C)128 bit
Explain:-

 

35.A social network can be represented as -

A) Graph
B) Tree
C)Star
D)Ring

ANSWER=B) Tree
Explain:-

 

36. Who among the following is known as the father of computing?

A) Charles Babbage
B) Tim Berners Lee
C)Philip Don Estridge
D) ames Gosling

ANSWER= (C) चार्ल्स बैबेज
Explain:-

 

37. Which of the following keyboard shortcuts displays the start menu in the Windows operating system?

A) Ctrl + Z
B) Alt + Spacebar
C)Ctrl + Esc
D) Alt + Enter

ANSWER= (C) Ctrl + Esc
Explain:-

 

38. A system program designed to aid the programmer in finding and correcting errors or bugs is known as -

A) Evaluator
B) Debugger
C) Quarantiner
D) Corrector

ANSWER= 2) Debugger
Explain:-

 

39.  Microsoft Excel is a - ?

A) MS office package
B) Electronic Spreadsheet
C)Graphic package
D) Financial planning package

ANSWER= Electronic Spreadsheet
Explain:-

 

40. Which memory is both static and non-volatile ?

A) CACHE
B) ROM
C)BIOS
D)  RAM

ANSWER= B) ROM
Explain:-

 

41.  Blowfish is a type of -

A) Symmetric Encryption Algorithm
B)  Hashing Algorithm
C)  Digital Signature Algorithm
D)  Asymmetric Encryption Algorithm

ANSWER=  Digital Signature Algorithm
Explain:- 

 

42. What does XML stand for?

A)Example Markup Language
B) Extensible Markup Language
C)) X Markup Language
D) Extra Modern Link

ANSWER=  Extensible Markup Language
Explain:-

 

43. Which is not a type of secondary memory?

A) Solid State Drive
B) Hard Disk
C)Random Access Memory (RAM)
D) USB Pen Drive

ANSWER= Random Access Memory (RAM)
Explain:-

 

44. IPv6 protocol defines an IP address of -

A) 32 bit
B)64 bit
C)128 bit
D) 256 bit

ANSWER= C)128 bit
Explain:-

 

45.A social network can be represented as -

A) Graph
B) Tree
C)Star
D)Ring

ANSWER=B) Tree
Explain:-

 

46. Who among the following is known as the father of computing?

A) Charles Babbage
B) Tim Berners Lee
C)Philip Don Estridge
D) ames Gosling

ANSWER= (C) चार्ल्स बैबेज
Explain:-

 

47. Which of the following keyboard shortcuts displays the start menu in the Windows operating system?

A) Ctrl + Z
B) Alt + Spacebar
C)Ctrl + Esc
D) Alt + Enter

ANSWER= (C) Ctrl + Esc
Explain:-

 

48. A system program designed to aid the programmer in finding and correcting errors or bugs is known as -

A) Evaluator
B) Debugger
C) Quarantiner
D) Corrector

ANSWER= 2) Debugger
Explain:-

 

49.  Microsoft Excel is a - ?

A) MS office package
B) Electronic Spreadsheet
C)Graphic package
D) Financial planning package

ANSWER= Electronic Spreadsheet
Explain:-

 

50. Which memory is both static and non-volatile ?

A) CACHE
B) ROM
C)BIOS
D)  RAM

ANSWER= B) ROM
Explain:-