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

12

13

14

15

13

14

15

16

13

14

15

16

13

14

15

16

17

14

15

16

Axis Title

Chart Title

Data Lables

Data Table

Axis Title

Chart Title

Data Lables

Data Table

Axis Title

Chart Title

Data Lables

Data Table

Axis Title

Chart Title

Data Lables

Data Table

=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