Bestudeer die skermkopie hieronder en beantwoord die vrae wat volg - NSC Computer Application Technology - Question 8 - 2016 - Paper 2
Question 8
Bestudeer die skermkopie hieronder en beantwoord die vrae wat volg.
8.1 Sel C4:C9 moet die relevante eenheidsprys uit die data in die seleks A12:B15 vertoon, na gel... show full transcript
Worked Solution & Example Answer:Bestudeer die skermkopie hieronder en beantwoord die vrae wat volg - NSC Computer Application Technology - Question 8 - 2016 - Paper 2
Step 1
Identifiseer die TWEE foute in die funksie.
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Die twee foute in die VLOOKUP funksie is:
Die tweede argument (A13:B15) gebruik wrong column for value names; it should reference a wider range including the return column (e.g., A12:B15).
The use of '1' as the column index is incorrect; it should refer to the column with the values to return, which in this case is column 2.
Step 2
Waarom soos die formule =A4*B4 'n foutboodskap gee?
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The formula =A4*B4 results in an error if either A4 or B4 contains a non-numeric value. Any text values in these cells cannot be multiplied, causing an error.
Step 3
Wat is die verskil in gebruik tussen die COUNT- en die COUNTA-sigbladfunksies?
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
COUNT function counts only cells with numeric data, while COUNTA function counts all non-empty cells regardless of data type, including numbers, text, or logical values.
Step 4
Hoe kom moet 'n mens die ROUND-funksie in 'n sigblad gebruik om getalle af te rond, in plaas daarvan om slegs die getalle te formatere?
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The ROUND function should be used when precise control over decimal places is needed, as formatting only affects appearance and not the underlying value. Thus, certain calculations may yield different results if formatting alone is applied.
Step 5
Noem die woordverwerkingseienskaps ('feature') wat eers gebruik of toegepas moet word voordat dit sal werk in Outomatiese inhoudsopgawe.
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Before creating an automatic table of contents, styles must be applied to the headings to ensure the document recognizes them correctly.
Step 6
Noem die woordverwerkingseienskaps ('feature') wat eers gebruik of toegepas moet word voordat dit sal werk in Outomatiese bibliografie.
97%
121 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
For an automatic bibliography, proper citation styles must be employed throughout the document so that the software can compile the references accurately.
Step 7
Gee 'n voorbeeld van 'n program (nie webtuise NIE) wat gebruik kan word om HTML-teks te redigeer.
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
A suitable program for editing HTML text would be 'Notepad++', which allows for syntax highlighting and code management.
Step 8
Wat is die verwantskap tussen 'n webblad en 'n webtuise?
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
A web page is a single document that is displayed in a web browser, while a website is a collection of interconnected web pages housed under a unique domain name.
Step 9
Wat is die verband tussen die 'head'-afdeling van 'n HTML-webblad en die inhoud wat in die webblaarjoerie ('browser tab') vertoon word?
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The contents of the 'head' section, specifically the <title> tag, define what is displayed in the browser tab as the webpage title, influencing user navigation.
Step 10
Identifiseer TWEE foute in die volgende HTML-kode:
</ul>
<li>Item 1</li>
<li>Item 2</li>
</ol>
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The two errors in the HTML code are:
The use of </ul> to close an unordered list without a corresponding <ul> tag to open it.
The use of </ol> which implies that an ordered list was started, while there is none in the provided code.
Step 11
Wat is die hoofrede vir die gebruik van 'n vorm in 'n databas?
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The primary reason for using a form in a database is to provide a user-friendly interface for data entry, making it easier to collect and manipulate user input.
Step 12
Watter uitwerking het 'n berekening in 'n navrag op die waardes in 'n databasistabel?
97%
121 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
A calculation in a query can dynamically adjust the values retrieved from a database table, allowing for operations to display totals, averages, or derived data rather than static records.
