Working in Open Office Calc

Which these is not the part of Open Office Calc?

• Rows and Column

• Text Color

• New Slide

• New Sheet

• Auto Sum

How many rows does Open Office contains?

• 1024456

• 1045678

• 1048675

• 1048576

Answer these Questions

i) How many columns does the Open Office Contains?

ii) What the name of the last column address?

• i) 1024 ii) AMJ

• i) 1045 ii) ZZZ

• i) 2348 ii) XRT

• i) 5436 ii) JBN

=$B$4 * $C$4

It is an example of :

• Mixed Referencing

• Absolute Referencing

• Relative Referencing

• Formula Referencing

Mary and Lily wrote some numbers. They wanted to add the numbers but they wanted that the numbers horizontally. But they wanted that the numbers in Lily's rows have to be added only with the number in A2 (23). So what will be the shortest trick?

• There's no short trick.

• She can select and press Ctrl+X and paste it in evry cell in SUM row

• She will first use the formula A$2 + B2, press Enter then she can copy the result and select other areas where she want the and then Ctrl+V

• She will first use the formula=A$2 + B2, press Enter then she can copy the result and select other areas where she want the and then Ctrl+V

While doing calculation, I used $A2 / B2.

I copy pasted it to copy this formula but:

• The row did not change

• The column did not change

• Both column and row did not change

• Both column and row changed

Maya put the formula ' C3+D3' and then pressed Enter key. She saw that the formula did not occur. What did she miss out?

• She needed to press Enter key 2 times.

• She needed to press Caps Lock key

• She needed to apply '=' sign at the beginning of the formula

• She needed to first Copy and Paste the data in a new sheet and then press Enter.

The Insert Menu helps to:

• Insert elements such as rows, columns, sheets and pictures etc

• To save, open or print the sheet etc

• To Zoom in or out, Full screen etc

• None of these

There are total ___ default sheets in OO Calc.

• 4

• 2

• 1

• 3

The option for Zoom in or out is located in

• Status Bar

• View Menu

• Formula Bar

• Both (a) and(b)