Sterliate Educations

673-A, Second Floor, Gali No.-7, Govindpuri, Kalkaji,, New Delhi 110019 Bharat
MDCTT-MARCH-23
Question : 50 Duration : 40 Minutes

1

The valid format of MS Word is ___

A: .exe
B: .doc
C: .png
D: .exe
Answer: B

2

 Which of the following submenu convert the .cdr file in .jpeg format?

A: filter
B: import
C: export
D: filter
Answer: C

3

In Corel Draw the keyboard shortcut to save your drawing is .............

A: Ctrl +c
B: Ctrl +z
C: Ctrl +s
D: Ctrl +c
Answer: C

4

what is the shortcut key to toggles snapping to objects?

A: Ctrl +L
B: Alt +Z
C: CtrI +G
D: Ctrl +L
Answer: B

5

What is the shortcut key to combine the selected objects?

A: Ctrl +Q
B: CtrI +Y
C: CtrI +K
D: Ctrl +Q
Answer: D

6

 What is the extension of corel draw?

A: PSD
B: CDR
C: DWG
D: PSD
Answer: B

7

Corel draw was written in ...............

A: Java
B: Python
C: Angular
D: Java
Answer: D

8

The CorelDraw, was initially released in .............

A: 1989
B: 1988
C: 1990
D: 1989
Answer: A

9

Corel Draw was developed by

A: Microsoft Inc.
B: Google
C: Corel Corporation
D: Microsoft Inc.
Answer: C

10

what is corel draw?

A: Word Editor
B: Vector Graphics Editor
C: Operating System
D: Word Editor
Answer: B

11

A command that lets you change one or more fields in a record is


A: Look-up
B: Insert
C: Modify
D: Look-up
Answer: C

12

In a database, a network structure


A: allows many-to-many relationship
B: is a physical representation of the data
C: allows only one-to-one relationship
D: allows many-to-many relationship
Answer: A

13

An entry in the telephone book can be compared to a


A: Field
B: Record
C: File
D: Field
Answer: B

14

A file consists of


A: Fields and records
B: Records and sorts
C: Fields and sorts
D: Fields and records
Answer: A

15

The default and maximum size of text field in access

A: 50 and 255 characters
B: 266 characters and 6400 characters
C: 288 characters and 6880 characters
D: 50 and 255 characters
Answer: A

16

Open the Save As dialog box

A: F1
B: F2
C: F10
D: F1
Answer: D

17

Which tool do you use to create a query object?

A: Table query wizard
B: Simple query wizard
C: Simple filer wizard
D: Table query wizard
Answer: B

18

In Access, ____ are used to store the data.

A: Report
B: Form
C: Table
D: Report
Answer: C

19

____ is not a valid data type in MS Access.

A: Auto number
B: Currency
C: Memo
D: Auto number
Answer: D

20

A subset of characters within a data field is known as

A: Byte
B: File
C: Record
D: Byte
Answer: D

21

Microsoft Access is a _____

A: Network Database Model
B: RDBMS
C: ORDBMS
D: Network Database Model
Answer: B

22

what can be the maximum length of a text field ?

A: 120
B: 255
C: 265
D: 120
Answer: B

23

In which method we don't need to specify the field type and size while creating a new Table?

A: Design View
B: While using Wizard
C: CreateTable By Entering Data
D: Design View
Answer: C

24

Which of the following is not a type of MS Access database object?

A: Table
B: Form
C: Worksheets
D: Table
Answer: C

25

Which field type will you select if you need to enter long text in that field?


A: Text
B: Memo
C: Currency
D: Text
Answer: B

26

All of the following terms are associated with spreadsheet software except


A: Virus detection
B: Formula
C: Cell
D: Virus detection
Answer: A

27

Each box in a spreadsheet is called a


A: Field
B: Record
C: Cell
D: Field
Answer: C

28

Data Folder of a Company consists of


A: 3 digits
B: 4 digits
C: 5 digits
D: 3 digits
Answer: C

29

Service Tax Report can be seen from

A: Display > Account Books
B: Display > Statutory Reports
C: Display > Day Book
D: Display > Account Books
Answer: B

30

Transfer from Main Cash to petty Cash you require to pass _____ voucher.

A: Contra
B: Payment
C: Receipt
D: Contra
Answer: A

31

Manufacturing journal creates based on

A: Purchase Quotation
B: Stock Journal
C: Receipt Note
D: Purchase Quotation
Answer: B

32

Tally package is developed by


A: Microsoft
B: Adobe Software
C: Apple Software
D: Microsoft
Answer: D

33

Which option is used to view list of Primary and Secondary groups in Tally?


A: Accounts
B: List
C: List of Accounts
D: Accounts
Answer: C

34

We can see list of Memorandum Vouchers from


A: Accounts Books
B: Cash/Bank Books
C: Exception Reports
D: Accounts Books
Answer: C

35

Bank OCC a/c is a group defined under


A: Loan & Liability
B: Secured Loan
C: Unsecured Loan
D: Loan & Liability
Answer: A

36

TDS deduction entry can be made through

A: Journal voucher
B: Payment Voucher
C: Receipt Voucher
D: Journal voucher
Answer: A

37

Which shortcut key is used in ‘Company Features’ Screen to use Statutory & Taxation in Tally?

A: F1
B: F2
C: F3
D: F1
Answer: C

38

Which shortcut key(s) are used to display list of inventory reports within balance sheet?

A: F8
B: F9
C: F10
D: F8
Answer: B

39

Party account can be created through

A: Inventory creation window
B: Group creation window
C: Ledger creation window
D: Inventory creation window
Answer: C

40

_____ is the shortcut to Payroll Auto fill from Payroll Vouchers in Tally.


A: Alt+S
B: Alt+A
C: Ctrl+F4
D: Alt+S
Answer: B

41

Transfer of materials from one godown to another godown, use


A: Stock Journal
B: Purchase Journal
C: Manufacturing Journal
D: Stock Journal
Answer: A

42

We can cancel a voucher using


A: Alt + X
B: Ctrl + Shift + X
C: Ctrl + X
D: Alt + X
Answer: A

43

The shortcut used to activate calculator is


A: Ctrl + A
B: Ctrl + B
C: Ctrl + M
D: Ctrl + A
Answer: D

44

Which one of the following is not a Spreadsheet program?


A: Quattro Pro
B: MS-DOS
C: Lotus 1-2-3
D: Quattro Pro
Answer: B

45

An Excel file is generally called a / an :


A: E-Spreadsheet
B: Woorksheet
C: Workbook
D: E-Spreadsheet
Answer: C

46

It is a collection of data that is stored electronically as a series of records in a table.

A: spreadsheet
B: presentation
C: database
D: spreadsheet
Answer: C

47

A typical worksheet has ________ Number of columns in excel 2003


A: 128
B: 256
C: 512
D: 128
Answer: B

48

 How many characters can be typed in a single cell in Excel?


A: 256
B: 1024
C: 32000
D: 256
Answer: D

49

What type of chart is useful for comparing values over categories ?

A: Pie Chart
B: Column Chart
C: Line Chart
D: Pie Chart
Answer: B

50

Where is data saved permanently?


A: Printer
B: CPU
C: Storage
D: Printer
Answer: C