Ctrl + 4

Ctrl + 3

Ctrl + 2

Ctrl + 1

7,2

7+2

9

5,7

35

-35

12

2

#name?

#name

Whatever is written in a formula will remain the same

####

Title bar

Standard Toolbar

Formatting Toolbar

Formula Bar

OpenDocument

Microsoft Excel

PDF

All the above

1199

1210

1188

None

do calculations

create graphics

plot graphs

plot charts

Data

Text

Mathematical

String

AutoFilter

Advanced Filter

Standard

Sorting

AutoFilter

Conditional formatting

Pivot tables

Data validation

Calc

Base

Writer

Impress

Spreadsheet

Double sheet

Multi-sheet

Cannot determine

Ctrl + ]

Alt +D

Ctrl + ;

Shift + K

Format

Style

Sheet

Edit

Shift+F7

CTRL+F7

Shift+F9

CTRL+F9

B1&B5

B1*B5

B1#B5

B1:B5

1

15

56

-1

-5

5

25

50

Flipping a selection convert it into a floating selection

Flip Horizontal flip the left side to the right side

Flip Horizontal flips the right to the left side

Flip vertical flips the top to the bottom

.ods

.xls

.odx

.txt

Type Monday, hold down right corner and pull down

Do inter press by writing monday

= week () uses the function

All of the above

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

Media Playback

3D settings

Painting

Drawing

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

Ctrl + Shift + 1

Ctrl + Shift + 5

Ctrl + Shift + 4

Ctrl + Shift + 3

Print View

Print Preview

Print Screen

Print Document

Letter

Fax

Agenda

E-mail

File name

Location where the file is to be saved

Both A and B

None of these

Two

Three

Four

Five

Relative address

Absolute address

Mixed address

Dynamic address

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

Data Series

Chart Series

Chart Elements

Chat type

Column

Value

Address

Cell

Insert

Data

Tools

View

7

10

3

1

Data formatting

Data sorting

Data filtering

Data validation

To create charts and graphs

To format cells

To perform calculations and manipulate data

To insert images

Find and replace

By Copy only

By copy command

By preview command

Nested Function

Function

General Function

Condition Function

Edited

Shown

Deleted

All the above

Horizontal

Vertical

Both A and B

None of These

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

Chart Title

Data Label

Chart Area

Chart Line

Cell

Tabel

Position

Data

Shift + F3

Ctrl + F2

Ctrl + F3

Alt + F3

Center

Split Cells

Split and merge

Merge and center

Ctrl+Shift+V

Ctrl+V

Ctrl+C

Strl+Shift+S

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

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