Computer Applications in Business — DU B.Com (P) Previous Year Question Papers

1. State True (T) ofFalse a). Give reasons for the same: (a) The SUM function in Excel is used to count the number of non-empty cells in a range. @) CTRL+Z is the shortcut key to redo the last action in MS Word. (c) The Slide Sorter view in Powerpoint allows you to rearrange the order of slides. (d) Mail Merge in MS Word is used to send personalized messages to multiple recipients. (e) The Format Painter tool is used to apply the same for matting to multiple parts of a document. 2. (a).Explainthe steps to create atable inMS word. a) What is a function in Excel? Explain with examples the difference between logical and mathematical froctious. (a) Describe how to use Mail Merge in MS Word for invitation letters. ® What.is a protocol? Explain the purpose of HTTP, FTP, and TCP/IP protocols. 3. (a) Define the term "Operating system." What are the major functions of an operating system? a) Differentiate between primary memory and secondary memory. Give two examples for each. 4. (a) What is meant by input and output devices? Explaln the working of any two input and two output devices. ® What are the types of computer networks? Briefly explain LAN, MAN, and WAN. (a) What are headers and footers used for in word? Describe how to insert page numbers in a footer. a) Explain the use of Charts in Excel. How do Pie charts differ from Column charts? (a) Explain the use of VLOOKUP and HLOOKUP functions in Excel with suitable examples. a) Define firewall and explaln its use in securing a computer network (a) Define computer network. Explain the advantages of networking in business. (b) What is network topology? Describe bus, and ring topologies with diagrams. (a) Explain Database Management System (DBMS)? How is it different from traditional file-based systems. (b) Describe the difference between client-server and peer-to-peer architecture. Give suitable examples. Give the results of the following functions: