Use the provided worksheet to calculate the balance of BREAD, count items in stock greater than 20, identify two label data types, and name four database field data types and two ways to represent pos

here are the solutions to the questions.

10. (c) The figure below shows a worksheet containing information a shopkeeper records on his sales use it to answer the questions that follow.

i) Write a formula to calculate the balance of BREAD.
The balance for BREAD is calculated by subtracting "ITEMS SOLD" (cell C4) from "ITEMS IN STOCK" (cell B4).

$$\boxed{=B4-C4}$$

ii) Write a function to display the number of items in stock greater than 20.
To count items in stock (column B) that are greater than 20, the COUNTIF function is used. The range for "ITEMS IN STOCK" is B2 to B5.

$$\boxed{=COUNTIF(B2:B5,">20")}$$

iii) Give two cells that contain label data type in the above worksheet.
Label data type refers to text entries.

• A2 (RICE)
• A3 (TEA LEAVES)

10. (d) Name four field data types used in database table design.

• Text (or String/Varchar)
• Number (or Integer/Decimal)
• Date/Time
• Boolean (or Yes/No)

19. (a) Describe two ways in which a positive number and a negative number can be represented in a computer.

• Signed Magnitude: In this method, the leftmost bit (most significant bit) is used to represent the sign of the number (0 for positive, 1 for negative), while the remaining bits represent the magnitude (absolute value) of the number.
• Two's Complement: This is the most common method. Positive numbers are represented in their standard binary form. Negative numbers are represented by taking the binary representation of their positive counterpart, inverting all the bits (one's complement), and then adding 1 to the result.

19. (b) Describe the octal number system.
The octal number system is a base-8 number system, meaning it uses eight distinct digits: 0, 1, 2, 3, 4, 5, 6, and 7. Each position in an octal number represents a power of 8. It is often used in computing as a compact way to represent binary numbers, as three binary digits (bits) can be directly converted to one octal digit.