PRACTICAL QUESTION OF DCA AND TALLY FOR FINAL EXAM

 MS WORD

1. PREPARE A BOOK WITH HEADER,FOOTER,PAGE NUMBER,WATERMARK,PAGE BORDER AND PICTURE?

ANS:-

2. PREPARE A MAIL FOR 5 EMPLOYEE?

3. WRITE A APPLICATION FOR LEAVE TO THE DIRECTOR OF BCA?

4. SHOW THE USE OF SMART ART AND CHARTS ?

   SMART ART:-MENTION ALL THE PARTS OF ADCA

CHART:- 

PRODUCT NAME:- COPY     PEN     PENCIL    BOOK

SALES                     :-5000         4000      3200          6800

5.PREPARE 3 STUDENT  MARK SHEET?

6.DRAW A LOGO OF BANERJEE COMPUTER ACADEMY?

7.MAKE AN IDENTITY CARD FOR BANERJEE COMPUTER ACADEMY?

8.SHOW HYPERLINK,BOOKMARK,CROSS REFERENCE?

9.HOW WE PROTECT OUR PAGE AND DOCUMENT OF MS WORD?

10.HOW WE RECORD MACRO?

EXCEL

1.SHOW ME THE USE THE OPTION TEXT THAT CONTAINS IN HIGHLIGHT CELL RULE?

2.SHOW ME THE USE OF TOP 10 ITEMS AND BOTTOM 10 ITEMS IN TOP/BOTTOM RULE?

3.SHOW ME THE USE OF PRINT TITLES?

4.SHOW ME THE USE OF ADVANCE OPTION IN SORT AND FILTER OPTION?

5.SHOW ME THE USE OF DATA VALIDATION?

6.SHOW ME THE USE FREEZE PANES?

7.SHOW ME THE OF SAVE WORKSPACE?

8.MAKE A ATTENDENCE SHEET?

9.SHOW ME THE USE OF LOOKUP AND VLOOKUP AND HLOOKUP?

10.SHOW ME THE USE OF PRINT AREA?

POWER POINT

1.MAKE A PRESENTATION ON MY COMPUTER?

2.MAKE A PRESENTATION ON BCA?

3.MAKE A PRESENTATION ON ARCHITECTURE OF COMPUTER?

4.MAKE A PRESENTATION ON ABOUT RANCHI?

5.MAKE A PRESENTATION ON VOUCHERS OF TALLY?

TALLY PRACTICAL QUESTION

1.PASS JOURNAL ENTRY.

LEDGER                                                                    UNDER

1.CAPITAL                                                             CAPITAL A/C

2.FURNITURE                                                      FIXED ASSETS

3.BANK A/C                                                            BANK A/C

4.PURCHASE A/C                                              PURCHASE A/C

5.SALES A/C                                                        SALES A/C

6.WAGES                                                              DIRECT EXPENSES

7.CARRIAGE ON PURCHASE                         DIRECT EXPENSES

8.SHYAM A/C                                                       SUNDRY DEBTOR

9.POSTAL STAMP                                               INDIRECT EXPENSES

10.DISCOUNT ALLOWED                                INDIRECT EXPENSES

A)STARTED BUSSINESS WITH CASH  25000 (F6)

ANS:-   CASH A/C....DR

                   TO CAPITAL A/C

B)PURCHASED FURNITURE  2500   (F5)

ANS:--    FURNITURE A/C ......DR

                       TO CASH A/C

C). OPEN BANK ACCOUNT AND DEPOSITED 5000  (F4)

ANS.    BANK A/C .....DR

                   TO CASH A/C

D)BROUGHT GOODS FOR CASH 2500  (F5)

ANS:-  PURCHASE A/C........DR

                 TO CASH A/C

E)SOLD GOODS FOR CASH  5500  (F6)

ANS:-  CASH A/C .....DR

                  TO SALES A/C

F)PAID WAGES TO WORKER  1200 (F5)

ANS:- WAGES A/C ....DR

                 TO CASH A/C

G)PURCHASED GOODS FROM A. SEN TO CASH 1800  (F5)

ANS:-   PURCHASE A/C......DR

                   TO CASH A/C

H) PAID CARRIAGE ON PURCHASE  150  (F5)

ANS:---  CARRIAGE ON PURCHASE A/C.....DR

                     TO CASH A/C

I). SOLD GOODS TO SHYAM ON CREDIT. 2000 (F8)

ANS:-  SHYAM A/C ....DR

                  TO SALES A/C

J)PURCHASED POSTAL STAMP   20    (F5)

ANS:--   POSTAL STAMP A/C ........DR.

                    TO CASH A/C

K)RECEIVED CASH FROM SHYAM IN FULL SETTELMENT IN HIS ACCOUNT 1950 (F6)

ANS:---   CASH A/C .......DR 1950

                 DISCOUNT ALLOWED A/C ...DR 50

                        TO SHYAM A/C                                  2000

L) DEPOSITED CASH INTO BANK 1500  (F4)

ANS:----  BANK A/C....DR

                     TO CASH A/C

SHOW BALANCE SHEET AND NET PROFIT

BALANCE SHEET:-- 26780

NET PROFIT:----- 1780