DCA Final & ADCA First Sem - ANKAJ INFOTECH EDUCATIONAL TRUST

Changing the appearance of a document is called

(A) Proofing

(B) Editing

(C) Formatting

(D) All of above

The term ‘Pentium’ is related to –

(A) DVD

(B) Hard Disk

(C) Microprocessor

(D) Mouse

Bold, italic, Regular are known as

(A) Font styles

(B) Font effects

(C) word art

(D) text effects

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

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

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

(A) Word Processor

(B) Data base

(C) Image editor

(D) File manager

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

(A) transition

(B) effects

(C) Custom animations

(D) annotations

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 an example of non-volatile memory?

(A) Cache memory

(B) RAM

(C) ROM

(D) None of the above

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

IC chips used in computers are usually made of:

(A) Lead

(B) Silicon

(C) Chromium

(D) Gold

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

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

The computer size was very large in

First Generation

Second Generation

Third Generation

Fourth Generation

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

.msw

.wor

.wrd

.doc

What term describes explanatory text attached to a cell ?

Context

Callout

Dialog

Comment

On an excel sheet the active cell in indicated by ?

A A dotted border

A dark wide border

A blinking border

By italic text

Which of the following is not an input device?

(A) Mouse

(B) Light pen

(C) Keyboard

(D) VDU

Which among following is associated with excel ?

Graphic program

Word Processor

C Presentation

Spreadsheet

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

(A) form

(B) standard

(C) Drawing

(D) Formatting

Second Generation computers were developed during

1970 to 1990

1965 to 1970

1956 to 1965

1949 to 1955

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

(A) Ctrl+K

(B) Ctrl+D

(C) Ctrl+H

(D) Tab

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

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

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

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

10

12

14

16

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

Which of the following is not available in font spacing?

(A) Normal

(B) Loosely

(C) Condensed

(D) Expanded

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

Comma

Normal

Currency

Percent

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

163

1638

16038

None of above

Which functionin Excel tells how many numeric entries are there ?

NUM COUNT SUM CHKNUM 2

Chief component of first generation computer was

Vacuum Tubes and Valves Transistors Integrated Circuits All of above 1

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

One kilobyte is equal to:

(A) 1000 bytes

(B) 100 bytes

(C) 1024 bytes

(D) 1023 bytes

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

35

15

63

65

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

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

35

45

55

63

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

Pie Chart

Column Chart

Line Chart

Dot Graph

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

Tab

Ctrl+Enter

Enter

Alt+Enter

Which power point view works best for adding slide transition?

(A) Slide sorter view

(B) Slide show view

(C) Slide view

(D) Notes

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

(A) Hyperlinks

(B) Rows

(C) Index

(D) Transpose

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 is the default number of lines to drop for drop cap

3

10

15

20

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

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

(A) Font styles

(B) font effects

(C) word art

(D) text effects

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

Formula Sorting Filtering Pivot 3

How many ways you can save a document?

3

4

5

6

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

Adobe Photoshop

Excel

Notepad

Power Point

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

.gif

.jpg

.wav

All of above

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

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

(A) computer

(B) processor

(C) case

(D) stylus

How many different positions can you set for drop cap?

1

2

4

6

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

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

.25"

.5"

.75"

1"

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

3

10

15

20

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

bit stands for

(A) binary information term

(B) binary digit

(C) binary tree

(D) Bivariate Theory

Slide sorter can be accessed from which menu?

(A) View

(B) Edit

(C) File

(D) Insert

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

Column

Value

Address

Cell

BCD is

Binary Coded Digit

Binary Coded Decimal

Bit Coded Decimal

Bit Coded Digit

Which one of the following is different from other members?

(A) Google

(B) Windows

(C) Linux

(D) Mac

Ctrl+Z

(A) Undo the last Action

(B) Redo the last Action

(C) Add the new page

(D) Paste the contents from clipboard

Which is not data source component?

(A) mail merge toolbar

(B) header row

(C) data fields

(D) data records

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

(A) Super-micro

(B) Super Computer

(C) Micro Computer

(D) Mini Computer

Which among following is associated with excel?

(A) Graphic program

(B) Spreadsheet

(C) Microsoft office

(D) None of these

Which power point view works best for adding slide transition?

(A) Animations

(B) Chart Wizard

(C) Transition Wizard

(D) Auto Content Wizard

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

1 GB is equal to

(A) 230 bits

(B) 1024 Mega bytes

(C) 220 bits

(D) 220 bytes

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 of the following is the latest version of MS Word?

(A) Word 2000

(B) Word 2007

(C) Word 2010

(D) Word 2013

To print power point presentation, press:

(A) Ctrl+P

(B) Ctrl+S

(C) Ctrl+Shift+P

(D) Ctrl+A

Which of the following is used to Manage Data Base?

1) Operating System

2) Compiler

3) DBMS

4) None of the above

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

500

200

100

90

Protection and the Protect Sheet options can be selected from?

(A) Data

(B) Tools

(C) Edit

(D) Format

Pressing F8 key for three times selects

(A) a word

(B) a sentence

(C) a paragraph

(D) entire document

A Spreadsheet contains?

(A) columns

(B) rows

(C) rows and columns

(D None of these

You can detect spelling and grammar errors by

(A) Press Shift + F7

(B) Press Ctrl + F7

(C) Press Alt + F7

(D) Press F7

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

(A) Format

(B) Slide layout

(C) Slide sorter view

(D) None of above

Which of the following is first generation of computer

ICL-2900

CDC-1604

IBM-1401

EDSAC

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 are …………. parts to a computer system.

(A) 2

(B) 4

(C) 16

(D) 100

What is the default file extension for all Word documents?

.txts

.word

.docs

.docx

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

‘ALU’ stands for?

(A) Arithmetic Long Unit

(B) All Longer Units

(C) Around Logical Units

(D) Arithmetic and Logical Units

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?

(A) 1

(B) 3

(C) 4

(D) 6

How can you make the selected character superscripted

(A) Ctrl + =

(B) Ctrl + Shift + =

(C) Alt+Ctrl+Shift+=

(D) None of these

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

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

(A) 163

(B) 1638

(C) 16038

(D) None of above

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

(A) data

(B) operating systems

(C) hardware

(D) software

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

FORTRAN is

File Translation

Floppy Translation

Format Translation

Formula Translation

What does Ctrl+=key effect?

(A) Superscript

(B) subscript

(C) All caps

(D) Shadow

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

With which of the following all formulas in excel starts ?

/

@

=

#

Which among following is not associated with spelling dialogue box?

(A) Edit

(B) Ignore All

(C) Ignore

(D) Change

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 maximum number of lines you can set for lines to drop box?

3

5

10

15

Microprocessors as switching devices are for which generation computers

First Generation

Second Generation

Third Generation

Fourth Generation

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

Transpose

Index

Rows

Hyperlinks

Which supercomputer is developed by the Indian Scientists?

(A) Param

(B) Super 301

(C) Compaq Presario

(D) CRAY YMP