Yr 7 Spreadsheets KO quiz 2

What do all formulas start with?

• =

• -

• +

• sum

Which operator do we use to multiply number in a spreadsheet?

• +

• -

• *

• /

Which operator do we use to divide?

• +

• -

• *

• /

Which function will add the values in the selected cells?

• SUM

• MIN

• AVERAGE

• COUNT

Which function do we use to find the largest value in a list?

• SUM

• MAX

• AVERAGE

• COUNT

Which function do we use the count the number of selected cells which contain numbers?

• COUNTA

• COUNTBLANK

• COUNT

• COUNTIF

Answer explanation

COUNTA will count all the cells tht are not empty

COUNTBLANK will count all te cells which are empty

COUNTIF will count cells which match a certain condition

COUNT will only count the cells with numbers and it was the only one mentioned in the Knowledge Organiser

Which of these is NOT a formatting option?

• Number

• Currency

• Words

• Date

Answer explanation

If your cell contains words, you use the "Plain text" option.

Which os the following is NOT a formatting option?

• Time

• Phone number

• Scientific

• Percent