600+ câu trắc nghiệm Điện toán di động có đáp án - Phần 23

=AND( Value1, [Value2],…)

=AND (Number1, [Number2],…)

=AND( Logical1, [Logical2],…)

Tất cả đều sai

=OR( Value1, [Value2],…)

=OR (Number1, [Number2],…)

=OR( Logical1, [Logical2],…)

Tất cả đều sai

=NOT( Logical)

=NOT (Number)

=NOT( Value)

Tất cả đều sai

SUM( Value1, [Value2],…)

SUM( Range1, [Range2],…)

SUM( Number1, [Number2],…)

SUM( Logical1, [Logical2],…)

AVERAGE( Value1, [Value2],…)

AVERAGE( Range1, [Range2],…)

AVERAGE( Number1, [Number2],…)

AVERAGE( Logical1, [Logical2],…)

MAX( Value1, [Value2],…)

MAX( Range1, [Range2],…)

MAX( Number1, [Number2],…)

MAX( Logical1, [Logical2],…)

MIN( Value1, [Value2],…)

MIN( Range1, [Range2],…)

MIN( Number1, [Number2],…)

MIN( Logical1, [Logical2],…)

COUNT( Value1, [Value2],…)

COUNT( Range1, [Range2],…)

COUNT( Number1, [Number2],…)

COUNT( Logical1, [Logical2],…)

COUNTA( Value1, [Value2],…)

COUNTA( Range1, [Range2],…)

COUNTA( Number1, [Number2],…)

COUNTA( Logical1, [Logical2],…)

COUNTBLANK( Value1, [Value2],…)

COUNTBLANK( Range)

COUNTBLANK( Number1, [Number2],…)

COUNTBLANK( Logical1, [Logical2],…)

COUNTIF(Range, Criteria, [sum_range])

COUNTIF( Range, Criteria)

COUNTIF( Criteria, Range)

COUNTIF(Criteria, [sum_range], Range)

COUNTIFS(Range, Criteria, [sum_range])

COUNTIF( Range, Criteria)

COUNTIFS( Criteria_range1, criteria1,…)

COUNTIFS(Criteria1, criteria_range1],…)

SUMIF(Range, Criteria, [sum_range])

SUMIF( Range, Criteria)

SUMIF( Criteria, Range)

SUMIF(Criteria, [sum_range], Range)

RANK(Range, Criteria, [sum_range])

RANK( Range, Criteria)

RANK( Criteria, Range)

RANK(number, ref, [order])

0

1

2

Tất cả đều sai

-123356

01/01/2021

Excel 2010

34%

Orientation.

Text Control.

Text alignment.

Shinrk to fit