Digital Skills for Work Week 3

Digital Skills for Work Week 3

Professional Development

10 Qs

quiz-placeholder

Similar activities

Excel Game 1

Excel Game 1

Professional Development

15 Qs

Excel for Business Q3

Excel for Business Q3

Professional Development

15 Qs

Mamaraximov E

Mamaraximov E

Professional Development

14 Qs

INFORMÁTICA: Quem sabe mais?

INFORMÁTICA: Quem sabe mais?

KG - Professional Development

15 Qs

Septimo

Septimo

KG - Professional Development

10 Qs

Excel Quiz

Excel Quiz

Professional Development

10 Qs

Excel 12

Excel 12

Professional Development

13 Qs

EXCEL BÁSICO

EXCEL BÁSICO

Professional Development

10 Qs

Digital Skills for Work Week 3

Digital Skills for Work Week 3

Assessment

Quiz

Computers

Professional Development

Hard

Created by

Annie Tailor

FREE Resource

10 questions

Show all answers

1.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

What does the BODMAS or BIDMAS rule remind us? (More than one answer may be correct)

To format the cell as a currency

The order of calculation in a mathematical Formula

To use an = in a formula

To put brackets around the part of the formula that should be calculated first

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

An Excel formula should always begin with an = sign

TRUE

FALSE

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the answer to the following formula?

=6-3*2

6

0

9

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The operators in an Excel Formula are:

  • + Addition

  • - Subtraction

  • x Multiplication

  • / Division

  • + Addition

  • - Subtraction

  • * Multiplication

  • / Division

  • + Addition

  • - Subtraction

  • * Multiplication

  • \ Division

  • + Addition

  • - Subtraction

  • x Multiplication

  • \ Division

5.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

How can you make Excel treat a number as text?

(Choose all that apply)

Precede the number with an apostrophe

'

Format the cell as text

Put a zero at the beginning

Precede the number with a £

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If a number is formatted as text it will not be included in any calculations

TRUE

FALSE

7.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

A custom list allows you to (choose all that apply)

Store lists of values

Sort text in an order that is not alphabetical

Easily create frequently used lists or headings

Store lists of items that can be used in multiple spreadsheets

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?