Font size
WorksheetsUsing Formulas in Spreadsheets
Total questions: 24
Worksheet time: 19mins
When you include a math problem in a table, the spreadsheet program can automatically calculate, or figure out, the problem's answer for you.
When you calculate, you ...
... reverse the problem's answer.
... explain the problem's answer.
... figure out the problem's answer.
... compare the problem's answer.
A math problem in a spreadsheet table is called ...
... a formula.
... an expression.
... a calculation.
... a cell equation.
Operators are symbols that stand for math processes, such as the plus, minus, multiplication and (a) signs.
Rows are --------------
lettered
numbered
A formula begins with an EQUAL SIGN.
true
false
Rows are --------------
lettered
numbered
Identify the name of the arithmetic operator by looking at the image
Plus +
Minus -
Identify the name of the arithmetic operator
minus -
plus +
Identify the arithmetic operator by looking at the image
plus +
multiply *
minus -
I am able to add, subtract and multiply numbers in excel using formula
yes
no
In Ms Excel you can change the colour of the cell using Fill colour tool.
false
true
Words in the spreadsheets are called ____
labels
values
The rectangular boxes in a spreadsheet is known as --------------
(a)
When you click the cell where you want a formula's answer to show, the formula is entered ...
... in that cell.
... as a title.
... in a tab.
... in the formula bar.
After you see the equal sign in the formula bar, type the (a) , and then press Enter or Return.
After you've entered the formula in the cell you selected, the answer appears ....
... in the formula bar.
... as a title.
... in that cell
... within a new tab.
True or False?
When you create formulas using numbers, the answer in the cell will stay the same until you change one of the numbers in the formula.
True or False?
Another way to create a formula in a spreadsheet program is to reference, or use, cell addresses.
(a)
When you 'reference' a cell address, you type the cell address that _______________________ a value, instead of typing an actual number value.
contains
puts into parentheses
shares
calculates
You can mix and match cell addresses and ______________________ in the same formula.
symbols
numbers
letters
variables
The Summation tool is located in which subgroup beneath the 'Home' ribbon tab?
Cells
Number
Editing
Font
Formulas may include :
operators
numbers
cell addresses
equal signs
When you create formulas using numbers, the answer in the cell will __________________ until you change one of the numbers in the formula.
decrease
halve
increase
stay the same
