WorksheetsWorking in Open Office Calc
Total questions: 10
Worksheet time: 6mins
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)
