i want all exercise answer sheet of computer 2nd te

i want all exercise  answer sheet of computer 2nd term

Sample Qory units in ascending order of their storage capacities. Kilo Byte, Byte, Tera Byte, Mega Byte 2. Why is Secondary Storage needed in a Computer? Explain briefly. 3, Text 1 shows part of a article handwritten by an author on “Eating Breakfast”. For those who always skip breakfast, you should stop that habit now! You’ve heard many times that “Breakfast is the most important meal of the day.” Now, recent research confirms that one of the worst practices you can develop may be avoiding breakfast. Text 2 shows the same text after Ms. Jacob has typed it into a word processor. For those who always skip breakfast, you should stop that habit now! You’ve heard many times that “Breakfast is the most important meal of the day.” Now, recsent resaerch confirms that one of the worst practices you can develop may be avoiding breakfast. What should Ms. Jacob have done before printing out the work to make sure that the two underlined words were correct? 3 4. Rehman is typing his Science Project on ‘Sustainable Development’ using word processing software. He wants to add the phrase ‘Sustainable Development’ at the top of each page. How should Rehman accomplish it? 5. What is the function of Preview/Play button in Custom Animation? Explain briefly. 6. Ketan is preparing a presentation for his new Product promotion.  A) The content is ready but he has no time to design backgrounds and decide on color schemes for the presentation. Name the feature that will help him create a professional presentation without devoting much time. B) He wants to set how a slide appears and disappears on screen when he runs the slide show ? Which feature should he use? 7. Name the cells included in the range reference A1:B2? 8. In the Spreadsheet shown below, cell A3, B3 contain numbers, and cell C3 contains a formula. What will happen if i) Contents of cell A3 is changed to 5? ii) Contents of cell B3 are deleted? III) Answer the following questions 30 1. Tarini Fancy Inc. is planning in the Office Building to connect all computers each spread over within distance of 50 Metres. (i) Suggest the economical cable type having high speed data transfer which can be used to connect these computers. (ii) Which type of Network (out of WAN, LAN and MAN) will be formed by connecting these computers? (iii) Which device will be used to connect all the computers? 2. A few output devices and tasks are given. Select the output device most appropriate for the task given below. Output devices Dot Matrix Printer ,Laser Printer ,Plotter ,Inkjet Printer ,Speakers Tasks: 4 a)Producing 1000 letters quickly, to be sent to members of a club b)Producing a graph of a patient’s heart beat in a hospital c)Producing an audible warning signal . 3. Following is a text document containing a letter. The line numbers are given on the right hand side of the document. Observe the following document and answer the questions a) to c) From: 1 Customer Help Manager, 2 Fountain Spray Corporation, 3 New City 4 Date: 31st March, 2009 5 To, 6 Yanran Philip 7 R-900, Jalyaan Vihar 8 King Nagar 9 10 Subject: Reply to Complaint no. A-349562 11 Dear Madam 12 13 This is with reference to your complaint no A-349562 with regard 14 to our Automatic Spray System Model 978. We would like to inform 15 you the following: 16 1. The defect informed by you is not covered in our Warranty Terms. 17 2. The defective part is required to be imported from Japan. 18 3. As a privileged customer of ours, company will be able to give 19 50% discount on the part along with free installation at your 20 premises. 21 22 Kindly let us know your decision in this regard. 23 24 In your best service! 25 26 Sincerely Your 27 28 Anika Palan 29 30  CustCare@AutoSpray.com 31 www.AutoSpray978.com 32 a) Name the feature used to insert the digital signature of the Customer Help Manager In line 28. b) The manager wants to send the letter with same content to all customers with similar complaints. The addresses of all such customers are stored in a 5 separate document. Name the feature which will help the manager achieve the same. c) Identify line(s) where the text is right aligned. (Write line numbers) 4. A car manufacturer recalls a number of faulty cars. The manufacturer decides to use the mail merge option in a word processor to prepare letters to customers. Choose the correct stages how the manufacturer uses mail merge to prepare the letters. A. Choose the merge option to add individual details to the letter. B. Place the variables into the template letter. C. Type the template letter using a word processor and save it. D. Print the letters. E. Use an existing database, or create a new one, and enter the required personal data. F. Attach the data source to the template letter. 5. Hari has used a word processor to write his history homework. Here is some of his homework. Quit India Speech by Mahatma Gandhi on August 8th 1942. “Everybody will be his own master. It is to join a struggle for such democracy that I invite you today. Once you realize this you will forget all the differences, and think of yourselves as Indians only, engaged in the common struggle for independence.” a) Choose two features/tools out from the box that Hari can use to make the title stand out. Spelling Checker, Print Preview, Cut Paste, Bold , Underline, StrikeOut b) Write one Word Processing tool that he can use to find the synonym of “struggle” 6. Suman is working as Marketing Manager in an Advertising Company. She has prepared a presentation on her latest product. What features will be used for the following tasks? a) To view all slides together b) To set timings of the slide show while rehearsing. c) To show the sales using a chart 7. From the following list identify the feature(s) which is/are not available in both Presentation and Word Processing Software. a) Spell Check b) Slide Sorter View c) Macros d) Adding watermarks/background 8. What is an action button? 6 Write ‘True’ for correct and ‘False’ for incorrect statements pertaining to ‘Action Buttons’ in a slide show. a) We can create our own action buttons on a slide. b) An action button can link a slide to a website on Internet. c) Action buttons cannot be resized once they are hyperlinked. d) It is possible to link two objects present on the same slide with the help of an Action Button. 9. Give the following answers with respect to spreadsheet: a) Cell A1 contains the number 20 and B1 contains 3. What will be the contents of cell C1, if the formula =A1+B1*2^3 is entered in cell C1? b) The contents of Cell A1, B1, C1 and D1 are 10, -20, 30 & -40 respectively. What will be the value displayed in cell E1 which contains the formula =MIN(A1:D1) c) Cell D3 contains the formula =$B3 + C3 and this formula is copied to cell E3, what will be the copied formula in cell E3? 10. NewStyle Fashions maintain their employee salary details in a spreadsheet as shown below. A sample data of 7 employees is shown below. Write formulas for the operations (a) to (c) and answer the questions based on the spreadsheet given below along with the relevant cell address: a) To calculate the DA as 25 % of BASIC+HRA for each employee and display in column D. b) To calculate the NETSALARY as BASIC+HRA+DA–PF for each employee and display in column F. c) To find the maximum NETSALARY and display in cell F9. IV) Multiple choice questions (Practical)  24 A B C D E F 1 NAME BASIC HRA DA PF NET SALARY 2 Surinder 50000 20000 ___ 600 ___ 3 Kanika 56000 20000 ___ 600 ___ 4 Aashish 35000 15000 ___ 400 ___ 5 Harjit 45000 15000 ___ 500 ___ 6 Abhijit 60000 25000 ___ 700 ___ 7 Jyoti 75000 30000 ___ 700 ___ 8 Amita 25000 10000 ___ 300 ___ 9 Maximum,Section A Q1. Answer the following in one word. 18 a) The principle of the school has employed Rahul to enter marks of all the students in the result processing software. What is his designation? b) Give full form of EPOS. c) Name the technology that involves masking important data to prevent unauthorized access. d) Runnier has stored the formula = max (A1:A5) in cell A6. How will the formula Change when copied to cell B6. e) Which feature automatically adds no. in the selected cells? f) What is the process of combining text values within formulae called? g) Which column comes after AA? h) What is the default style of alignment of number and text in Ms excel? i) Which feature is used to give a background color in cells? j) It is used to convert a photograph or a printed document into digital file. k) Which device is used to read a multiple choice questions answer sheet? l) Which memory is called non-volatile memory? m) It temporarily stores the files/folder deleted by the user. n) Name the application used as an editor for text only. o) Name the software used to control a computer. p) What are the keyboard shortcuts for copying and moving of files? q) Name the error when data is not available in cells. Q2. Answer the following questions. 8  2=16 a) Mention any two ways in which ICT is useful in education. b) What are intellectual property rights? c) What is the if() function? Write its general format? d) Give one point of difference between alignment and orientation. e) Define formulae in ms excel. Name the type of data it consists of? f) Give 2 point of difference between RAM and ROM. g) Anjali mother want to send an adobe reader file of 2 MB as an attachment with e-mail. It takes too much time to upload/download the files. What should she do to Material downloaded from ,https://myCBSEguide.com, and ,https://onlineteachers.co.in Portal for CBSE Notes, Test Papers, Sample Papers, Tips and Tricks Reduce the no. of bytes? Name the program required for this Name the software h) Explain the different ways of copying the file from the desktop to the D: drive. Q5. Answer the following questions with respect to spreadsheet: 5 a. Cell D2 contains the formula = $B$2+C2 and this formula is copied to cell E2. What will the copied formula in cell E2 be? b. Cell D2 contains the formula = $B2+C2 and this formula is copied to cell E2. What will the copied formula in cell E2 be? c. Cell D2 contains the formula = $B2+C$2 and this formula is copied to cell E3. What will the copied formula in cell E3 be? d. Cell A2 contains the number 10 and cell B2 contains the number2. What will the content of cell C2 be, if the formula = A2+B2^2*5 is entered in cell C2. e. Cells A1, B1, C1, D1, E1 contain 10, 30, -40, -15 Calculate sum. Q6. What is operating system? Explain in detail its four functions. 5 Q7. Describe any 2 mobile operating system with examples. 4 Q8. Raju’s brother is doing a professional course from a university in the united states. He has been assigned a project for evaluation as part of the course. The teacher has given such instruction that nobody should copy any information directly available on the internet and present as if is their own work. If this is done, your project will not be accepted and will be marked as zero. Do you know why the teacher has given such instructions? What is the term used for copying someone’s work? If you have ot copy some information of project, what should you do? 3 Q9. Give two examples of companies using robot in following industries: 3 a. Automotive industry b. Pharmaceutical industry c. Food industry Q10. Observe the following cells and name the type of orientation in each cell. 2 Q11. Define the following with examples 6 1. Mixed referencing 2. Absolute referencing 3. Relative referencing Q12. Alphar pvt Ltd has maintained the salary details of its employees as shown below: The company has decided to give a bonus on the following criteria:  If salary <=40000, bonus is 10% of the salary. 4 Material downloaded from ,https://myCBSEguide.com, and ,https://onlineteachers.co.in Portal for CBSE Notes, Test Papers, Sample Papers, Tips and Tricks  If salary >=40000, bonus is 5% of the salary. a. What formula will your enter in cell D2 to calculate the bonus b. How will you copy the formula to cell D3:D6? Q13. Observe the following table and answer the question that follow. a. How many rows and columns are there in the table? b. What is the Alignment of data in each cell in row 2? c. What is the alignment of data in cell in row 3? d. How can you change the color of the cells in first row? 4 Q14. Identify the operating system from the list of software given below a. C++ UNIX LINUX EXCEL WORDPAD WINDOWS SOLARIS NOTEPAD MS DOS 2 Section B Q Multiple choice questions: 18 1. Which of the following is not an operating system of mobile phones? a. Android b. Symbian c. Windows 8 d. Unix r,You can visit Google.