Digital Skills for Work Week 3

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

An Excel formula should always begin with an = sign

• TRUE

• FALSE

What is the answer to the following formula?

=6-3*2

• 6

• 0

• 9

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

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 £

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

• TRUE

• FALSE

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

In Excel, which of the following formula would calculate 20% of 1000 (choose all that apply)

• =1000 + 20%

• =1000 * 20%

• =1000 * .2

• = 1000 x 20%

Which of the following formula will add the contents of all three cells together ?

(choose all that apply)

• A1+B1+C1

• =A1+B1+C1

• =SUM(A1:C1)

• (A1+B1+C1)

When entering data in Excel it is a good idea to avoid having blank rows or columns in your data

• TRUE

• FALSE