Spreadsheets Flashcards by David McLean

Q

SUM

A

合計

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

AVERAGE

A

平均

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

MAX

A

最大値

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

MIN

A

最小値

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

COUNT

A

数字を数える

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

COUNTA

A

文字もしくは空白以外を数える

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

COUNTIF

A

条件を満たすものの個数を数える

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

IF

A

条件

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

RANK

A

ランキング

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

オートフィル

A

式のコピー

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

$

A

セルを固定する、絶対参照

How well did you know this?

1

Not at all

2

3

4

5

Perfectly