Spreadsheet 2

Spreadsheet 2

9th - 12th Grade

6 Qs

quiz-placeholder

Similar activities

ÔN TẬP CUỐI HỌC KÌ I_TIN 7

ÔN TẬP CUỐI HỌC KÌ I_TIN 7

9th Grade

10 Qs

Excel

Excel

9th - 12th Grade

10 Qs

TRẮC NGHIỆM HÀM TRONG EXCEL

TRẮC NGHIỆM HÀM TRONG EXCEL

11th Grade

10 Qs

Lì xì đầu năm mới

Lì xì đầu năm mới

11th Grade

10 Qs

Excel

Excel

7th - 11th Grade

10 Qs

Câu hỏi về hàm SUMIF trong Excel

Câu hỏi về hàm SUMIF trong Excel

9th Grade - University

10 Qs

Quiz Materi Excel

Quiz Materi Excel

9th - 12th Grade

10 Qs

FUNCIONES DE EXCEL

FUNCIONES DE EXCEL

5th Grade - University

5 Qs

Spreadsheet 2

Spreadsheet 2

Assessment

Quiz

Computers

9th - 12th Grade

Medium

Created by

Lok Lee

Used 1+ times

FREE Resource

6 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What will be the final output of cell B1?

20

A1+10

=A1+10

10

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What will be the final output of cell B1?

A1+10

20

10

ERROR

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What will be the final output of cell B1?

A1+A2

35

10

25

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What should be the formula in cell B2 to get the result in the figure?

=B2>1.5

B2>1.5?

=B1>1.5

B1>1.5?

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What should be the formula in cell B2 to get the result in the figure?

=A1+A2+A3 = 10

=A1:A3 = 10

=A1+A2+A3 == 10

=A1+A2+A3 > 10

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What should be the formula and formatting in cell B4 to get the result in the figure?

=A2/B2

and

Number Format (Percentage)

=A2 div B2

and

Number Format (Percentage)

=A2/B2

=A2 div B2