ADCA Online Test

Non-breaking space

Non-breaking hyphen

Word Joiner

Sentence Joiner

247

200

240

200.47

Edited

Shown

Deleted

All the above

1

2

3

4

File

Edit

View

Insert

Lock Cells

Freeze Panes

Split Sheet

Protect Sheet

Bubble

Circle

Baloon

Hollow

Line Chart

Bar Chart

Pie Chart

Scatter Chart

32000

48000

60000

None of these

Shift + F3

Ctrl + F2

Ctrl + F3

Alt + F3

7

10

3

1

#name?

#name

Whatever is written in a formula will remain the same

####

Sorting

Inserting

Filtering

Deleting

.odp

.ods

.odd

.odt

35

-35

12

2

Date( )

Date( )

Now( )

Time( )

Prediction Values

Variable Cell

What if Values

Target Value

1024 rows and 1048576 columns

10000 rows and 32000 columns

1,048,576 rows and 16,384 columns

None of above

Left

Right

Center

Justified

1199

1210

1188

None

1048576

16348

1084576

1024598

Sorting

Searching

Filtering

Validating

SUM

COUNT

AVERAGE

MEAN

F2

Ctrl + Shift + M

Ctrl + M

F3

See Only Specific Data

Arrange data

Copy Data

Making Chart

AMJ

XFD

AMG

EMJ

Corel Draw

Wordstar

EXCEL

MS-WORD

Column

Value

Address

Cell

To apply predefined formatting to cells based on specific conditions

To perform complex calculations and data analysis

To filter and display only the rows that meet specific criteria

To create charts and graphs

Shift+F2

Shift+F5

Shift+F3

CTRL+F9

Store data

Manipulate data

Create graphical representation of data

All of these

Instant messaging, address book, antivirus, mailing list

Forms, data analysis, conditional formatting, sorting and filtering

Graphics, templates, spell checker, thesaurus

Accessibility, multimedia, hyperlinks, updated

Date

Formula

Cell Value

All the above

Freeze current column

Freeze current cell

Freeze current row

Freeze First Row

Microsoft Excel

OpenOffice Calc

LibreOffice Calc

LibreOffice Draw

7,2

7+2

9

5,7

OpenDocument

Microsoft Excel

PDF

All the above

Ctrl + Shift + B

Ctrl + Shift + P

Ctrl + Shift + +

None of these

cell reference

cell identify

cell across

cell identification number

X.502

X.503

X.510

X.509

Data

Text

Mathematical

String

Find and replace

By Copy only

By copy command

By preview command

511

508

510

509

Cell

Tabel

Position

Data

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

Shift + 1

Ctrl + 1

Alt + 1

Ctrl + Alt + 1

8

12

14

10

.odt

.ods

.odp

.xlsx

Ctrl + Shift + F

Ctrl + Shift + S

Ctrl + F2

None

Ctrl + ]

Alt +D

Ctrl + ;

Shift + K