Computer Science (New) - For Class IX - UNIT. 3 - Office Automation - MCQs, Fill In The Blanks, Abbreviations, Hot Keys And Short Keys
Computer Science (New) - For Class IX - UNIT. 3 - Office Automation - MCQs, Fill In The Blanks, Abbreviations, Hot Keys And Short Keys
GO TO INDEX
Chapter No.3 - Office Automation
MCQs, Fill In The Blanks
Abbreviations, Hot and Short Keys.
Multiple Choice Questions (MCQs)
7. The correct formula to calculate the total in the given table is:
S.NO. | A | B | C | D | E | F |
---|---|---|---|---|---|---|
1 | NAME | English | Sindhi/ Urdu | Maths | Science | Total |
2 | Ghulam Shabir | 40 | 41 | 41 | 40 | |
3 | Riaz Hussain | 41 | 39 | 34 | 38 | |
4 | Nabil Ahmed | 41 | 35 | 32 | 40 | |
5 | Anwar Ali | 40 | 38 | 33 | 37 |
b) = B2 + E2
c) = sum (B2 to E2)✓
d) = sum (B2 from E2)
8. The correct formula to calculate the percentage in the given table is:
S.NO. | A | B | C | D | E | F |
---|---|---|---|---|---|---|
1 | NAME | English | Sindhi/ Urdu | Maths | Science | Total |
2 | Ghulam Shabir | 40 | 41 | 41 | 40 | |
3 | Riaz Hussain | 41 | 39 | 34 | 38 | |
4 | Nabil Ahmed | 41 | 35 | 32 | 40 | |
5 | Anwar Ali | 40 | 38 | 33 | 37 |
b) = B2 + C2 + D2+ E2 * 100
c) = (B2 + C2 + D2+ E2) / 400 * 100 ✓
d) = (B2 + C2 + D2+ E2) / 100 * 400
9. Charts are basically used to
a) design tables
b) organize data in tables
c) Sort data in different columns
d) show the quantities and their relationships graphically ✓
10. To apply the table of contents automatically, the most important task is to properly define the
a) levels of heading ✓
b) page numbering
c) page layout
d) themes
11. _______ is one of the most famous word-processing software.
a) MS Word ✓
b) MS Excel
c) MS Power point
d) MS Access
12. _________ was first released and made public in early 1980s by Microsoft.
a) MS Word ✓
b) MS Excel
c) MS Power point
d) MS Access
13. _______ First introduced the concept of WYSIWYG
a) MS Word ✓
b) MS Excel
c) MS Power point
d) MS Access
14. The _____ Tab allows user to control the look and feel of his or her document.
a) Page layout ✓
b) Theme
c) Page setup
d) Page Background
15. The Page Layout tab has _____ groups of related commands.
a) 2
b) 3
c) 4
d) 5 ✓
16. Page Setup settings help us set the page layout properties such as margins, orientation and size.
a) Page layout
b) Theme
c) Page setup ✓
d) Page Background
17. A ______ is the area or space between the main content of a page and the page edges.
a) Margin ✓
b) Size
c) Column
d) Hyphenation
18. Page or print ________ is the placement of contents on a page.
a) Setup
b) Column
c) Orientation ✓
d) Layout
19. The ______ button is used to choose the size of the paper for current section or entire document.
a) Margin
b) Size ✓
c) Column
d) Hyphenation
20. This button sets the contents of the page or section in portrait (Vertical) or landscape (Horizontal) layouts.
a) Size
b) Orientation ✓
c) Column
d) Layout
21. This button is used to split the text into two or more vertical columns.
a) Size
b) Column ✓
c) Orientation
d) Margin
22. These settings are used mostly for special documents such as certificates, invitations, brochures, essays, etc.
a) Page layout
b) Paragraph
c) Page setup
d) Page Background ✓
23. This button is used to insert logos, images or text behind the contents of a page.
a) Watermark ✓
b) Page Color
c) Page Border
d) None of these
24. This group allows us to set a few basic paragraph styles and also adjust the indents and spacing.
a) Arrange
b) Paragraph ✓
c) Page Setup
d) Page Background
25. Group button is used to combine two or more objects together so that they can be treated as a single object.
a) Orientation
b) Align
c) Group ✓
d) wrap text
Fill In The blanks
1. MS Word is widely used word processing software in the world.2. A Theme is a predefined set of formatting, colors and settings that changes the overall design and look of the entire document.
2. Breaks button is used to insert page, section or column breaks in the document.
3. Line numbers button is used to add line numbers on the left side of each line of the document.
4. Page Background Group consists of 3 buttons namely, Watermark, Page Color and Page Borders.
5. A watermark is a faded background image that displays behind the text in a document.
6. Page Color is used when user wants to apply a color for the background of the page.
7. Page Border button is used to put a border around the page.
8. Indent button is used to define amount of blank space (in centimeters).
9. Indent Left button used to separate a paragraph from left margin.
10. Indent Right button is to separate a paragraph from right margin.
11. Space Before button is used to indicate how much space (in points) is added before the selected paragraph.
12. Space After button is used to indicate how much space (in points) is added after the selected paragraph.
13. The buttons in Arrange Group help the users to quickly arrange graphical and other elements of the document in relation to the main textual content.
14. Position button is used to place an object (picture or shape) on the page wherever want.
15. Text wrapping button is used to arrange the text around an object like an image.
16. Bring Forward button brings a selected object in front of all other objects.
17. Send Backward button sends a selected object behind all other objects.
18. Selection Pane button is used to select, show, hide and change the order of objects in the document.
19. Align button is used to place objects in alignment with margins, edge, or relative to another object in the document.
20. Rotate button is used to rotate or flip the selected object.
21. Table of Contents provides an overview of the document.
22. Table of Contents allow readers to go directly to specific section or content in the document.
23. ToC usually appears after the Title Page in a document.
24. Manual Table creates a template of a generic table of contents.
25. Microsoft Excel is a software that uses spreadsheet system to organize and calculate data.
26. Formulas help user to perform different types of calculation easily.
27. MS Excel 2010 allows its user to perform numerous calculations on its data
28. Charts are also known as graphs.
Abbreviation
- MS: Microsoft
- ToC: Table of Contents
- WYSIWYG: What You See Is What You Get
Hot Keys (MS WORD)
- Align: ALT+P+A+A
- Breaks: ALT+P+B
- Bring Forward: ALT+P+A+F
- Columns: ALT+P+J
- Group: ALT+P+A+G
- Hyphenation: ALT+P+H
- Indent Left: ALT+P+I+L
- Indent Right: ALT+P+I+R
- Line Numbers: ALT+P+L+N
- Margins: ALT+P+M
- Orientation: ALT+P+O
- Page Color: ALT+P+P+C
- Page Border: ALT+P+P+B
- Position: ALT+P+P+O
- Rotate: ALT+P+A+Y
- Space Before: ALT+P+S+B
- Space After: ALT+P+S+A
- Selection Pane: ALT+P+A+P
- Send Backward: ALT+P+A+E
- Size: ALT+P+S+Z
- Watermark: ALT+P+P+W
- Wrap Text: ALT+P+T+W
Comments
Post a Comment
If you have any doubts, Please let me know .