Answer:
Use autofill
Explanation:
In excel "autofill" is used to fill data in cells, which follows the pattern or logic applied in other cells. To apply same calculation of A20 in B20 to H20, we use autofill technique. Instead of copy pasting, or manually entering the complex formula this method is more suitable.
IF function has three parts
IF (condition_to_check , return_if_true , return_if_false)
IF function first checks condition. If it is true it returns first result. Otherwise it returns second result.
Condition to check:
B3>D5
After inserting numbers we get:
10>8
This is correct so the first result will be returned.
The given IF function returns "Closed".
Use ctrl + or - or if in microsoft word, use the zoom tool
Answer: Class 10 refers to the read write speed of a memory card
Explanation:
Answer:
Throughput of X, Y, Z will be 0.081
The network throughput will be 0.243
Explanation:
Throughput of X will be Tx = Px*(1-Py)*(1-Pz)=0.1*0.9*0.9=0.081
Throughput for Y and Z can be calculated in same way.
Throughput of network = Tx+Ty+Tz=0.081+0.081+0.081=0.243