(a) What is meant by each of the following terms as used in table creation? (i) cell margin; (ii) nested table. (b) State four types of text wrap that can be applied to a graphic. (c) Distinguish between each of the following: (i) axis labels and data

What is meant by each of the following terms as used in table creation?

4/1/2021

What is meant by each of the following terms as used in table creation?

(a) What is meant by each of the following terms as used in table creation?
(i) cell margin;
(ii) nested table.
(b) State four types of text wrap that can be applied to a graphic.
(c) Distinguish between each of the following:
(i) axis labels and data labels;
(ii) cropping and sizing.
(d) Figure 1 shows a section of a worksheet containing information on household items.
Use it to answer the questions that follow.

(i) Write a formula to calculate the total cost of rice.
(ii) The prices of all items increased by 10% and the value 10% is placed in cell B8. Using cell addresses with absolute referencing only, write a formula to calculate the new unit price of salt.
(iii) Write a function to display the number of cells in which the cost per unit is equal to 110.
(iv) Write a function to display the least total cost for all items.

(a) (i) Cell margin: Its the space between the boundary of the cell and the text/content inside the cell.
(ii) Nested table: is a table created inside another table.
(b) In line with text.

Square
Behind text.
Infront of text.
Tight.
Through.
Top and bottom.
None.
Solution
(c) (i) Axis label: Data corresponding to the vertical or horizontal lines of a given chart whereas the x-axis and y-axis.
Data label: are data that provide additional information about a data marker which represents a single data point on a value that originates from a worksheet cell. .

(ii) Cropping is the process of trimming/cutting/hiding vertical or horizontal edges of an object/picture while sizing is the process of enlarging/expanding or reducing/contracting an object/picture to appropriate dimension.