Basic Excel Stuff
Hodgepodge
Order of Operations
Write a Formula
What Word/Function
100
All Excel formulas begin with _______
What is an = (equal sign)?
100
What is the "absolute" symbol used in a formula to make sure the cell range does NOT CHANGE.
$
100
PEMDAS helps remember the _____
What is order of operations?
100
A formula that adds 2 cells A1 and A22
What is =A1+A22
100
adds a range of cells together
What is SUM
200
Currency formatting has a $ sign and how many default decimal places?
2
200
An _____ cell reference that does not change when the formula is copied or moved.
What is absolute?
200
When solving a formula, always complete the items in _____ first.
What is parentheses?
200
That will subtract A3 from A4
What is =A4-A3
200
gives you the average of a range of cells
What is AVERAGE?
300
There are tabs at the bottom of the "workbook" file, where you can observe, add and delete the number of "what" in the file.
What is a worksheet?
300
The _____ error occurs when the column is not wide enough or a negative date is entered.
What is ####?
300
_____ is the answer for 9+5x8
What is 49?
300
use the function that will add the total of the range of cells A1:A11
What is =SUM(A1:A22)
300
returns the smallest amount in a series
What is MIN?
400
10+(6-3)/2^2*4-1 is a simple formula.
FALSE as a simple formula only has one operator
400
_____ are pre-written formulas
What are functions?
400
Simply the numerical expression using the order of operations and provide the answer 4-9/3+5x2=
4-9/3+10
4-3+10
1+10
The answer is 11
400
that will return the largest number between A1 and A22
What is =MAX(A1:A22)
400
The function that can produce the highest value in a group of cells
What is MAX?
500
The #NAME? error occurs when Excel does not recognize _____ in a formula.
What is text?
500
The fill handle to copy formulas from one cell to others is located where?
The square at the bottom right corner of the cell.
500
This type of error is displayed when the formula displays the wrong type of argument.
What is #VALUE! error
500
This method of creating a formula can save a lot of time and effort. You do not have to type in the cell addresses.
What is the point & click method?
500
What would you use to find "duplicates" in a series of data?
What is "conditional formatting":