Grade 6 Computer Final Review

One must be a natural born Filipino to become the President of the Philippines.

• true

• false

Social problems are conditions that affect large number of people positively.

• true

• false

It is a strategy for helping pupils to visually outline information through the mapping of words or/and concepts.

• Text and data functions

• Logical functions

• Mind mapping

Three ways in defining a name range.

• Using the defined name button

• Using the excel function

• Using the name box

• Using the name manager

These are Excel functions that will enable you to add function decision making and logical preferences to your worksheets.

• Text and data functions

• IF Function

• SUMIF Function

• Logical Function

It is a value or expression that can be evaluated by TRUE or FALSE.

• Logical_test

• Value_if_true

• Value_if_false

It can be in a form of a number, expression, a cell reference, text, or a function that will define which cells are to be added.

• sum

• range

• criteria

• sum range

It is used to control the type of data or values that is being entered into the cell.

• Text and data functions

• Data validation

• SUMIF Function

• Logical Function

It will change all selected text into capital or upper case letters

• proper function

• lower function

• upper function

• concatenate function

It joins several text strings into one string.

• proper function

• lower function

• upper function

• concatenate function