Search Header Logo

N5 Spreadsheets

Authored by K Allan

Business

9th - 11th Grade

Used 35+ times

N5 Spreadsheets
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

We can use this function to count the number of cells containing numbers

=COUNTA

=COUNTW

=COUNT

=COUNTN

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

We can use this function to count the number of cells containing words/letters

=COUNTA

=COUNTW

=COUNT

=COUNTN

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

We can use this function to perform a 'logical test' where the answer is a TRUE or FALSE outcome

=MAYBE

=WHEN

=LOGIC

=IF

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

We can use this function to add more than 2 cells together

=ADD

=SUM

=ANSWER

=COUNT

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

We can use this function to find the highest number in a range of cells

=MAX

=MIN

=HIGHEST

=LARGEST

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

We can use this function to find the lowest number in a range of cells

=MAX

=MIN

=SMALLEST

=LOW

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

We can use this function to find the average value in a range of cells

=MIDDLE

=AVG

=AVERAGE

=AV

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?