SST8 Summary Quiz

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

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

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 __:__

Write down the formula for cell G7.

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.]

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.

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:

__,__,__