Reviewer: Challenge Assessment [3rd Term]

3rd Term CA Reviewer

By Sir Fred LLORANDO

Drag and Drop

A

Placeholder

is a type of conditional function that evaluates data based on one specific condition.

The

Placeholder

function is used to add values in a specified range based on a certain criterion.

The

Placeholder

function counts the total number of cells within a range that meet a specified condition.

The

Placeholder

function calculates the average or mean of values in a cell range according to a single criterion.

Drag these tiles and drop them in the correct blank above

Single-criterion

SUMIF

COUNTIF

AVERAGEIF

Drag and Drop

In contrast,​

Placeholder

refers to a conditional function that evaluates multiple conditions and returns a value only when all conditions are satisfied.

The ​

Placeholder

function is used to add values in a specified range based on the given criteria.

The​

Placeholder

function counts the total number of cells within a range that meet the specified conditions.

The​

Placeholder

function calculates the average or mean of values in a cell range according to more than one criterion.

Drag these tiles and drop them in the correct blank above

Multiple-criterion

SUMIFS

COUNTIFS

AVERAGEIFS

Drag and Drop

The syntax​

Placeholder

or Range in the conditional function refers to the set of cells where the specified criteria will be evaluated, while​

Placeholder

is the set condition to meet. On the other hand,​

Placeholder

in SUMIF/SUMIFS defines the range of cells containing the values that will be summed or added, while in AVERAGEIF/AVERAGEIFS, it is​

Placeholder

that will determine the values that will be computed for the mean or average.

Drag these tiles and drop them in the correct blank above

Criteria_Range

Criteria

Sum_range

Average_range

Dropdown

​

Select answer

function can perform both vertical and horizontal lookups, but it has certain limitations. While,​

Select answer

is specifically used to retrieve data from a table that is arranged vertically or by column, and​

Select answer

is designed for retrieving data from a table that is organized horizontally or by row.



When searching for match-up values,​​

Select answer

will be returned if it finds an actual match of the lookup value, while an​

Select answer

will be returned if no exact value is found, and only the closest match is present.

Dropdown

The syntax​

Select answer

refers to the data used as a reference for retrieving information.

The syntax​

Select answer

in LOOKUP is similar to Table_array in VLOOKUP and HLOOKUP, which is the range of cells that specifies where the lookup_value can be found.

The syntax​

Select answer

in LOOKUP is similar to Col_index_num in VLOOKUP and Row_index_num in HLOOKUP, which are used to identify the range of cells that contains the data to be displayed as the result.

The syntax Range_lookup must include either​

Select answer

for an​ exact match or

Select answer

for an​ approximate match.

Dropdown

Determine if the given formula is valid or invalid:

=COUNTIF(E2:E40, “MALE”) -​

Select answer

=COUNTIFS(A2:A15, "SMALL", D2:D15, 250) -​

Select answer

=SUMIF(E5:J5, 1500, E7;J7) -​

Select answer

=SUMIFS(C5:C20, B5:B20, "3/4/25", D5:D20, “<150”) -​

Select answer

=AVERAGEIF(A10:A25, “250”, A26:A50) -​

Select answer

Dropdown

Determine if the given formula is valid or invalid:

=LOOKUP(100, A1:A11, B1:B11) -​

Select answer

=VLOOKUP(150, A2:E11, 5, FALSE) -​

Select answer

=HLOOKUP(B10, A1:Z6, 8, FALSE) -​

Select answer

Fill in the Blank

Give the syntax in the formula that makes it invalid:

=COUNT(B2:B12, "Adam Smith")

Fill in the Blank

Give the syntax in the formula that makes it invalid:

=AVERAGEIF(E2-E12, "24-12-21", B2:B12)

-

Fill in the Blank

Give the syntax in the formula that makes it invalid:

=LOOKUP(100, A1:A11, A12:A22)

:

Fill in the Blank

Give the syntax in the formula that makes it invalid:

=VLOOKUP(150, A2;E11, 5, FALSE)

;

Fill in the Blank

Give the syntax in the formula that makes it invalid:

=LOOKUP(B8, A1:X6, 2, TRUE)