Sterliate Educations

673-A, Second Floor, Gali No.-7, Govindpuri, Kalkaji,, New Delhi 110019 Bharat
DCA-TEE july-2024
Question : 50 Duration : 50 Minutes
1

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
2
Press _____ to quit MS Access.
A: Tab +F4
B: Esc+ W
C: Ctrl +F4
D: Tab +F4
Answer: D
3

Microsoft Access is a _____

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

All of the following terms are associated with spreadsheet software except


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

Each box in a spreadsheet is called a


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

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


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

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
8

What is the intersection of a column and a row on a worksheet called ?


A: Column
B: Value
C: Address
D: Column
Answer: D
9

Excel is -------------

A: Rows
B: Columns
C: Cells
D: Rows
Answer: D
10

To calculate the effect of interest rates on sums of money over time, we should use a


A: String function
B: Financial function
C: Statistical function
D: String function
Answer: B
11

In Excel, Columns are labelled as ___

A: A, B, C, etc
B: 1,2,3 etc
C: A1, A2, etc.
D: A, B, C, etc
Answer: A
12

What is the shortcut key to indent a paragraph from left?
A: Ctrl + M
B: Ctrl + N
C: Ctrl + O
D: Ctrl + M
Answer: A
13

Which is the best option for creating "Mailing Label"?
A: Macro
B: Mail Merge
C: Multiple Documents
D: Macro
Answer: B
14

In MS-Word, what is the use of mail merge option?
A: For sending E-mail
B: For merging two or more documents
C: For generating same documents to multiple addresses
D: For sending E-mail
Answer: C
15

What is the combinational shortcut key to insert footnote?
A: Ctrl + Alt + F
B: Ctrl + Alt + D
C: Ctrl + Alt + C
D: Ctrl + Alt + F
Answer: A
16

In MS-Word, what does the green line under a sentence in a document indicate?
A: Spelling mistake
B: Grammatical error
C: Synonym
D: Spelling mistake
Answer: B
17

What is the shortcut key to add or remove space before a paragraph?
A: Ctrl + P
B: Ctrl + 8
C: Ctrl + 0
D: Ctrl + P
Answer: C
18

Which one can be used as watermark in a word document

A: Text
B: Image
C: Both A and B
D: Text
Answer: C
19

Which items are placed at the end of a document

A: Footer
B: Foot Note
C: End Note
D: Footer
Answer: C
20

Which application is commonly used to prepare a presentation/slide show?


A: Internet explorer
B: Outlook Express
C: Photoshop
D: Internet explorer
Answer: D
21

A CPU’s processing power is measured in

A: IPS
B: CIPS
C: MIPS
D: IPS
Answer: C
22

Microfilm reader is a


A: MICR device
B: OCR device
C: COM device
D: MICR device
Answer: C
23

What is MP3?


A: A scanner
B: A sound format
C: A printer
D: A scanner
Answer: B
24

The  ____ of software contains lists of commands and options.


A: Formula bar
B: Title bar
C: Tool bar
D: Formula bar
Answer: D
25

 Which of the following is the extension of Notepad?

A: .txt
B: .xls
C: .ppt
D: .txt
Answer: A
26

Which of the following windows does not have a start button?

A: Windows 7
B: Windows 8
C: Windows XP
D: Windows 7
Answer: B
27

What is the full name of FAT?

A: File attribute table
B: Font attribute table
C: Format allocation table
D: File attribute table
Answer: D
28

When was the first operating system developed?

A: 1948
B: 1949
C: 1950
D: 1948
Answer: C
29

Which of the following is not an operating system?

A: Windows
B: Linux
C: Oracle
D: Windows
Answer: C
30

    Which of the following command in powerpoint is used to bring the user directly to the last slide of the presentation?

    A: Ctrl + End
    B: Alt + End
    C: Shift + End
    D: Ctrl + End
    Answer: A
    31

    Which of the following command in powerpoint is used to bring the user directly to the first slide of the presentation?

    A: Ctrl + Home
    B: Alt + Home
    C: Shift + Home
    D: Ctrl + Home
    Answer: A
    32

    In Powerpoint, the objects on the slide used to hold the text are called as -

    A: Placeholders
    B: Textbox
    C: Text holders
    D: Placeholders
    Answer: A
    33

      Which of the following is the default standard layout in PowerPoint?

      A: Blank slide
      B: Title and content slide
      C: Title slide
      D: Blank slide
      Answer: C
      34

      What we have to type in the Run dialog box to open Powerpoint?

      A: Powerpoint
      B: PowerPoint
      C: Pwrpoint
      D: Powerpoint
      Answer: D
      35

      The maximum percentage of zoom in PowerPoint is -

      A: 350%
      B: 400%
      C: 500%
      D: 350%
      Answer: B
      36

      Slide Sorter view can be selected under which of the following categories?

      A: Home
      B: File
      C: Edit
      D: Home
      Answer: D
      37

      How many maximum slides can be added to a PowerPoint presentation?

      A: 50
      B: 500
      C: No fixed number
      D: 50
      Answer: C
      38

      The main memory of a computer can also be called


      A: Primary memory
      B: Primary storage
      C: Internal memory
      D: Primary memory
      Answer: D
      39

      Where is data saved permanently?


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

      A flat metallic disk that contains a large amount of permanently stored information read optically is called a


      A: RAM
      B: ALU
      C: Monitor
      D: RAM
      Answer: D
      41

      Microsoft Office is an example of a


      A: Horizontal market software
      B: Vertical market software
      C: Open source software
      D: Horizontal market software
      Answer: A
      42

      The process of carrying out commands is called


      A: Executing
      B: Decoding
      C: Storing
      D: Executing
      Answer: A
      43

      The technology that is used to establish wireless networking is


      A: Bluetooth
      B: MATLAB
      C: J2ME
      D: Bluetooth
      Answer: A
      44

      Which of the following numbers is a binary number?

      A: 1 and 2
      B: 0 and 0.1
      C: 2 and 0
      D: 1 and 2
      Answer: D
      45

      What is the full form of USB?

      A: Unshielded Serial Board
      B: Universal System Board
      C: Unidentified serial Bus
      D: Unshielded Serial Board
      Answer: D
      46

      What is the full form of SRAM?

      A: Static Random-Access Memory
      B: Static Remote-Access Memory
      C: Setup Random-Access Memory
      D: Static Random-Access Memory
      Answer: A
      47

      What is the full form of DRAM?

      A: Dynamic Remote Access Memory
      B: Dynamic Random-Access Memory
      C: Dependent Remote Access Memory
      D: Dynamic Remote Access Memory
      Answer: B
      48

       Which of the following values is the correct value of this binary code 1011 and 1111?

      A: 11 and 14
      B: 12 and 15
      C: 11 and 15
      D: 11 and 14
      Answer: C
      49

      Which of the following is equal to a gigabyte?

      A: 1024 bytes
      B: 512 GB
      C: 1024 megabytes
      D: 1024 bytes
      Answer: C
      50

      A table consists of


      A: Rows and cells
      B: Rows and columns
      C: Fields and columns
      D: Rows and cells
      Answer: B