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.