Answer and Explanation:
Given that total number of records in a file = 100000
Each record consists of= 240 bytes
Given that B= 2400 bytes.
Then total blocks in file = 100000 records * 240 / 2400
= 10000 blocks.
Time that will take for exhaustive read
= s + r + b.btt
= 16 + 8.3 + (10000) * 0.8
= 8024.3 msec
Now as per given X be the number of records that are searched randomly and it takes more than exhaustive read time.
Hence, X (s + r + btt) > 8024.3
X (16+8.3+0.8) > 8024.3
X > 8024.3/25.1
So that, X > 319.69
Hence, atleast 320 random reads should be made to search the file
Answer:
false
Explanation:
because a lot of times they are downloads without the disk
Answer:
The answer is : When there is a need to copy a formula and have the references update based on the new location
Explanation:
<em>I often use this function in any spreadsheet document. Imagine, you have thousands of data in a single sheet. And you inserted one row or column. Normally, you have to update EACH CELL's formula. Imagine the work load and the effort you need to exert. But when the single cell updates all the cell's reference, formula will be affected and you don't need to re update all the cells. It saves you time and effort and worries.</em>
Answer:
Explanation:
Click the Data option.
Click on Named Range. This will open the 'Named ranges' pane on the right.
Click on the 'Add a range' option.
Enter the name you want to give the column (“Sales” in this example)
Make sure the column range is correct. ...
Click on Done.
