Crowdly
Add to Chrome
MC 2025 ISTN103 - Development and Application Fundamentals P/W 2
Looking for MC 2025 ISTN103 - Development and Application Fundamentals P/W 2 test answers and solutions? Browse our comprehensive collection of verified answers for MC 2025 ISTN103 - Development and Application Fundamentals P/W 2 at learn2025.ukzn.ac.za.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
The retail company also tracks delivery costs for each sales area. A reference table (rows 11 and 12) lists the areas and their corresponding delivery costs. To automate the calculation, the sales manager wants Excel to fetch the correct delivery cost for each transaction based on the area in column A. To achieve this, the manager enters a formula in cell E2 and then auto-fills it down to cell E8.
The retail company also tracks delivery costs for each sales area. A reference table (rows 11 and 12) lists the areas and their corresponding delivery costs. To automate the calculation, the sales manager wants Excel to fetch the correct delivery cost for each transaction based on the area in column A. To achieve this, the manager enters a formula in cell E2 and then auto-fills it down to cell E8.
The retail company also tracks delivery costs for each sales area. A reference table (rows 11 and 12) lists the areas and their corresponding delivery costs. To automate the calculation, the sales manager wants Excel to fetch the correct delivery cost for each transaction based on the area in column A. To achieve this, the manager enters a formula in cell E2 and then auto-fills it down to cell E8.
1. A retail company is
analysing its sales data using Excel. A sample of the sales data is shown in
the screenshot below. The sales manager wants to automatically calculate the
discount
percentage
for each transaction based on the quantity of items sold.
The discount rules are stored in a lookup table (columns H and I), where
different quantity ranges correspond to different discount percentages. To
achieve this, the manager enters a formula in
cell D2that looks up the
quantity sold in column B against the discount table in columns H and I, and
then auto-fills the formula down to D8.
The retail company also tracks for each sales area. A reference table (rows 11 and 12) lists the . To automate the calculation, the sales manager wants Excel to fetch the correct delivery cost for each transaction based on the . To achieve this, the manager enters a formula in and then auto-fills it down to
Which formula was entered into cell D2 and auto-filled down to cell D8 to display the discount for the quantity sold?
A patient phones a doctor’s practice to make an appointment to see the doctor. They give their details and the preferred appointment date/time to the receptionist, who confirms the appointment. Two days before the appointment, a reminder WhatsApp message is sent to the patient. From time to time, the doctor enters his/her available times into the system. Every day, the doctor asks the receptionist for the day’s list of appointments. The receptionist gives the doctor the list of appointments for that day.
The label which should replace circle 1 is _______.
In this DFD diagram, how many different information sinks are there?
A patient phones a doctor’s practice to make an appointment to see the doctor. They give their details and the preferred appointment date/time to the receptionist, who confirms the appointment. Two days before the appointment, a reminder WhatsApp message is sent to the patient. From time to time, the doctor enters his/her available times into the system. Every day, the doctor asks the receptionist for the day’s list of appointments. The receptionist gives the doctor the list of appointments for that day.
How many errors do you see on the context level diagram below?
In Agile development, a Scrum Master primarily _________.
In the table ACCT_HOLDER shown below, “Password” is an example of a/an _________.
Which of the following would be an example of a specific instance of the entity "STUDENT"?