DCA Final & ADCA First Sem – ANKAJ INFOTECH EDUCATIONAL TRUST | AN ISO 9001:2015 Certified Organization

1 GB is equal to

(A) 230 bits

(B) 1024 Mega bytes

(C) 220 bits

(D) 220 bytes

What function displays row data in a column or column data in a row ?

Transpose

Index

Rows

Hyperlinks

Which power point view works best for adding slide transition?

(A) Animations

(B) Chart Wizard

(C) Transition Wizard

(D) Auto Content Wizard

How many different positions can you set for drop cap?

(A) 1

(B) 3

(C) 4

(D) 6

Ctrl+Z

(A) Undo the last Action

(B) Redo the last Action

(C) Add the new page

(D) Paste the contents from clipboard

Single spacing in MS-WORD document causes ____ point line spacing?

10

12

14

16

On an excel sheet the active cell in indicated by ?

A A dotted border

A dark wide border

A blinking border

By italic text

File extensions are used in order to ……….

(A) Name the file

(B) Ensure the filename is not lost

(C) Identify the file

(D) Identify the file type

The default style for new data keyed in a new workbook is ?

Comma

Normal

Currency

Percent

How we can view a cell comment ?

position the mouse pointer over the cell

click the comment command on the view menu

C click the edit comment commands on the Insert menu

D click the Display comment command on the window menu

If you press ___, the cell accepts your typing as its contents ?

Tab

Ctrl+Enter

Enter

Alt+Enter

Which among following is not associated with spelling dialogue box?

(A) Edit

(B) Ignore All

(C) Ignore

(D) Change

bit stands for

(A) binary information term

(B) binary digit

(C) binary tree

(D) Bivariate Theory

How to select one hyperlink after another during a slide presentation?

(A) Ctrl+K

(B) Ctrl+D

(C) Ctrl+H

(D) Tab

Which is the part of the computer system that one can physically touch?

(A) data

(B) operating systems

(C) hardware

(D) software

Which one of the following is different from other members?

(A) Google

(B) Windows

(C) Linux

(D) Mac

A ………. is an electronic device that process data, converting it into information.

(A) computer

(B) processor

(C) case

(D) stylus

Compact discs, (according to the original CD specifications) hold how many minutes of music?

(A) 74 mins

(B) 90 mins

(C) 56 mins

(D) 60 mins

What does Ctrl+=key effect?

(A) Superscript

(B) subscript

(C) All caps

(D) Shadow

If you want to go to end of page, you have to press:

(A) End

(B) Ctrl + End

(C) Ctrl + Home

(D) None of these

What is the default number of lines to drop for drop cap

3

10

15

20

Top open an existing workbook, click the open button on the…………toolbar?

(A) form

(B) standard

(C) Drawing

(D) Formatting

Changing the appearance of a document is called

(A) Proofing

(B) Editing

(C) Formatting

(D) All of above

Which functionin Excel tells how many numeric entries are there ?

NUM COUNT SUM CHKNUM 2

Which among following is associated with excel ?

Graphic program

Word Processor

C Presentation

Spreadsheet

What is the maximum font size you can apply for any character

163

1638

16038

None of above

Which of the following is first generation of computer

ICL-2900

CDC-1604

IBM-1401

EDSAC

BCD is

Binary Coded Digit

Binary Coded Decimal

Bit Coded Decimal

Bit Coded Digit

‘ALU’ stands for?

(A) Arithmetic Long Unit

(B) All Longer Units

(C) Around Logical Units

(D) Arithmetic and Logical Units

Pressing F8 key for three times selects

(A) a word

(B) a sentence

(C) a paragraph

(D) entire document

If you need to hide some paragraphs, how can you do it?

(A) From Paragraph dialog box

(B) From Font dialog box

(C) From options Dialog box

(D) None of above

One Gigabyte is approximately equal is:

(A) 1000,000 bytes

(B) 1000,000,000 bytes

(C) 1000,000,000,000 bytes

(D) None of these

To print power point presentation, press:

(A) Ctrl+P

