logo

Crowdly

Browser

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!

15. When creating a new slide in PowerPoint, Nomsa selects an option that provides a title box at the top and a content placeholder in the middle. What feature is she using?
0%
0%
0%
100%
0%
View this question
11. While designing her presentation in PowerPoint, Surika uses the Ribbon to insert charts, the Slides Pane to view thumbnails, and the Notes Pane to add speaker notes. All these belong to which feature of PowerPoint?
0%
0%
0%
0%
0%
View this question
13. Naledi wants bullet points on her slide to appear one by one as she clicks, instead of showing all at once. Which feature should she use?
100%
0%
0%
0%
0%
View this question
12. A lecturer notices that the font style across her 50-slide presentation looks inconsistent. Instead of fixing each slide individually, she applies changes once and it reflects everywhere. Which feature did the lecturer use?
0%
0%
0%
0%
0%
View this question
8. Which of the following is NOT true regarding macros in Excel?
0%
0%
0%
0%
0%
View this question
10. Jane uses scenario manager in Excel to view the different scenarios of her monthly budget. When creating the scenario below, Income and Food were set as the Changing cells value for a single scenario. Mathematical calculations were used to calculate the Total Expenses and Income Left. Which of the following values will change each time a new scenario is displayed?

BAQ10

0%
0%
0%
0%
100%
View this question
7. The screenshot below displays a/n ________ message.

BAQ7

100%
0%
0%
0%
0%
View this question
9. In Excel, which feature would you use to find out where a formula gets its data?
0%
100%
0%
0%
0%
View this question
6. In Excel, what is the purpose of the “𝜮 Values" section in a pivot table?
0%
0%
100%
0%
0%
View this question
5. 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 would be displayed in cell G9 if the manager entered the formula =VLOOKUP(B3; $H$2:$I$8; 0; TRUE)?
0%
0%
0%
0%
0%
View this question

Want instant access to all verified answers on learn2025.ukzn.ac.za?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Browser

Add to Chrome

TelegramInstagramTikTokQuestion Bank
Terms of UseContact Us