Computer Revision unit 2 and 3

Define a table of content

A table of conent is found at the start of a document that contains the titles and subtitles and their corresponding page number

What is mail merge?

A mail merge can be useful when a document needs to be sent to many people.

Give the three steps for mail merge

• Create a mailing list

• Create a template

• Insert fields to merge the two document

GIve the three requirement i order to complete the mail merge process

• Main Document

• Data Source

• Merge Fields

Define the term ‘Conditional Formatting’

Conditional Formatting is a feature in Exel to apply formatting to a cell or a range of cells based on a certain criteria

Write the formula for the if statement

If =(Logical test, value_if_true, value_if_false)

Write it in a function arguement

Logical test cell number < a number

Value_If_true ‘PASS’

Value_if_false ‘FAIL’

How to repeat of replicate the if statement?

• Fill handle can be used to duplicate the formula

What is COUNTIF function?

The countif fuction counts the number of cells ina given range that meet a specefic condition

Write the fomula of COUNTIF

=COUNTIF(range, criteria)

Define Range.

The range refers to the range of cells to be counted by the formula.

Define Criteria

The Criteria refers to the conditions that must be met in order for the cells to be counted