(B) Ctrl+S

(C) Ctrl+Shift+P

(D) Ctrl+A

EEPROM stand for

Easily Erasable Programmable Read Only Memory

Electrically Erasable Programmable Read Only Memory

Electronic Erasable Programmable Read Only Memory

None of the above

What is the maximum font size you can apply for any character

(A) 163

(B) 1638

(C) 16038

(D) None of above

What function displays row data in a column or column data in a row?

(A) Hyperlinks

(B) Rows

(C) Index

(D) Transpose

IC chips used in computers are usually made of:

(A) Lead

(B) Silicon

(C) Chromium

(D) Gold

What is the maximum scale percentage available in Scale drop down box?

500

200

100

90

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

Pie Chart

Column Chart

Line Chart

Dot Graph

What term describes explanatory text attached to a cell ?

Context

Callout

Dialog

Comment

How many ways you can save a document?

3

4

5

6

There are …………. parts to a computer system.

(A) 2

(B) 4

(C) 16

(D) 100

Which of the following is not available in font spacing?

(A) Normal

(B) Loosely

(C) Condensed

(D) Expanded

Special effects used to introduce slides in a presentation are known as ?

(A) transition

(B) effects

(C) Custom animations

(D) annotations

How many columns can you insert in a word document in maximum?

35

45

55

63

Microprocessors as switching devices are for which generation computers

First Generation

Second Generation

Third Generation

Fourth Generation

The hexadecimal number system consists of the symbols

(A) 0 – 7

(B) 0 – 9 , A – F

(C) 0 – 7, A – F

(D) None of these

You can convert existing Excel worksheet data and charts to HTML document by using the ?

Internet Assistant Wizard Intranet Wizard mport Wizard Export Wizard 1

In a document what is the maximum number of columns that can be inserted in MS Word Table?

(A) 35

(B) 15

(C) 63

(D) 65

Which of the following is not an example of an Operating System?

(A) Windows 98

(B) BSD Unix

(C) Microsoft Office XP

(D) Red Hat Linux

What is the shortcut key to open the open dialog box?

(A) Ctrl+Alt+Enter

(B) Ctrl+shift+Enter

(C) Alt+Shift+Enter

(D) Alt+Space+Enter

FORTRAN is

File Translation

Floppy Translation

Format Translation

Formula Translation

One kilobyte is equal to:

(A) 1000 bytes

(B) 100 bytes

(C) 1024 bytes

(D) 1023 bytes

Second Generation computers were developed during

1970 to 1990

1965 to 1970

1956 to 1965

1949 to 1955

You can edit an embedded organization chart object by ?

(A) Double clicking the organization chart object.

(B) Clicking edit object

(C) Right clicking the chart object, then clicking edit MS-Organization Chart object.

(D) A and C both

Which file format can be added to a power point show?

.gif

.jpg

.wav

All of above

Which of the following is used to Manage Data Base?

1) Operating System

2) Compiler

3) DBMS

4) None of the above

Which supercomputer is developed by the Indian Scientists?

(A) Param

(B) Super 301

(C) Compaq Presario

(D) CRAY YMP

Except which of the following function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result ?

NOT

OR

IF

AND

Protection and the Protect Sheet options can be selected from?

(A) Data

(B) Tools

(C) Edit

(D) Format

What type of process creates a smaller file that is faster to transfer over the internet?

(A) Compression

(B) Fragmentation

(C) Encapsulation

(D) None of the above

What would I choose to create a pre-formatted style?

(A) Format

(B) Slide layout

(C) Slide sorter view

(D) None of above

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

Column

Value

Address

Cell

What is the maximum number of lines you can set for lines to drop box?

3

5

10

15

EBCDIC stands for

Extended Binary Case Decimal Interchange Code

Extended Bit Case Decimal Interchange Code

Extended Bit Cod Decimal Interchange Code

Extended Binary Coded Decimal Interchange Code

There can be many ways to insert page number in a document. Which of the following lets you insert page number?

(A) Page number from insert menu

(B) Page setup from file menu

