    Formula Basics

Quiz by Lisette Ngui

Feel free to use or edit a copy

includes Teacher and Student dashboards

### Measure skillsfrom any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

• edit the questions
• save a copy for later
• start a class game
• view complete results in the Gradebook and Mastery Dashboards
• automatically assign follow-up activities based on students’ scores
• assign as homework
• share a link with colleagues
• print as a bubble sheet
15 questions
• Q1
A formula always starts with a / an
=
-
()
,
30s
Edit
Delete
• Q2
Formulas can be entered into a worksheet using how many methods?
2
1
3
4
30s
Edit
Delete
• Q3
Cell referencing is used so the formula won't have to be re - typed true
false
30s
Edit
Delete
• Q4
Formulas can be edited only in the cell to be edited
false
true
30s
Edit
Delete
• Q5
Formulas can be entered using the fill handles
false
true
30s
Edit
Delete
• Q6
Formulas can be entered manually only
false
true
30s
Edit
Delete
• Q7
Cell address is used to identify the location of a cell false
true
30s
Edit
Delete
• Q8
false
true
30s
Edit
Delete
• Q9
The point and click method can be used to enter formulas
false
true
30s
Edit
Delete
• Q10
Excel and Mathematics share the same operators
false
true
30s
Edit
Delete
• Q11
The multiplication sign is represented by an 'x'
true
false
30s
Edit
Delete
• Q12
Complex formulas contain more than one mathematical operator.
true
false
30s
Edit
Delete
• Q13
The order of operations should not be followed.
true
false
30s
Edit
Delete
• Q14
If you follow the order of operations, you calculate what is contained in the parentheses first.
false
true
30s
Edit
Delete
• Q15
The symbol for exponential is a caret
^
>
<
30s
Edit
Delete

Teachers give this quiz to your class