Question

(a) (i) What is the option used to adjust the text within a cell ?

(ii) Give the procedure to use this option. 

(b) What is a unique key ?

(c) State any two types of data based structures.

(d) What is meant by a cell in a spreadsheet ?

(e) State the steps involved in merging two cells in a spreadsheet.

Answer 1

(a) (i) Wrap text 

(ii) (a) Right click the cell in which text is to be wrapped. 

(b) Click Format Cells option. 

(c) In Format Cells dialog box. click Alignment tab. 

(d) Click Wrap text check box. 

(e) Click OK.

(b) A unique key is a set of one or more than one fields of a table that uniquely identify a record in a database table. It can accept only one null value and it cannot have duplicate values.

(c) Relational database. Network database.

(d) A cell in a spreadsheet is an intersection of a column and row. It is represented by a combination of letter and numeral. 

For example B5 means, that the pointer is in column B and row number five.

(e) (i) Select the cells which are to be merged. 

(ii) Right click on the selected cells. 

(iii) Click Format Cells option. 

(iv) In Format Cells dialog box, click Alignment tab. 

(v) Click Merge cells check box. 

(vi) Click OK.