Photo AI
8.1 Name TWO features common to spreadsheet AND database applications to ensure the accuracy of data - NSC Computer Application Technology - Question 8 - 2017 - Paper 2
Question 8
8.1 Name TWO features common to spreadsheet AND database applications to ensure the accuracy of data. 8.2 What is the effect of using the spreadsheet feature 'Forma... show full transcript
Worked Solution & Example Answer:8.1 Name TWO features common to spreadsheet AND database applications to ensure the accuracy of data - NSC Computer Application Technology - Question 8 - 2017 - Paper 2
Step 1
Name TWO features common to spreadsheet AND database applications to ensure the accuracy of data.
Answer
-
Data Validation: This feature ensures that the inputted data meets specific criteria, reducing the chances of incorrect data entry.
-
Data Type Specification: Both applications allow for the definition of data types (e.g., text, number), ensuring that the data is consistent and correctly formatted.
Step 2
What is the effect of using the spreadsheet feature 'Format as Table' on a cell range?
Answer
The 'Format as Table' feature enhances the visual organization of the data. It creates a structured format with clear headers, making it easier to read and analyze data. Additionally, it allows for automatic filtering and sorting of data.
Step 3
Step 4
State TWO common problems when importing data from a CSV file into a database.
Answer
-
Incorrect Data Formatting: Data types may not align properly, leading to errors or misinterpretation of the values.
-
Missing Headers: If the CSV file does not include a header row, the database may not correctly identify field names, causing confusion.
Step 5
Which TWO automatic referencing features of a word processing application are only available if the 'Manage Sources' feature has been used?
Answer
-
Citations: The capability to automatically insert citations for sources referenced in the document.
-
Bibliography Generation: The function that creates a bibliography section listing all sources used in the document.
Step 6
A heading that was later added to a document does not appear in the automatic table of contents. State TWO steps to ensure that this new heading will appear in the automatic table of contents.
Answer
-
Apply Suitable Style to the Heading: Ensure that the new heading is formatted using a heading style that is recognized by the table of contents feature.
-
Update the Table of Contents: Manually update the table of contents by selecting the appropriate option in the application, ensuring the new heading is included.
Step 7
An image on a web page you created does not display fully in the browser. Suggest TWO ways to ensure that the image is fully visible.
Answer
-
Resize the Browser: Adjust the browser window size to ensure the image fits within the visible area.
-
Change the Dimensions of the Original Image: Alter the image's size in an image manipulation tool, making sure it matches the intended display size in the HTML.
Step 8
Step 9