Page 1 :
12, , SNO, , NAME OF THE TEACHER, , KV, , TOPIC ALLOTTED, , 4, , Mr R VIJAY KUMAR, , MACHILIPATNAM, , Digital Documentation, (Advanced), , MULTIPLE CHOICE QUESTIONS, 1, Which of the following is true about styles?, a) A style is a set of formats that you can apply to selected pages, text, frames, and other, elements in your document to quickly change their appearance., b) Styles are logical attributes., c) Styles help improve consistency in a document., d) All of the above, Ans) d, 2, Read statements 1 and 2 and select appropriate option?, Statement 1: A new style can be created from selection, Statement 2: A new style can be created using drag and drop, a) Both statements 1 and 2 are True, b) Statement 1 is True but Statement 2 is False, c) Statement 1 is False but Statement 2 is True, d) Both statements 1 and 2 are False, Ans) a, 3, We can add an image to a document using, a) Drag and drop, b) Insert > Picture > From File, c) Both of the above, d) None of the above, Ans) c, , from the menu bar

Page 2 :
13, , 4, The Graphics filter Posterize:, , a), , Joins groups of pixels into a single area of one colour, , b), , Makes a picture appear like a painting by reducing the number of colours used, , c), , Simulates the effects of time on a picture, , d), , Increases the contrast of an image, , Ans) b, 5, The __________ option in picture tool bar is particularly useful when creating a watermark, or when wrapping the image in the background, a) Transparency, b) Filter, c) Color, d) None of the above, Ans) a, 6, _____________ refers to the relation of graphics to the surrounding text., a) Arrangement, b) Anchoring, c) Text wrapping, d) Alignment, Ans) c, 7, Which of the following statements is True about Templates?, Statement 1: A template is a model that you use to create other documents, Statement 2: Templates cannot contain things that regular documents can contain, such, as text, graphics, a set of styles etc.,, a) Both statements 1 and 2 are True

Page 3 :
14, , b) Statement 1 is True but Statement 2 is False, c) Statement 1 is False but Statement 2 is True, d) Both statements 1 and 2 are False, Ans) b, 8, While creating table of contents through insert index/table dialog box , which tab is, available out of the following give tabs, a) Entries tab, b) Styles tab, c) Background tab, d) All the above tabs, Ans) d, 9, , _________ is a feature in word processing software that help users to create personalized, letters, greeting cards with different names and addresses stored in a database., a) Table of contents, b) Templates, c) Mail Merge, d) None of the above, Ans) c, , 10, , What is the shortcut to see non – printing characters in Writer?, a) Ctrl + F11, b) Ctrl + F12, c) Ctrl + F1, d) Ctrl + F10, Ans) d, , CASE STUDY QUESTIONS (R), 1, , Mr. Vamsi as part of his project work created a document in open office writer with some, ten pages of text. For proper explanation of the content he wants to add images at, different locations in the document. Help him to complete the following tasks., , a), , Mr. Vamsi wants to add an image as water mark to his document. Which feature from, picture tool bar he can use for this purpose?, Ans) Graphics mode option can be set as watermark, (or), Transparency can be increased with appropriate text wrapping

Page 4 :
15, , b), , Which graphic filter option he should use on the image to group pixels into a single area of, one colour?, Ans) Mosaic, , c), , Which option from the crop tab he should choose if he does not want to change the scale, of the picture?, Ans) Keep scale, , d), , Which option he can use from the picture dialog box so that he can conveniently align text, with image as per his requirement?, Ans) Wrap, , e), , While resizing the image if he wants to control only one dimension at a time which handle, he can use? corner handle or non corner handle?, Ans) Non corner handle, , 2, , Ms. Priya has 40 pages of text prepared by her on a specific topic in open office, writer with proper use of headings where ever required. Now she wants to create an, index for the pages she created so that all the topics and sub topics are clearly, visible with page numbers for easy access. Help her to complete the following tasks, ., , a), , Name the feature in open office writer that she can use to create a table of contents, Ans) Indexes and Tables, , b), , If she’d like to have title for table of contents then where she can find the option to add, title?, Ans) Title field under Index/Table tab, , c), , Which tab under insert index/table allows her to add and delete elements for each outline, level?, Ans) Entries, , d), , She can use Background tab under insert index/table - to select a graphic as, background True or False?, Ans) True, , e), , Which tab under insert index/table allows her to apply paragraph styles to the table of, contents?, Ans) Styles

Page 5 :
16, , SNO, , NAME OF THE TEACHER, , KV, , TOPIC ALLOTTED, , 5, , Mr RAVI KUMAR TEWARI, , INS KALINGA, , Electronic Spreadsheet (Advanced), , MULTIPLE CHOICE QUESTIONS, 1, , Computer spreadsheet cell that is highlighted with heavy border is :, , a., b., c., d., , Active cell, Passive cell, Locked cell, Formatted cell, , Ans a. Active cell, 2, , Rohan selected the 4th row and 3rd column in a spreadsheet. Then what is the cell, address?, a.3C, b.C3, c.4C, d.C4, Ans d.C4, , 3, , Data available in other sheets in a workbook , can be consolidate by :, a.Row label, b.Column Label, c. Both a & b, d.None of the mentioned, Ans: c. Both a & b, , 4, , Macros must be saved with extension in MS Excel:, a., .xls, b., .xlsm, c., .vba, d., .xlsx, Ans b. .xlsm, , 5, , Which programming language does VBA is based on :, a., Visual Basic, b., Visual studio, c., Visual Base, d., Visual .Net, Ans a. Visual Basic