Search Header Logo

Spreadsheets task 2a+b

Authored by Katie Bushell

Computers

9th Grade

Used 1+ times

Spreadsheets task 2a+b
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

58 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What are C3, D5, E9 an examples of?

Cell references

Formulas

Functions

Charts

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What are the symbols on a keyboard for addition, subtraction, division and multiplication?

Addition: +, Subtraction: -, Division: /, Multiplication: *

Addition: -, Subtraction: +, Division: *, Multiplication: /

Addition: *, Subtraction: /, Division: +, Multiplication: -

Addition: /, Subtraction: *, Division: -, Multiplication: +

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What are the symbols on the keyboard for ‘greater than’ and ‘less than’?

Greater than: >, Less than: <

Greater than: <, Less than: >

Greater than: =, Less than: -

Greater than: %, Less than: $

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What FUNCTION do you use to total up a range of cells?

SUM

AVERAGE

MIN

COUNTIF

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What FUNCTION do you use to work out the average of a range of cells?

AVERAGE

SUM

COUNT

MAX

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Can you name any other functions?

Examples: MIN, MAX, COUNT, IF

Examples: CAT, DOG, BIRD, FISH

Examples: ADD, SUBTRACT, MULTIPLY, DIVIDE

Examples: RED, BLUE, GREEN, YELLOW

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What are C3, D5, E9 an examples of?

A cell reference

A formula

A worksheet

A chart

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?