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!
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.
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 4.5%, and the value in cell C4 to 15%. what is value in cell H25? 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%, what is value in cell H7? Format your answer to 2 decimal places.
Write the answer in the box.
In Items sheet, calculate the Total After Discount for all items. Total After Discount = Total Amount - Discount Amount. Format all Total After Discount amounts to have 2 decimal places. Make sure the Discount % in cell C3 to 6.5%, what is value in cell G30?
Write the answer in the box.
In Items sheet, calculate the Total After Discount for all items. Total After Discount = Total Amount - Discount Amount. Format all Price After Discount amounts to have one decimal place. Make sure the Discount % in cell C3 to 6.5%, what is value in cell G14?
Write the answer in the box.