Up and Down scroll

Right and left

Horizontal and Vertical

All of above

File name

Location where the file is to be saved

Both A and B

None of these

Sorts data

Adjusts row/column size automatically

Creates formulas

Protects cells

2,4,6,2,4

2,4,6,8,10

6,6,6,6

Error

1

15

56

-1

32000

48000

60000

None of these

10

3

7

1

Nested Function

Function

General Function

Condition Function

C1:10H

C1:H10

C1:H-10

C1:H:10

AMJ

XFD

AMG

EMJ

Data Series

Chart Series

Chart Elements

Chat type

Ctrl + ;

Ctrl + Shift + ;

Ctrl + T

None

Ctrl + V

Ctrl + M

Ctrl + Shift + F

Ctrl + 1

Ctrl + F6

Ctrl + H

Ctrl + F8

Ctrl + F1

Freeze current column

Freeze current cell

Freeze current row

Freeze First Row

OpenDocument

Microsoft Excel

PDF

All the above

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

Change

Text

Transpose

Convert

Bring to Front

Send to Back

Send to Front

Forward One

Sorting

Inserting

Filtering

Deleting

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

Mathematical

Financial

Statistical, logical

All of these

8

12

14

10

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

Open Find dialog box

Open Find & Replace dialog box

Font dialog box

Format dialog box

7,2

7+2

9

5,7

11

12

13

10

OpenDocument

Microsoft Excel

PDF

All the above

1024

1048576

16384

None

1048576 Rows & 1024 Columns

1048576 Rows & 16384 Columns

16384 Rows & 1048576 Columns

1024 Rows & 1048576 Columns

1

2

3

4

8

10

12

14

.ods

.xls

.odx

.txt

Function

Formula

Graph

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

1024 rows and 1048576 columns

10000 rows and 32000 columns

1,048,576 rows and 16,384 columns

None of above

Date

Formula

Cell Value

All the above

10

0

5

15

15

3

4

5

.odt

.ods

.odp

.xlsx

Ctrl + +

Ctrl + -

Ctrl + D

Delete

###

The cell size increase automatically

####

#Name?

#name?

#name

Whatever is written in a formula will remain the same

####

.ods

.odt

.ott

.odf

Lock Cells

Freeze Panes

Split Sheet

Protect Sheet

511

508

510

509

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

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

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

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

Bar Chart

Column Chart

Pie Chart

Line Chart

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