Cells C4:C9 should display the relevant unit price from the data in the cell range A12:B15, depending on the value in column A - NSC Computer Application Technology - Question 8 - 2016 - Paper 2
Question 8
Cells C4:C9 should display the relevant unit price from the data in the cell range A12:B15, depending on the value in column A.
The following function was used inco... show full transcript
Worked Solution & Example Answer:Cells C4:C9 should display the relevant unit price from the data in the cell range A12:B15, depending on the value in column A - NSC Computer Application Technology - Question 8 - 2016 - Paper 2
Step 1
Identify the TWO errors in the function.
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
The lookup value is incorrect; it should be A4 instead of B4.
The column index of the lookup table is incorrect; it should be 2 instead of 1.
Step 2
Why will the formula = A4*B4 produce an error message?
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 error occurs because the formula tries to multiply a number by text (a word), which results in a type mismatch error.
Step 3
What is the difference in use between the COUNT and the COUNTA spreadsheet functions?
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 counts cells that contain numerical values/numbers, while COUNTA counts cells that contain any value that are not empty.
Step 4
Why should one use the ROUND function in a spreadsheet to round off numbers, instead of just formatting the numbers?
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
Formatting only gives the appearance of being rounded off, while the actual value is not changed. The ROUND function, on the other hand, changes the actual value.
Step 5
8.4.1 Automatic table of contents
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
Styles
Step 6
8.4.2 Automatic bibliography
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
Manage sources / Source manager / Sources
Step 7
Give an example of a program (NOT a website) that can be used to edit HTML files.
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
Any text editor such as Notepad, any HTML editor such as Notepad++, or word processors such as Microsoft Word.
Step 8
What is the relationship between a web page and a website?
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 part of a website; a website is a collection of web pages.
Step 9
What is the connection between the <head> section of an HTML web page and the information displayed in the browser tab?
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 text between the title tags within the head section is indicated in the browser tab.
Step 10
Identify TWO mistakes in the following HTML code.
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
Not supposed to start with a closing tag.
Not supposed to end with an opening tag (the opening and closing tags must match, either both <ul> or both <ol>).
Step 11
What is the main reason for using a form in a database?
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
To capture and manage data effectively.
Step 12
What effect does a calculation in a query have on the values in a database table?
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
It has no effect on the values in the database table; the values in the database table remain the same.
