P.G.D.C.A. (Semester (CBCS) Examination Oct/Nov-2018
INTRODUCTION TO ACCOUNTING PACKAGE AND MS-OFFICE
Time: 2½ Hours Max. Marks: 70
Instructions: All questions are compulsory.
Figures to the right indicate full marks.
Q.1 Choose the correct alternative. 14
In MS-Excel which functions will calculate the number of workdays between
6/9/2013 and 8/12/2013.
Workday Date
Networkday Weekday
MS-Excel uses the Function when creating a data table.
Average Count
Both a and b Table
In MS-Excel to protect a worksheet, you can choose Protection and the
Protect Sheet from the menu.
Edit Format
Tools All of the above
In MS-Excel the auto calculate feature
Can add values in a range of cells
Provides a quick way to view the results of an arithmetic operation on a
range of cells
Automatically creates formula and adds them to a worksheet
All of these
In Ms-Excel to copy cell contents using drag and drop, press the
End key Shift+End
Esc None of the above
are the economic resources of the entity, and include such items as
cash, accounts receivable.
Assets Business
Cost None of these
are amounted owned to others related to loans, extensions of credit.
Assets Liabilities
Credit All of the above
Labor related to manufacturing of product can be classified under
direct manufacturing labor costs indirect manufacturing labor cost
work in process costs finished costs
Microsoft word is a Program.
Word Processing Spreadsheet
Presentation All of the above
10) If you want to copy a selection text, which button do you click?
Cut Move
Copy Duplicate
Page 2 of 2
SLR-CG-2
11) The Save As dialog box can be used to save file by some alternative name
True False
12) function in Excel used to add values in the cell.
Sum Avg
Count Add
13) Use function to return one value if a condition is true and
another value if it's false.
While If
Do All of these
14) The extension of Power Point File is
Exe XLS
.doc .ppt
Q.2 Answer the following. (Any four) 08
What is accounting equations?
What is Tally software?
What is a Voucher in Tally?
What is a Ledger?
What is MS-OFFICE?
Answer the following. (Any two) 06
What is a Workbook in the Excel?
Define the terms "revenue" and "expense".
What is net income? Explain.
Q.3 Answer the following. (Any two) 08
What is accounting? Explain.
What is a power point presentation? Explain
Explain the different page views in MS-Word.
Answer the following. (Any one) 06
What is the golden rule in accounting? Explain.
Explain types of accounts.
Q.4 Answer the following. (Any two) 10
Write the difference between manual accounting and computerized
accounting.
What is Gate Way Of Tally? Explain.
Explain count and sum function in Excel.
Answer the following. (Any one) 04
What are the uses of Power Point?
Explain different types of charts in Excel.
Q.5 Answer the following. (Any two) 14
What is a Balance Sheet in Tally? Explain with suitable example.
What is text Formatting? Explain different text formatting options in MSWORD.
Explain steps to adding sounds, graphics and Inserting, Deleting, Copying
slides.