SST8 Summary Quiz

SST8 Summary Quiz

10th Grade

7 Qs

quiz-placeholder

Similar activities

MS-Excel Level 3 (Final)

MS-Excel Level 3 (Final)

8th Grade - University

11 Qs

PowerPoint Quiz

PowerPoint Quiz

7th Grade - University

12 Qs

Excel Lanjut

Excel Lanjut

9th - 12th Grade

12 Qs

LibreOffice-Calc (Basic) -1

LibreOffice-Calc (Basic) -1

9th - 10th Grade

11 Qs

Excel Class Quiz 1

Excel Class Quiz 1

9th - 12th Grade

8 Qs

CONOCIMIENTOS EN POWERPOINT

CONOCIMIENTOS EN POWERPOINT

1st - 10th Grade

12 Qs

QUIS APLIKASI PENGOLAH ANGKA

QUIS APLIKASI PENGOLAH ANGKA

10th Grade

10 Qs

exel (повторение и ссылки)

exel (повторение и ссылки)

1st - 10th Grade

12 Qs

SST8 Summary Quiz

SST8 Summary Quiz

Assessment

Quiz

Computers

10th Grade

Hard

Created by

Chen Xia

Used 3+ times

FREE Resource

7 questions

Show all answers

1.

MULTIPLE SELECT QUESTION

1 min • 1 pt

Media Image

The worksheet is not protected and there are invalid data.

Two cells have wrong input.

Which of the following cell addresses currently contain invalid data.

B6

B10

F4

G3

G7

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

Cell F3 is the number of paper plate bought.

Which of the following is the validation criteria for the cell?

Type check: Whole number

Type check: Decimal numbers

Type check: Text length

3.

FILL IN THE BLANK QUESTION

2 mins • 1 pt

Media Image

We can protect the worksheet to avoid data input errors.

The worksheet is protected to ensure only the amount donated by each participant and quantity of item bought are editable.

Write down the range of cell addresses that should be unlocked.

Enter your answer as such: __:__ and __:__

4.

FILL IN THE BLANK QUESTION

2 mins • 1 pt

Media Image

Write down the formula for cell G7.

5.

FILL IN THE BLANK QUESTION

2 mins • 1 pt

Media Image

Cell A10 calculates the amount of money left after all the donations are collected and the specified number of items are bought.

Write down ONE cell that would be affected if the value in cell F6 is changed. [There are 3 possible answers.]

6.

FILL IN THE BLANK QUESTION

2 mins • 1 pt

Media Image

Cell A10 calculates the amount of money left after all the donations are collected and the specified number of items are bought.

Suggest a formula for cell A10.

7.

FILL IN THE BLANK QUESTION

2 mins • 1 pt

Media Image

We wish to "break even" (i.e., no profit or loss) by only varying the quantity of drinks bought.

Write down what we should enter for

"set cell", "to value" and "by varying cell"

in the Goal Seek window to calculate the new quantity of drinks to be bought.

Enter your answer as:

__,__,__