(C) Footnote from Insert menu

(D) Both a & c

Which power point view works best for adding slide transition?

(A) Slide sorter view

(B) Slide show view

(C) Slide view

(D) Notes

A features that displays only the data in column (s) according to specified criteria

Formula Sorting Filtering Pivot 3

ASCII stands for

American Standard Code for Information Interchange

American Stable Code for International Interchange

American Standard Case for Institutional Interchange

American Standard Code for Interchange Information

What is the default file extension for all Word documents?

.txts

.word

.docs

.docx

The term ‘Pentium’ is related to –

(A) DVD

(B) Hard Disk

(C) Microprocessor

(D) Mouse

Slide sorter can be accessed from which menu?

(A) View

(B) Edit

(C) File

(D) Insert

Chief component of first generation computer was

Vacuum Tubes and Valves Transistors Integrated Circuits All of above 1

Which is not data source component?

(A) mail merge toolbar

(B) header row

(C) data fields

(D) data records

You can convert existing Excel worksheet data and charts to HTML document by using the?

(A) Intranet Wizard

(B) Internet Assistant Wizard

(C) Important Wizard

(D) Export Wizard

Superscript, subscript, outline, emboss, engrave are known as

(A) Font styles

(B) font effects

(C) word art

(D) text effects

How can you make the selected character superscripted

(A) Ctrl + =

(B) Ctrl + Shift + =

(C) Alt+Ctrl+Shift+=

(D) None of these

What is the maximum number of lines you can set for a drop cap?

3

10

15

20

Which of the following is the most powerful type of computer?

(A) Super-micro

(B) Super Computer

(C) Micro Computer

(D) Mini Computer

What term describes a background that appears as a grainy, non-smooth surface?

(A) Pattern

(B) Gradient

(C) Velvet

(D) Texture

Which of the following is not an input device?

(A) Mouse

(B) Light pen

(C) Keyboard

(D) VDU

Which of the following is not the part of standard office suite?

(A) Word Processor

(B) Data base

(C) Image editor

(D) File manager

The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is ?

C1:10H

C1:H10

C1:H-10

C1:H:10

Which of the following is the latest version of MS Word?

(A) Word 2000

(B) Word 2007

(C) Word 2010

(D) Word 2013

Which among following is associated with excel?

(A) Graphic program

(B) Spreadsheet

(C) Microsoft office

(D) None of these

Macros can be executed from the which of the following menu ?

Format

Home

Insert

View

How many different positions can you set for drop cap?

1

2

4

6

What is the default font size of a new Word document based on Normal template in Word 2010?

(A) 10 pt

(B) 11 pt

(C) 14 pt

(D) None of above

The computer size was very large in

First Generation

Second Generation

Third Generation

Fourth Generation

Formula palette is used to?

(A) format cells containing number

(B) created and edit formulas containing functions

(C) entered assumption data

(D) Copy all cells

Word, by default, places a tab stop at every _____ mark on the ruler.

.25″ .5″ .75″ 1″ 2

.25"

.5"

.75"

1"

To edit a chart, we can

(A) Click and drag the chart object

(B) Double click the chart object

(C) Triple click the chart object

(D) Click the chart object

You can detect spelling and grammar errors by

(A) Press Shift + F7

(B) Press Ctrl + F7

(C) Press Alt + F7

(D) Press F7

With which of the following all formulas in excel starts ?

/

@

=

#

Which of the following is an example of non-volatile memory?

(A) Cache memory

(B) RAM

(C) ROM

(D) None of the above

Bold, italic, Regular are known as

(A) Font styles

(B) Font effects

(C) word art

(D) text effects

The file type _____ indicates the file is a Word document.

.msw

.wor

.wrd

.doc

A Spreadsheet contains?

(A) columns

(B) rows

(C) rows and columns

(D None of these

In a document what is the maximum number of columns that can be inserted in MS Word Table?

35

15

63

65

Statistical calculations and preparation of tables and graphs can be done using

Adobe Photoshop

Excel

Notepad

Power Point