CCA Online Test

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

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

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

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

Heading1

Good

Bad

Poor

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

Ctrl + F6

Ctrl + H

Ctrl + F8

Ctrl + F1

Non-breaking space

Non-breaking hyphen

Word Joiner

Sentence Joiner

Ctrl + C

Ctrl + M

Ctrl + Shift + M

None

Sorting

Inserting

Filtering

Deleting

Shape

Object

Chart

Pie

#name?

#name

Whatever is written in a formula will remain the same

####

Ctrl+Shift+V

Ctrl+V

Ctrl+C

Strl+Shift+S

247

200

240

200.47

C1:10H

C1:H10

C1:H-10

C1:H:10

Untitled1

Calc1

Spreadsheet1

None of these

Shift + 1

Ctrl + 1

Alt + 1

Ctrl + Alt + 1

1048576

16348

1084576

1024598

Edited

Shown

Deleted

All the above

Date

Formula

Cell Value

All the above

Ctrl + Space

Shift + Space

Ctrl + Shift + Page down

None

Insert

Data

Tools

View

Directly typing function name in a cell

Using function wizard or selecting from toolbar

Both (a) and (b)

Depends on the function

Ctrl + ;

Ctrl + Shift + :

A and B both

None

Open Find dialog box

Open Find & Replace dialog box

Font dialog box

Format dialog box

By manual entry

By auto-sum

By formula

By sum function

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+]

Ctrl+[

Ctrl+}

Ctrl+{

Sorts data

Adjusts row/column size automatically

Creates formulas

Protects cells

Ctrl + Shift + V

Ctrl + V

Ctrl + Alt + V

Shift + V

To add data

Formatting

To add formula

All of these

Formula Bar

Address Book

Name box

None

Format

Style

Sheet

Edit

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

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

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

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

Date( )

Date( )

Now( )

Time( )

'=' sign

Alphabets

Numbers

All of the these

CTRL+P

CTRL+Shift+P

Alt+P

CTRL+Alt+P

Horizontal

Vertical

Both A and B

None of These

X.502

X.503

X.510

X.509

.ODF

.ODT

.ODS

.OBT

511

508

510

509

SUM

COUNT

AVERAGE

MEAN

98

97

91

None

Formatting sheets

Evaluating different scenarios

Creating charts

Printing reports

Google Drive

One Drive

IBM Lotus Notes

FTP

AutoFilter

Conditional formatting

Pivot tables

Data validation

Recalculated formulas in all sheets

Update chart

Open Styles

Create a document template

1048576 Rows & 1024 Columns

1048576 Rows & 16384 Columns

16384 Rows & 1048576 Columns

1024 Rows & 1048576 Columns

do calculations

create graphics

plot graphs

plot charts

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

Calc

Base

Writer

Impress

Instant messaging, address book, antivirus, mailing list

Forms, data analysis, conditional formatting, sorting and filtering

Graphics, templates, spell checker, thesaurus

Accessibility, multimedia, hyperlinks, updated

7,2

7+2

9

5,7