Crowdly
Add to Chrome
AP5307 - Information Technology
Looking for AP5307 - Information Technology test answers and solutions? Browse our comprehensive collection of verified answers for AP5307 - Information Technology at moodle.polytechnic.bh.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
What is wrong in the following table array in VLOOKUP function?
| Temperature | Status |
| 100 | Boiling |
| 70 | Hot |
| 25 | Room Temperature |
| 0 | Freezing |
If the table below is the table array for VLOOKUP function, what is the Column index number if you want to get the Address? Write your answer in the answer box.
| CPR Number | Name | Contact Number | Address | Date of Birth |
We have to write "True" in Range Lookup filed in VLOOKUP function if we want to search for exact match such as names.
Look value in VLOOKUP function is
In Frequency sheet, the frequency table with unique values is available. Use frequency function in cell Q4 to get frequency for each value in the range B2:M61. What is the frequency of the value 48?
Write your answer in the box.
In Frequency sheet, the frequency table with unique values is available. Use frequency function in cell Q4 to get frequency for each value in the range B2:M61. What is the value in cell Q19?
Write your answer in the box.
In Frequency sheet, the frequency table with unique values is available. Use frequency function in cell Q4 to get frequency for each value in the range B2:M61. What is the frequency of the value 8?
Write your answer in the box.
In Items sheet, Write "Required Qty" in cell J6. Use if function in cell J7 to test the Quantity value according to the table below:
| Condition | Result for Required Qty |
| Quantity < 5 | 15 |
| Quantity < 10 | 10 |
| Quantity < 20 | 5 |
| Anything else | 0 |
Copy the function to cells J8:J30. What is the total Require Qty for all items.
.
Write the answer in the box.
In Items sheet, use if function for the value of Discount% in cell C3 to check the value of VAT% in C4. If VAT% is greater than or equal to 10%, then the Discount% will be 10%; otherwise, the Discount% will be 6.5% . Change the value of VAT% to 15%, what is the Net Amount of Pen Tablet? Format your answer to no decimal places.
Write the answer in the box.
In Items sheet, use if function for the value of Discount% in cell C3 to check the value of VAT% in C4. If VAT% is greater than 10%, then the Discount% will be 15%; otherwise, the Discount% will be 5% . Change the value of VAT% to 10%, what is the Net Amount of the Hard Disk Drive? Format your answer to 3 decimal places.