Provide solutions for the following: i) A formula to count items with unit price > 10,000. ii) Output of a copied formula. iii) Diagram of CPU functional units.

Here are the solutions to the questions:

i) Write a formula that will compute the number of items whose unit price is more than 10,000
Assuming the unit prices are in column B, starting from cell B2:

The formula is $\boxed{\text{=COUNTIF(B:B, ">10000")}}$.

ii) If the formula =$B2*C$2 was placed in cell D2, state the output if it was copied to D3
When the formula =$B2*C$2 from cell D2 is copied to cell D3:

• $B2 changes to $B3 because the column B is absolute, but the row 2 is relative and increments to 3.
• C$2 remains C$2 because the column C is relative (but the column doesn't change from D to D), and the row 2 is absolute. Therefore, the formula in cell D3 will be \boxed{\text{=B3*C2}}.

c) With an Aid of a diagram, describe the functional units of the Central Processing Unit

A Central Processing Unit (CPU) consists of three main functional units:

+---------------------------------------------------+
|                       CPU                         |
|  +-----------------+   +-----------------------+  |
|  |                 |   |                       |  |
|  |   Control Unit  |<->|   Arithmetic Logic    |  |
|  |      (CU)       |   |      Unit (ALU)       |  |
|  |                 |   |                       |  |
|  +-----------------+   +-----------------------+  |
|           ^                       ^               |
|           |                       |               |
|           +-----------------------+               |
|                   Registers                       |
+---------------------------------------------------+

• Control Unit (CU): This unit is responsible for managing and coordinating the operations of the CPU. It fetches instructions from memory, decodes them, and then directs the other units to perform the necessary tasks. It controls the flow of data within the CPU and between the CPU and other components.
• Arithmetic Logic Unit (ALU): The ALU performs all arithmetic operations (like addition, subtraction, multiplication, division) and logical operations (like AND, OR, NOT, comparisons). It is the computational core of the CPU.
• Registers: These are small, high-speed storage locations within the CPU that hold data temporarily during processing. They are used to store instructions, addresses, and data that the CPU is currently working with, providing quick access to frequently used information.