Dibrugarh University (B.Com 3rd Sem): Information Technology and Its Applications in Business (ITAB) Important Questions for Upcoming Exam

Information Technology and Its Applications in Business (ITAB)
Dibrugarh University (B.Com 3rd Sem)
Important Questions for Upcoming Exam

Unit – 1: Information Technology

Q.1. What is meant by information Technology? Discuss the basic features of IT and its advantages. 2012, 2013, 2016, 2017, 2018

Q.2. What are different components of IT? Discuss the impact of IT on business environment.          2012, 2013, 2015

Q.3. “Today’s business is dependent on Information Technology” Discuss the statement with examples.          2013, 2014, 2015, 2017

Q.4. Discuss the role of Information Technology on the following fields:                 

(i) Education Sector              2014, 2015, 2016, 2017, 2018

(ii) Manufacturing Industry              2015

(iii) Print and Electronic Media                    2015

(iv) Social Fabric                    2014, 2016, 2017

Unit – 2: Fundamentals of Computers

Q.1. What is software? What are its various types? Explain the functions of utility software.  2012, 2013, 2014, 2015

Q.2. State the relationship and differences between software and hardware.  2012, 2018

Q.3. What is operating system? Explain its functions with proper examples.  2013, 2015, 2017

Q.4. What are various types of secondary storage devices?

Q.5. What is Computer memory? What are its various types? (Types of RAM and ROM) 2015

Q.6. What is EDI? Write a detailed note on the EDI standards.                2012, 2014, 2016, 2018

Q.7. What is EDI? Discuss the working principle and advantages & limitation of EDI.             2013, 2015, 2016, 2017, 2018

Q.8. What are various EDI methods for data transfer between business partner?                   

Unit – 3: Microsoft Word (Part A)

1.  What is meant by word processing?      2012

2. Cutting, copying and Pasting                   2012

3. Using Bullets and Numbering in a document                 2012

4. Justification of Text                       2012

5. Inserting header and footer                     2013

6. Printing a particular page of a document:                     2014

7. Changing the case of a particular word.             2014

8. What is meant by protecting a document and how can it be done in MS-Word?    2015

9. Differentiate between copy-paste and cut-paste.                     2015

10. Printing odd or even pages in a document.                 2016

11. Inserting a picture in a document.                    2016

12. Changing a sentence into toggle case.              2016

13. Find and replace a text in a document.                        2014, 2016, 2017

14. Insert a table with 5 nos. of rows and 4 nos. of columns.   2013, 2017

15. Insert only the even/odd page numbers in a document in the bottom.                  2017

16. How can spell check be performed in MS-Word?                    2013, 2015, 2018

17. How can bullets and numbers be inserted for a piece of text?                                              2018

18. What is mail merge and what are its benefits? How can the main document and the data source be created for the mail merge process in MS-Word?             2015, 2018

Unit – 3: MS-Excel (Part B)

1. State the difference between formulas and functions in MS- Excel.  2012, 2013, 2015

2. Explain the Autosum feature of MS- Excel with an example.   2012, 2013, 2017

3. Write the steps of using find and Replace function in MS-Excel.                     2012

4. Write a detailed note on Ms- Excel and its application in business.                2012

5. What are the different types of charts available in MS-Excel? What are their utilities? What are the steps involved in creating a chart in Ms-Excel.                2013, 2014, 2016, 2018

6. How will you do the following in MS-Excel?                                             2014, 2016

Data Sorting, Numbers formatting in excel, Autofill feature in Excel.

7. What is macro and how can it be created in MS-Excel?                       2015

8. Conditional formatting.                2016, 2017

9. What is Cell referencing and mention its types? 2015, 2017, 2018

10. Explain any two mathematical functions in MS-Excel giving proper syntaxes.        2018

11. What are logical functions? Give the syntax of the logical function IF ().     2018

Unit – 4: Computerized Accounting and Tally

Q.1. “Tally has changed the accounting process of business sector” Do you agree? Explain its importance over manual accounting.              2012, 2014, 2015, 2018

Q.2. What is computerized accounting? Discuss its advantages over manual accounting.                 2015, 2018

Q.3. What is ‘computer accounting’? What are the various ledger accounts supported by Tally? Explain the essential steps in creating a company using Tally.         2013, 2017

Q.4. What is group? Write the steps for creating, displaying and altering single/multiple groups using Tally.     2015, 2017

Q.5. Explain the following:            2016, 2018

a)      Vouchers and voucher entry

b)     Trial Balance

c)      Creating an account in Tally.

d)     Final Accounts in tally

e)      Funds Flow Statement.

f)       Bank Reconciliation Statement.