Which task is not possible with VLOOKUP?
2 answers:
You might be interested in
Answer:
See explaination
Explanation:
a)
The primary factors that influence the program's speed on a new CPU are given as:-
CPU Clock speed where the speed of the process instructions is being measured.
Multi-core which is when the transistors work faster than respective CPU.
Cache which helps to note that the transition of data is smooth and fast.
b)
So, there are two CPUs suppose the old one as 'A' and the modified one as 'B'.
'A' has following features---
It takes more time to execute program as it has more clock cycle time or we can say it has low clocking rate or low speed in terms of MHz or GHz. Clock rate is the inverse of Clock Cycle Time. When you will increase the clocking rate of CPU, it will get faster and then Clock Cycle Time will get reduced.
It has less instructions provided.
'B' has following features----
It takes less time to execute program as it has less clock cycle time or we can say it has high clocking rate or high speed in terms of MHz or GHz.
It has more instructions provided.
The performance of CPU depends upon 2 factors:
The number and types of instructions that are executed by the CPU
How fast the CPU can execute those instructions?
So, overall CPU B is better as it has less execution time than CPU A but the performance will always depend upon the number and type of instructions executed by the CPU so it may vary.
Please refer to attachment for instructions and formulas.
