Information systems / Inligtingstelsels - 112
Looking for Information systems / Inligtingstelsels - 112 test answers and solutions? Browse our comprehensive collection of verified answers for Information systems / Inligtingstelsels - 112 at emslearn.sun.ac.za.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
Complete the formula entered in cell K2:
=((D2,),MID(,,2),(B2),RIGHT(,2)
Complete the formula entered in cell M2:
=CONCATENATE(,(J2:J50))
Match the text function actual value with its display value:
Pas die werklike waarde van die teksfunksie by die vertoonwaarde daarvan:
Voltooi VL_4 en beantwoord die volgende vrae:
Voer ʼn formule in kolom K in wat die verskil bereken tussen die gewone verkoopsprys en die verkoopsprys na afslag. Die verskil verteenwoordig dus die korting.
Verskaf die voorraadkode (kolom A) en korting bedrag (kolom K) van die item wat in randwaarde die hoogste korting verteenwoordig. Die antwoord moet sente insluit en Rand teken uitsluit.
|
Complete VL_4 and answer the following question:
Enter a formula in column K that will calculate the difference in the normal selling price and the discounted selling price. The difference represents therefore the discount.
Supply the inventory code (column A) and discount amount (column k) of the item that has the highest discount value in rand terms. The answer should include cents and exclude a Rand sign.
|
Kode / Code:
Korting / Discount:
|
Voltooi VL_3 en beantwoord die volgende vraag:
Voltooi die formule wat in sel M24 ingevoer is:
|
Complete VL_3 and answer the following question:
Complete the formula that is entered in cell M24.
|
=VLOOKUP( , ,2, )
|
Voltooi VL_2 en beantwoord die volgende vraag:
Verskaf die afvoer wat in sel A7 sal vertoon indien dieVLOOKUP formule toegepas is op R1 212 se verkope. Moenie die % teken insluit in u antwoord nie.
|
Complete VL_2 and answer the following question:
Supply the output that will be displayed in cell A7 if the VLOOKUP formula is applied on sales of R1 212. Don’t include the % sign in your answer.
|
|
Voltooi VL_1 en beantwoord die volgende vraag:
Verskaf die afvoer wat in sel F13 sal vertoon indien die vlookup formule toegepas is. Moenie die R teken insluit in u antwoord nie.
|
Complete VL_1 and answer the following question:
Supply the output that will be displayed in cell F13 if the vlookup formula is applied. Don’t include the R sign in your answer.
|
|
Hierdie vraag het betrekking op werksblad DB_10:
Wat is die gemiddelde waarde van selle M2:M107 nadat u Vraag 13 van die tutoriaal voltooi het? Rond u antwoord af tot twee desimale. Verskaf slegs die numeriese waarde sonder enige R-teken of spasies en gebruik 'n punt om Rand en Sent van mekaar te skei, bv. 123.45
This question relates to worksheet DB_10:
What is the average value of cells M2:M107 after you have completed Question 13 of the tutorial? Round your answer to two decimals. Only provide the numeric value without any R-sign or spaces and use a full stop to separate Rand and Cents, e.g. 123.45
Hierdie vraag het betrekking op werksblad DB_10:
Hoeveel selle in kolom L vertoon die woord "Reg"? Verksaf slegs die numeriese waarde, sonder enige desimale.
This question refers to worksheet DB_10:
How many cells in column L displays the word "Right"? Only provide the numerical value, without any decimals.
Hierdie vraag het betrekking op werksblad DB_10:
Hoeveel selle in kolom K vertoon die woord "Apply"? Verksaf slegs die numeriese waarde, sonder enige desimale.
This question refers to worksheet DB_10:
How many cells in column K displays the word "Apply"? Only provide the numerical value, without any decimals.
Hierdie vraag het betrekking op werksblad DB_9:
Voltooi die ontbrekende gedeeltes in die formule hieronder wat in sel L2 getik en afgekopieer kan word in kolom L om die nodige kriteria te toets.
This question refers to worksheet DB_9:
Complete the omitted parts in the formula below that must be typed in cell L2 and copied down in column L so as to test for the requirements.
=
Want instant access to all verified answers on emslearn.sun.ac.za?
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!