Allen needs to calculate how much his investment has increased over the past year. He enters the original amount in cell B3 and
the new amount in cell B4. He typed in the formula: =B3-B4. He estimated his answer to be 500 and the answer is not close. He should _____.
add the values in B3 and B4
ignore his estimation
multiply the values in B3 by B4
change the formula to =B4-B3
add the values in B3 and B4
ignore his estimation
multiply the values in B3 by B4
change the formula to =B4-B3
1 answer:
<h2>Answer:</h2>
You need to change the formula to =B4-B3 this will calculate the right value.
<h2>Explanation:</h2>The value stored in B3 is the original amount and new increased amount is stored in B4 which is larger than B3 value so the formula need to change to subtract large value from small to get the value how much his investment is increased.
Difference = Increased investment - Previous Investment
Following are attached images of excel that will make the concept more clearer:
You might be interested in
<u>The different between 32 bit and 64 bit version:</u>
- The main difference between 32-bit and 64-bit versions is that a 32-bit version can access
memory addresses which is roughly equivalent to 4 GB of memory.
- On the other hand, a 64-bit version can access
memory addresses which equates to a huge amount of memory, 16 exabytes to be precise.
- Nowadays, we observe that almost all the computers have 64-bit processors, which means that they can access any amount of memory over 4 GB till 16 exabytes.
- 64-bit processors have various advantages like the increased speed of operations, smooth multitasking and they can also support video games and software's that have high graphical requirements.