DFA Online Test

Ctrl + v

Ctrl + M

Ctrl + Shift + F

Ctrl + 1

Line Chart

Bar Chart

Pie Chart

Scatter Chart

File name

Location where the file is to be saved

Both A and B

None of these

N10

M11

M9

M12

DCOUNT

DCOUNTA

COUNTA

COUNTIF

Sorts data

Adjusts row/column size automatically

Creates formulas

Protects cells

11

12

13

10

Ctrl + W

Ctrl + Q

Ctrl + Shift + C

Shift + W

A3

$A$3

A$3

$A3

do calculations

create graphics

plot graphs

plot charts

8

10

12

14

Open Find dialog box

Open Find & Replace dialog box

Font dialog box

Format dialog box

Insert

Data

Tools

View

Ctrl + +

Ctrl + -

Ctrl + D

Delete

Corel Draw

Wordstar

EXCEL

MS-WORD

1024

1048576

16384

None of These

1048576 Rows & 1024 Columns

1048576 Rows & 16384 Columns

16384 Rows & 1048576 Columns

1024 Rows & 1048576 Columns

.ods

.odt

.ott

.odf

35

-35

12

2

Ctrl + Shift + P

Ctrl + Shift + O

Ctrl + P

None of These

Mathematical

Financial

Statistical, logical

All of these

Calc

Write

Publisher

Excel

Bold, Italics, Underline

Left, Center, Right, Justify

Font Name, Font Size, Font Color

None of These

1

2

3

4

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

Ctrl+F12

F2

Ctrl+1

Ctrl+F1

See Only Specific Data

Arrange data

Copy Data

Making Chart

Instant messaging, address book, antivirus, mailing list

Forms, data analysis, conditional formatting, sorting and filtering

Graphics, templates, spell checker, thesaurus

Accessibility, multimedia, hyperlinks, updated

#name?

#name

Whatever is written in a formula will remain the same

####

A dotted border

A dark wide border

A blinking border

By italic text

Horizontal

Vertical

Both A and B

None of These

Deletes unwanted data

Hides records not matching criteria

Sorts data automatically

Creates reports

Ctrl+]

Ctrl+[

Ctrl+}

Ctrl+{

Ctrl + A

Ctrl+ Shift + A

Ctrl + Shift + Space

A and C Both

Center

Split Cells

Split and merge

Merge and center

1

15

56

-1

@

#

$

&

Alt+=

Ctrl+=

Shift+=

Alt+S

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

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

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

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

Change

Text

Transpose

Convert

1199

1210

1188

None

Nested Function

Function

General Function

Condition Function

Bar Chart

Column Chart

Pie Chart

Line Chart

C1:10H

C1:H10

C1:H-10

C1:H:10

Ctrl + 4

Ctrl + 3

Ctrl + 2

Ctrl + 1

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

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

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

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

Bubble

Circle

Baloon

Hollow

1 → B, 2 → E, 3 → D, 4 → A

1 → B, 2 → F, 3 → D, 4 → E

1 → A, 2 → B, 3 → F, 4 → C

1 → F, 2 → E, 3 → D, 4 → A

Sorting

Searching

Filtering

Validating

###

The cell size increase automatically

####

#Name?