Calc

Write

Publisher

Excel

Data formatting

Data sorting

Data filtering

Data validation

Instant messaging, address book, antivirus, mailing list

Forms, data analysis, conditional formatting, sorting and filtering

Graphics, templates, spell checker, thesaurus

Accessibility, multimedia, hyperlinks, updated

AutoFilter

Conditional formatting

Pivot tables

Data validation

Tab

Ctrl + Tab

Ctrl + Shift + Tab

Shift + Tab

To create charts and graphs

To format cells

To perform calculations and manipulate data

To insert images

Print View

Print Preview

Print Screen

Print Document

7,2

7+2

9

5,7

Find and replace

By Copy only

By copy command

By preview command

Media Playback

3D settings

Painting

Drawing

C1:10H

C1:H10

C1:H-10

C1:H:10

Format

Style

Sheet

Edit

Ctrl + v

Ctrl + M

Ctrl + Shift + F

Ctrl + 1

Ctrl+]

Ctrl+[

Ctrl+}

Ctrl+{

Recalculated formulas in all sheets

Update chart

Open Styles

Create a document template

Date( )

Date( )

Now( )

Time( )

Ctrl + ;

Shift + D

Ctrl + D

Alt + D

@

#

$

&

Ctrl + ]

Alt +D

Ctrl + ;

Shift + K

See Only Specific Data

Arrange data

Copy Data

Making Chart

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

Ctrl + M

Ctrl + Shift + M

None

Formula Bar

Address Book

Name box

None

256

1028

10000

None of These

Bold, Italics, Underline

Left, Center, Right, Justify

Font Name, Font Size, Font Color

None of These

Heading1

Good

Bad

Poor

1048576 Rows & 1024 Columns

1048576 Rows & 16384 Columns

16384 Rows & 1048576 Columns

1024 Rows & 1048576 Columns

AutoFilter

Advanced Filter

Standard

Sorting

1

2

3

4

Column

Value

Address

Cell

Filter

Sort

List

Arrange

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

Ctrl + ;

Ctrl + Shift + :

A and B both

None

Ctrl + ;

Ctrl + Shift + ;

Ctrl + T

None

.ODF

.ODF

.ODS

.OBT

10

0

5

15

Sorting

Searching

Filtering

Validating

.ods

.odt

.ott

.odf

Ctrl+f

Ctrl+D

Ctrl+L

Ctrl+1

Type Monday, hold down right corner and pull down

Do inter press by writing monday

= week () uses the function

All of the above

Shift + 1

Ctrl + 1

Alt + 1

Ctrl + Alt + 1

Left

Right

Center

Justified

do calculations

create graphics

plot graphs

plot charts

Bottom left of the menu bar

Top left over menubar

On the status bar

Bottom right side of the menu bar

Sorting

Filter

Inserting

Deleting

$D$10

AMJ1048575

XFD1048576

$AMD$1048576

Nested Function

Function

General Function

Condition Function

Ctrl + Shift + B

Ctrl + Shift + P

Ctrl + Shift + +

None of these

Directly typing function name in a cell

Using function wizard or selecting from toolbar

Both (a) and (b)

Depends on the function

Format

Style

Sheet

Edit