Crowdly
Додати до Chrome
AP5307 - Information Technology
Шукаєте відповіді та рішення тестів для AP5307 - Information Technology? Перегляньте нашу велику колекцію перевірених відповідей для AP5307 - Information Technology в moodle.polytechnic.bh.
Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!
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.