8.1.1
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
8.1.1
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 use... show full transcript
Worked Solution & Example Answer:8.1.1
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 leads to a mismatch in data types.
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 changes the appearance of being rounded off, while the actual value is not changed. The ROUND function, however, changes the actual value.
Step 5
In each of the following cases, name the word processing feature that must first be used or applied before it will work: 8.4.1
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
In each of the following cases, name the word processing feature that must first be used or applied before it will work: 8.4.2
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
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, or any HTML editor such as Notepad++.
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 ol or both ul)).
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
(More user-friendly way) of capturing of data/Designed for data input. To display only one record at a time. To limit the fields displayed, etc.
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.
