Below is part of a spreadsheet, which contains data about the sales of sandwiches in Hilltop High School.

Answer the following questions (i) to (iv) based on above spreadsheet :

(i) List two ways in which the cells in the first row have been formatted.

(ii) Can you predict after looking at above worksheet whether the values shown in range B4:F15 have default alignment or a different one given through Formatting ?

(iii) What option/setting has been chosen for B3:F3 that they are able to display multi-line text in these cells ?

(iv) What command has facilitated the setting of previous question i.e., multi-line text ?

(i) Two ways in which the cells in the first row have been formatted are:

1. The cells B2, C2 and D2 are merged.
2. The text has been made bold and in uppercase.

(ii) The values shown in range B4:F15 have default alignment as the numbers are right aligned by default.

(iii) To display multi-line text in cells, we can select the cells and right click on the selection and select Format Cells option. From the Format cells window, select Alignment tab and select on 'Wrap Text automatically' property and click OK.

(iv) The command 'Wrap Text Automatically' has facilitated the setting of multi-line text.