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 Wayground
10 questions
Excel Workshop MCQs

Quiz
•
Professional Development
10 questions
INFORMATICA 1

Quiz
•
Professional Development
10 questions
EXCEL BÁSICO

Quiz
•
Professional Development
15 questions
Microsoft Excel

Quiz
•
Professional Development
14 questions
Microsoft Excel Basics - Video 2

Quiz
•
6th Grade - Professio...
7 questions
CLASE MUESTRA

Quiz
•
Professional Development
10 questions
Funciones Excel

Quiz
•
Professional Development
14 questions
Mamaraximov E

Quiz
•
Professional Development
Popular Resources on Wayground
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice

Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers

Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade