S1 Spreadsheets Functions/Formulae

S1 Spreadsheets Functions/Formulae

7th - 11th Grade

14 Qs

quiz-placeholder

Similar activities

Test Your Knowledge Part One

Test Your Knowledge Part One

1st - 12th Grade

15 Qs

Aku suka Microsoft Excel

Aku suka Microsoft Excel

10th Grade

12 Qs

Year 9 - May

Year 9 - May

9th Grade

11 Qs

Clase de Computación: Excel

Clase de Computación: Excel

11th Grade

12 Qs

Year 8 Spreadsheets L1 (Basics)

Year 8 Spreadsheets L1 (Basics)

9th Grade

12 Qs

Q1 EMPOWERMENT TECHNOLOGIES SUMMATIVE TEST 2

Q1 EMPOWERMENT TECHNOLOGIES SUMMATIVE TEST 2

11th Grade

10 Qs

Pengolah Angka

Pengolah Angka

7th Grade

10 Qs

TIN HOC 7

TIN HOC 7

7th Grade

10 Qs

S1 Spreadsheets Functions/Formulae

S1 Spreadsheets Functions/Formulae

Assessment

Quiz

Computers, Business

7th - 11th Grade

Medium

Created by

Nick Allen

Used 50+ times

FREE Resource

14 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which symbol is used at the beginning of all formulae and functions?

+

-

=

$

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which symbol is used in a formula for adding?

*

-

/

+

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which symbol is used in a formula for subtracting?

*

-

/

+

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which symbol is used in a formula for multiplying?

*

-

/

+

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which symbol is used in a formula for dividing?

*

-

/

+

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the formula to add up A1 and B1?

=SUM(A1:B1)

=A1+B1

A1+B1

=ADD(A1:B1)

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the formula to work out A2 take away B2?

A2-B2

=A2-B2

=SUB(A2:B")

=A2MINUSB2

Create a free account and access millions of resources

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?