logo

Crowdly

Browser

Додати до Chrome

MC 2025 ISTN103 - Development and Application Fundamentals P/W 2

Шукаєте відповіді та рішення тестів для MC 2025 ISTN103 - Development and Application Fundamentals P/W 2? Перегляньте нашу велику колекцію перевірених відповідей для MC 2025 ISTN103 - Development and Application Fundamentals P/W 2 в learn2025.ukzn.ac.za.

Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!

4. 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 D2 that 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 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.

BAQuestion1

What is the correct syntax for the formula that should be entered in cell D7 to display the discount for the quantity sold listed in that row?
0%
0%
0%
0%
0%
Переглянути це питання
2. 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 D2 that 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 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.

BAQuestion1

What formula was entered into cell E2 and auto-filled down to cell E8 to display the delivery cost for the area?
0%
0%
0%
0%
100%
Переглянути це питання
3. 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 D2 that 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 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.

BAQuestion1

What is the correct syntax for the formula that should be entered in cell E5 to display the delivery cost for the area listed in that row?
0%
0%
0%
0%
0%
Переглянути це питання

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 D2

that 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

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.

BAQuestion1

Which formula was entered into cell D2 and auto-filled down to cell D8 to display the discount for the quantity sold?

0%
0%
0%
0%
0%
Переглянути це питання

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 _______.

11

0%
0%
0%
0%
0%
Переглянути це питання

In this DFD diagram, how many different information sinks are there?

12

0%
0%
0%
0%
0%
Переглянути це питання

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?

10

0%
0%
100%
0%
0%
Переглянути це питання

In Agile development, a Scrum Master primarily _________.

0%
0%
0%
0%
100%
Переглянути це питання

In the table ACCT_HOLDER shown below, “Password” is an example of a/an _________.

Q6

100%
0%
0%
0%
0%
Переглянути це питання

Which of the following would be an example of a specific instance of the entity "STUDENT"?

0%
0%
0%
0%
0%
Переглянути це питання

Хочете миттєвий доступ до всіх перевірених відповідей на learn2025.ukzn.ac.za?

Отримайте необмежений доступ до відповідей на екзаменаційні питання - встановіть розширення Crowdly зараз!

Browser

Додати до Chrome