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

Digital Skills for Work Week 3

Quiz
•
Computers
•
Professional Development
•
Hard

Annie Tailor
FREE Resource
10 questions
Show all answers
1.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
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
Similar Resources on Quizizz
12 questions
Excel Basico

Quiz
•
Professional Development
10 questions
LECCION EXCEL

Quiz
•
Professional Development
12 questions
MS EXCEL - BCST

Quiz
•
Professional Development
10 questions
Excel Chapter 3

Quiz
•
Professional Development
11 questions
Exceljy

Quiz
•
12th Grade - Professi...
10 questions
Excel for Business Q1

Quiz
•
Professional Development
10 questions
Microsoft Excel

Quiz
•
Professional Development
10 questions
Excel Quiz

Quiz
•
Professional Development
Popular Resources on Quizizz
15 questions
Multiplication Facts

Quiz
•
4th Grade
25 questions
SS Combined Advisory Quiz

Quiz
•
6th - 8th Grade
40 questions
Week 4 Student In Class Practice Set

Quiz
•
9th - 12th Grade
40 questions
SOL: ILE DNA Tech, Gen, Evol 2025

Quiz
•
9th - 12th Grade
20 questions
NC Universities (R2H)

Quiz
•
9th - 12th Grade
15 questions
June Review Quiz

Quiz
•
Professional Development
20 questions
Congruent and Similar Triangles

Quiz
•
8th Grade
25 questions
Triangle Inequalities

Quiz
•
10th - 12th Grade