AP5307 - Information Technology
Шукаєте відповіді та рішення тестів для AP5307 - Information Technology? Перегляньте нашу велику колекцію перевірених відповідей для AP5307 - Information Technology в moodle.polytechnic.bh.
Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!
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.
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.5% . Change the value of VAT% to 12%, what is the Net Amount of Tablet PC? Format your answer to one decimal place.
Write the answer in the box.
In Items sheet, calculate the Net Amount for all items. Net Amount = Total After Discount + VAT Amount. Make sure the Discount % in cell C3 to 5.5% and VAT% in cell C4 is 10%. what is value in cell I16? Format your answer to 3 decimal places.
Write the answer in the box.
In Items sheet, calculate the VAT Amount for all items by multiplying the Total After Discount by the value in cell C4. Change the value in cell C3 to 5.5% and the value in cell C4 to 15%, what is lowest VAT Amount in cells H7:H30? Format your answer to 1 decimal place.
Write the answer in the box.
In Items sheet, calculate the VAT Amount for all items by multiplying the Total After Discount by the value in cell C4. Change the value in cell C3 to 5.5% and the value in cell C4 to 15%, what is highest VAT Amount in cells H7:H30? Format your answer to 3 decimal places.
Write the answer in the box.
In Items sheet, calculate the VAT Amount for all items by multiplying the Total After Discount by the value in cell C4. Change the value in cell C3 to 9.5% and the value in cell C4 to 10%, what is average of all VAT Amounts in cells H7:H30? Format your answer to one decimal place.
Write the answer in the box.
In Items sheet, calculate the VAT Amount for all items by multiplying the Total After Discount by the value in cell C4. Change the value in cell C3 to 5.5% and the value in cell C4 to 10%, what is sum of all VAT Amounts in cells H7:H30? Format your answer to 2 decimal places.
Write the answer in the box.
Хочете миттєвий доступ до всіх перевірених відповідей на moodle.polytechnic.bh?
Отримайте необмежений доступ до відповідей на екзаменаційні питання - встановіть розширення Crowdly зараз!