3.1 Patches are unintended flaws in software - NSC Computer Application Technology - Question 3 - 2018 - Paper 2
Question 3
3.1 Patches are unintended flaws in software.
3.2 OCR enables a user to unlock a protected smartphone without having to type in a password.
3.3 =VLOOKUP(E10,A1:B10... show full transcript
Worked Solution & Example Answer:3.1 Patches are unintended flaws in software - NSC Computer Application Technology - Question 3 - 2018 - Paper 2
Step 1
3.1 Patches are unintended flaws in software.
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
This statement is FALSE. Patches are typically updates designed to fix bugs, improve performance, or enhance security, rather than unintended flaws.
Step 2
3.2 OCR enables a user to unlock a protected smartphone without having to type in a password.
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
This statement is FALSE. While OCR (Optical Character Recognition) is used for recognizing text from images, unlocking smartphones typically uses methods like fingerprint, face recognition, or pattern locks.
Step 3
3.3 =VLOOKUP(E10,A1:B10,2,FALSE)
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
This statement is TRUE. The FALSE parameter in the VLOOKUP function ensures that the function returns an exact match for the lookup value.
Step 4
3.4 A computer that has been taken over by a hacker is called a pirate.
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
This statement is FALSE. A computer taken over by a hacker is often referred to as a zombie or bot.
Step 5
3.5 Cell formatting will display the result as a rounded number AFTER changing the value.
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
This statement is FALSE. Cell formatting does not change the underlying value; it only alters the display format. The ROUND, ROUNDUP, or ROUNDDOWN functions must be used to change values.