Spreadsheet 2

Spreadsheet 2

9th - 12th Grade

6 Qs

quiz-placeholder

Similar activities

Hoja Electrónica

Hoja Electrónica

1st - 10th Grade

10 Qs

SOAL EVALUASI MICROSOFT EXCEL

SOAL EVALUASI MICROSOFT EXCEL

12th Grade

10 Qs

Funciones de Excel para estudiantes

Funciones de Excel para estudiantes

7th Grade - University

10 Qs

Soal Fungsi Logika IF

Soal Fungsi Logika IF

12th Grade

11 Qs

bài thi 1

bài thi 1

1st Grade - University

10 Qs

Excel 1

Excel 1

9th Grade - University

11 Qs

Básicos Excel

Básicos Excel

9th Grade

10 Qs

IF Function - Excel

IF Function - Excel

9th - 11th Grade

10 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