8.1 Discuss TWO reasons why you would use page headers and page footers in a document AND give an example of the type of information that can be included in a header or a footer - NSC Computer Application Technology - Question 8 - 2023 - Paper 2

1. Incorrect cell range: The reference to the range B7:B13 might be incorrect, leading to an empty calculation if the wrong range was used.

2. Column B is Text: If the items in column B are formatted as text rather than numeric values, any calculations performed will not yield a numerical result, thus returning zero.

1. Input Masks: Define how data should be entered within a field (e.g., phone numbers).

2. Default Values: Automatically fill in a field with a preset value when new records are created.

Column Break: This feature allows specific text to flow into the next column, breaking the standard flow of text.

This validation rule specifies that numbers must either be less than 0 (negative numbers) or greater than or equal to 5. Therefore, values such as -1 or 5 are acceptable, while values between 0 and 4 are invalid.

The output will require a username that complies with the specified pattern: it must start with exactly two characters, followed by 'an', and conclude with one other character. Valid examples could include 'XYanZ' or 'aaana'. Invalid examples would be 'Xan' (too short) or 'ABanC' (too long).

The image will resize proportionally based on the width setting, maintaining its aspect ratio. This could potentially lead to distortion if the height becomes inadequate or excessive based on the original image dimensions.

The button can be used to summarize or aggregate data within the table, allowing users to easily calculate totals like SUM, AVG, COUNT, MAX, or MIN.