DCA Online Test

Sorting

Filter

Inserting

Deleting

Shift + V

Ctrl+ V

Ctrl + Alt + V

Ctrl + Shift + V

Media Playback

3D settings

Painting

Drawing

A-1, B-2, C-3, D-4

A-4, B-3, C-2, D-1

A-3, B-4, C-1, D-2

A-2, B-1, C-4, D-3

Edited

Shown

Deleted

All the above

Ctrl + 4

Ctrl + 3

Ctrl + 2

Ctrl + 1

Ctrl+E

Ctrl+W

Ctrl+T

Ctrl+Q

Cut, Copy, Paste

Find and Replace

Select All

All of these

Ctrl + v

Ctrl + M

Ctrl + Shift + F

Ctrl + 1

Non-breaking space

Non-breaking hyphen

Word Joiner

Sentence Joiner

Function

Formula

Graph

Chart

Left

Right

Center

Justified

Formula Bar

Address Book

Name box

None

1024

1048576

16384

None

7

10

3

1

35

-35

12

2

Bold, Italics, Underline

Left, Center, Right, Justify

Font Name, Font Size, Font Color

None of These

Filter

Sort

List

Arrange

Ctrl+Shift+V

Ctrl+V

Ctrl+C

Strl+Shift+S

32000

48000

60000

None of these

Corel Draw

Wordstar

EXCEL

MS-WORD

Format

Style

Sheet

Edit

Store data

Manipulate data

Create graphical representation of data

All of these

By manual entry

By auto-sum

By formula

By sum function

.ods

.odt

.ott

.odf

Prediction Values

Variable Cell

What if Values

Target Value

Single-click the boundary to the left to the column heading

Double click the boundary to the right of the column heading

Press Alt and single click anywhere in the column

All of above

A unique identifier for each cell in the spreadsheet

A function used to format cells

A hyperlink to another cell or document

A shortcut key for accessing cells

Ctrl + F2

Ctrl + F4

Ctrl + F3

None of these

$D$10

AMJ1048575

XFD1048576

$AMD$1048576

Sorts data

Adjusts row/column size automatically

Creates formulas

Protects cells

Center

Split Cells

Split and merge

Merge and center

=ADD(A1:A10)

=TOTAL(A1:A10)

=SUM(A1:A10)

=SUM(A1,A10)

Sorting

Inserting

Filtering

Deleting

Type Monday, hold down right corner and pull down

Do inter press by writing monday

= week () uses the function

All of the above

Nested Function

Function

General Function

Condition Function

Instant messaging, address book, antivirus, mailing list

Forms, data analysis, conditional formatting, sorting and filtering

Graphics, templates, spell checker, thesaurus

Accessibility, multimedia, hyperlinks, updated

Two

Three

Four

Five

15

3

4

5

8

10

12

14

Untitled1

Calc1

Spreadsheet1

None of These

11

12

13

10

'=' sign

Alphabets

Numbers

All of the these

Deletes unwanted data

Hides records not matching criteria

Sorts data automatically

Creates reports

See Only Specific Data

Arrange data

Copy Data

Making Chart

256

1028

10000

None of These

10

3

7

1

Alt+=

Ctrl+=

Shift+=

Alt+S

Text Files

Satellite data

Sensor data

Seismic imagery data

Data Series

Chart Series

Chart Elements

Chat type