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.
​​Related Searches on spreadsheets, word processors, Form 2 Level
0 Comments
Leave a Reply. |
Categories
All
Archives
December 2024
|