Question

There are 'n' number of sheets in a spread
er of sheets in a spreadsheet.
ange the column width and
4. In a spreadsheet, we can change the
row height
5. $A$B2 is an example of mixed referenci
D. Solve the following in a spreadsheet
1. Cell Al contains the number 10 and
will be the contents of cell Cl, if the formula
is entered in cell Cl?
number 10 and Bl contains 5. What
if the formula =A1+B1*243
and D1 are 5, -25, 30 and
2. The contents of Cell Al, B1, C1 and D1 are 5
-35, respectively. What will be the value displaved
El which contains the formula =MIN(A1:01).
$B$5+C5 and this formula
is copied to cell E5, what will be the copied formula
E5?
4. Cell D5 contains the formula =$B5 + C5 and this for
copied to cell E5, what will be the copied formula in
WELLLLLLLLLLLLL111111
5. Cell D5 contains the formula =$B5+ C$5 and this
is copied to cell E6, what will be the copied formula in cell
E6?
NUGA
E. Short answer questions (50 words)
1. What do you call the document created in a spreadsheet
application?
2. What are the steps to create a new spreadsheet?
3. What is the difference between spreadsheet, worksheet
and sheet?
4. What is the default name of the worksheet? How can it be
renamed?
5. Write the steps to insert and delete the worksheet in Calc,
6. What is an active cell? How to delete the contents of an
active cell?
7. What is relative and absolute cell address in the
spreadsheet?
8. Explain any two operations performed on data in a
spreadsheet.
9. How do formulae work in a spreadsheet?
10. Can you include more than one mathematical​

Answer 1

Answer:

wht is relative and absolute cell adress in the spreadsheet?

if u want to use the valueof a cell in a formula in another cell of spreadsheet then u refer to this cell by means of its cell adress this cell address is consists of a no. coloumn indicator and a row no. eg D14 is the cell in the colounm D,row14

Answer 2

Answer:

False there is 1 by default