Libre Office Calc. class 7

The cell address in a formula is also called______________.

A formula always begins with a_________ sign.

• !

• #

• +

• =

A cell address in a formula that does not change on copying is considered as:

• Mixed reference

• Absolute Reference

• Relative Reference

A cell address in a formula that changes on copying is considered as:

• Mixed reference

• Absolute Reference

• Relative Reference

To use another sheet reference, you need to enter the sheet number,____ and cell adresss.

• !

• .

• @

The last column is labeled as ______

• AMJ

• XJC

• AMK

File extension for calc doc is ____________

• .odp

• .xls

• .ods

• .odt

Row header is identified by ______________

• a. Numbers

• b. Alphabets

• c. Symbols

• d. Both numbers and alphabets

The small black square in the bottom-right corner of

the selected cell or range is called a ___________

• fill mode

• fill up

• auto fill

• fill handle

A ______ is a grid of cells made up of rows and olumns