Photo AI

8.1 Which feature of a word processor can be used to mark specific places in a document so that a user can go to these places quickly? 8.2 How could a word processing document be saved so that the text can be edited on another computer that does not have a word processor installed? 8.3 Why are section breaks inserted in a word processing document? 8.4 A database contains the surnames and names of learners - NSC Computer Application Technology - Question 8 - 2019 - Paper 2

Question icon

Question 8

8.1-Which-feature-of-a-word-processor-can-be-used-to-mark-specific-places-in-a-document-so-that-a-user-can-go-to-these-places-quickly?--8.2-How-could-a-word-processing-document-be-saved-so-that-the-text-can-be-edited-on-another-computer-that-does-not-have-a-word-processor-installed?--8.3-Why-are-section-breaks-inserted-in-a-word-processing-document?--8.4-A-database-contains-the-surnames-and-names-of-learners-NSC Computer Application Technology-Question 8-2019-Paper 2.png

8.1 Which feature of a word processor can be used to mark specific places in a document so that a user can go to these places quickly? 8.2 How could a word processi... show full transcript

Worked Solution & Example Answer:8.1 Which feature of a word processor can be used to mark specific places in a document so that a user can go to these places quickly? 8.2 How could a word processing document be saved so that the text can be edited on another computer that does not have a word processor installed? 8.3 Why are section breaks inserted in a word processing document? 8.4 A database contains the surnames and names of learners - NSC Computer Application Technology - Question 8 - 2019 - Paper 2

Step 1

Which feature of a word processor can be used to mark specific places in a document so that a user can go to these places quickly?

96%

114 rated

Answer

Bookmarks are a feature of word processors that allow users to mark specific locations in a document. This enables quick navigation to these points later.

Step 2

How could a word processing document be saved so that the text can be edited on another computer that does not have a word processor installed?

99%

104 rated

Answer

You can save the document as a text file (e.g., .txt) or in a format that is compatible with various applications, like Rich Text Format (RTF) or HTML, allowing for editing on different systems.

Step 3

Why are section breaks inserted in a word processing document?

96%

101 rated

Answer

Section breaks are used to divide a document into sections, allowing each section to have its own formatting (such as headers, footers, and different page orientations). This organization is crucial for creating complex layouts.

Step 4

Give the term used to describe the asterisk ('*') when used in the criterion.

98%

120 rated

Answer

The asterisk ('*') in the query context is referred to as a 'wildcard'.

Step 5

Give the purpose of using the asterisk in the query.

97%

117 rated

Answer

The purpose of the asterisk is to perform searches based on partial matches. It enables the retrieval of records that start with a specified pattern, such as 'Smi*', capturing all records that match.

Step 6

Which spreadsheet function would you use in the Orders worksheet to display a product description for every code?

97%

121 rated

Answer

The spreadsheet function that should be used is VLOOKUP, which allows you to look up values in another table, returning the corresponding product description.

Step 7

How can you ensure that the function will work correctly when you copy it down for all the clients in the Orders worksheet?

96%

114 rated

Answer

To ensure the function works correctly when copied down, use absolute references in your formula. This can be accomplished by using the '$' sign before the row and column referencing the lookup table, or using the F4 key while highlighting the cell reference.

Step 8

What change needs to be made to the Stock table in the Codes worksheet to ensure that the function will not return an error message?

99%

104 rated

Answer

Make sure the Stock table is sorted in ascending order based on the CODE field. Additionally, include all relevant stock codes in the table to ensure VLOOKUP can find the value.

Step 9

Why would the text 'MAX(D2:D5)' display in the cell instead of the required result of the function, e.g., 25?

96%

101 rated

Answer

The text might display because the cell is formatted as text rather than a formula. Alternatively, the SHOW FORMULAS option may be enabled, causing the cell to show the formula instead of the calculated value.

Step 10

Give TWO reasons why the function in cell B8 would not return the correct result.

98%

120 rated

Answer

One reason could be that the function is searching for 'Grade 2' instead of 'Grade 3', or there could be a mismatch in the column where the grade data is stored, leading to incorrect results.

Step 11

Suggest a change to the code so that all the text in the body section will display in Arial font.

97%

117 rated

Answer

To ensure all text displays in Arial font, wrap the text in a <font> tag with the desired font style specified. Alternatively, apply CSS styles using a <style> tag in the <head> section.

Step 12

Suggest a change to the code so that the text 'How to start a campaign' will NOT appear formatted as a hyperlink.

97%

121 rated

Answer

Remove any <a> tags surrounding the text 'How to start a campaign' to ensure it does not display as a hyperlink.

Step 13

Where would the text 'Fund-raising' appear when the page is displayed in a browser?

96%

114 rated

Answer

The text 'Fund-raising' would appear in the browser tab, as it is specified within the <title> tag in the document's <head> section.

Join the NSC students using SimpleStudy...

97% of Students

Report Improved Results

98% of Students

Recommend to friends

100,000+

Students Supported

1 Million+

Questions answered

;