Answer:
The data transmission time will be 8 seconds (8.0s)
Explanation:
Using the formular:
T =A/S
T=Time = ?
Amount of Data = A = 2GByte
Speed = S = 2Gbps
The units of A and S are different
A is expressed in Bytes(B)
S is expressed in bits(b)
But :
1 Byte(B) = 8 bits(b)
T = A/S = 2GB/2Gb
since 1 Byte = 8 bits
T = 2 × G ×( B =8bits) / 2 × G × b
T = 2 × G × 8b / 2 × G × b
T = 2 × G × 8 × b / 2 × G × b
The common terms(2,G,b) cancel out
T = 8 seconds
Answer: positive = plus sign and negativie = subraction sign
Explanation:
Area recreation centers. Large open area plenty of space
To compare the data Jason can use inbuilt function such as VLOOKUP, HLOOKUP.
<u>Explanation:</u>
Since Jason is working MS-excel spreadsheet. As he has mention cell A1 to C9 is official budget and related are stored in L1 – N19.
In MS- EXCEL has lot of inbuilt function are available such as VLOOKUP, HLOOKUP, and IF extra.
VLOOKUP: It is a inbuilt function where to use to find cell value in ranges of selected with column index. It searches value in vertical manner in ranged selected cells.
HLOOKUP: It is a inbuilt function where to use to find cell value in ranges of selected with column index. It searches value in horizontal manner in ranged selected cells.
IF: returns trued value if searched value found. It compares one to one cell values.