The scripter as he made the script.
Answer:
For 32 bits Instruction Format:
OPCODE DR SR1 SR2 Unused bits
a) Minimum number of bits required to represent the OPCODE = 3 bits
There are 8 opcodes. Patterns required for these opcodes must be unique. For this purpose, take log base 2 of 8 and then ceil the result.
Ceil (log2 (8)) = 3
b) Minimum number of bits For Destination Register(DR) = 4 bits
There are 10 registers. For unique register values take log base 2 of 10 and then ceil the value. 4 bits are required for each register. Hence, DR, SR1 and SR2 all require 12 bits in all.
Ceil (log2 (10)) = 4
c) Maximum number of UNUSED bits in Instruction encoding = 17 bits
Total number of bits used = bits used for registers + bits used for OPCODE
= 12 + 3 = 15
Total number of bits for instruction format = 32
Maximum No. of Unused bits = 32 – 15 = 17 bits
OPCODE DR SR1 SR2 Unused bits
3 bits 4 bits 4 bits 4 bits 17 bits
Answer:
50%
Explanation:
The markup is the difference between the selling price and the cost price. If the mark up is greater than zero, it means there is a profit, if the markup is less than 0, it means there is a loss and if the markup is equal to 0, it means there is breakeven.
Percentage markup = (markup/cost price) * 100%
Selling price - cost price = markup
15 - cost price = 5
cost price = 10
Percentage markup = (markup/cost price) * 100% = (5/10) * 100% = 50%
I'd suggest he uses
LOOKUP Function.
You can use the LOOKUP function when you need to look in a
single column or row and find a value from the same position in a corresponding
column or row. We have a much improved VLOOKUP that can also be used to search
one row or column or multiple rows and columns.