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

a) = B2 + C2 + D2+ E2
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

a) = B2 + C2 + D2+ E2 / 400 * 100
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