Chapter 2.2
General Excel
Chapter 1
Chapter 2
Chapter 3
100
Name the 3 'IF' functions
=COUNTIF =SUMIF =AVERAGEIF
100
How do you begin writing a formula in Excel?
=
100
TRUE or FALSE. You should never reference a cell when writing formulas.
False!! Always reference cells when you can so that your data automatically updates itself.
100
TRUE or FALSE. The LARGE function determines the 'k-th' highest value.
TRUE!!
100
TRUE or FALSE. The Currency format aligns the dollar symbol to the far left of the cell and aligns the decimal places of the values.
FALSE! The Currency format places the dollar symbol next to the value and does NOT align the decimal places. This type of formatting is describing the Accounting format.
200
TRUE or FALSE. When inputting a criteria argument, numeric values should be placed between quotation marks.
FALSE. Numeric values should be displayed by themselves in the argument. =COUNTIF(A1:A10, 100)
200
If I want my cell references to stay the same when I drag my formula, what is the name of the thing I have to do to them? It is indicated by the $ symbol.
Absolute Reference
200
True or false. Excel always evaluates your formulas from left to right in calculating your answers.
FALSE! Excel uses the Order of Operations to evaluate your formulas.
200
I want to add all of column B values that meet a certain criteria in column A. What function can I use?
SUMIF
200
TRUE or FALSE. Excel has over 10 chart types to choose from.
TRUE! Excel has 11 with variations of each.
300
TRUE or FALSE. Text in the criteria portion of an argument does not have to be exact and can have spaces in front of or behind it.
FASLE! Spaces DO count as characters in a text criteria. They must deleted or accommodated using other methods.
300
Write a formula to add these cells: A1, A2, A3, B4, B5, B6, C1
=SUM(A1:A3,B4:B6,C1) =SUM(A1, A2, A3, B4, B5, B6, C1) =A1+A2+A3+B4+B5+B6+C1
300
TRUE or FALSE. Displayed data are the formulas and functions in a cell.
FALSE! It is what shows up in a cell. Formulas and functions are the Stored Data.
300
If I want to randomly generate a set of numbers in excel, what function can I use to do that? State the specific function.
RANDBETWEEN
300
What does the Percentage format do to a cell?
It multiplies the cell by 100 and places a percentage symbol to the right of the value.
400
List the 5 ways to input the Criteria argument in the IF functions.
1. Numeric 2. Text 3. Cell Reference 4. Relational Operators 5. Wildcards
400
If you were to drag the following formula to the right one cell (across one column), what would the new formula be? =SUM(A$10:$A15)
=SUM(B$10:$A15)
400
What is the symbol to write a Greater Than Or Equal To sign?
>=
400
In the AVERAGEIF function it calls for 3 arguments: (range, criteria, sum_range). What does the range argument refer to? …be specific.
The range indicates the area you want excel to "lookup" the criteria to meet or not.
400
Name the most appropriate chart for showing the contribution of each store to the entire corporation.
Pie Chart
500
Brackets around an argument mean ________________.
....you do not have to include the argument because there is a default option available.
500
What is the difference between the COUNT and COUNTA functions?
The COUNT function ignores empty cells and cells with text in them. The COUNTA function only ignores empty cells.
500
How would a I reference cell C7 on a separate sheet named FSU Football? (Hint: there is a space between FSU and Football)
‘FSU Football’!C7
500
Write a formula to round cell C20 to the nearest tenth.
= ROUND(C20,1)
500
Which chart should you use to illustrate the relationship between two numeric variables.
Scatter plot. Line chart displays data with one numeric variable and one categorical variable.
M
e
n
u