Basic Stuff
Formulas
Functions
Applying Formulas
Applying Functions
100
This is the name for an excel file.
What is a workbook?
100
This is an equation that is entered in a cell.
What is a formula?
100
This is a predefined formula that performs a calculation based on values entered.
What is a function?
100
In the formula "=F3+5" what part of the formula is the "+"?
What is the operator?
100
What number would would the formula "=COUNT(A2:A7)" return?
What is 4?
200
This is the name for an excel spreadsheet page.
What is a worksheet?
200
What are the three parts of a formula?
What is
Equal sign: (=) must be the first character entered in the cell or formula bar. It tells the spreadsheet a calculation is to be performed.
Operand: values or data used in the formula's calculation.
Operator: indicates the type of calculation to be done.
200
These are the three parts of a function.
What is An equal sign, the function name, and the arguments.
200
Which of these formulas contains a cell reference:
=F6/3
=G10
=10+13
=21-6
What is the formula F6/3?
200
What is the function name in this formula? =COUNT(B11:H14)
What is COUNT?
300
This is where the row and column intersect. It usually contains the column letter and row number (e.g. E7)
What is a cell's address?
300
These are the two ways to enter a formula in a spreadsheet?
What is
1. Enter the formula directly in the cell
2. Select the cell and enter the formula in the Formula Bar
300
These are the functions we used in the second excel project - the Show me the Money Project.
What are the AVERAGE, MAX, and MIN functions.
300
Which of these formulas is a complex formula:
=D6/5
=10-(A3-D13)
=5+A1*B1
=C3+10+E3
What is the formula 5+A1*B1?
300
Which formula would you enter to return the number 45.1?
What is MAX(A2:B5)?
400
Looking here allows you to see the address of the cell you have selected
What is the Name Box?
400
These are the two ways you can edit a formula in a spreadsheet.
What is
1. Double-click on the cell and edit the formula in the cell.
2. Select the cell and edit the formula in the Formula Bar.
400
This function adds all the values in a range of cells together.
What is the SUM function.
400
Using the correct order of operations, what does the formula equal? =(4-2)*6/2
What is 6?
400
This would be the best formula for finding the total value for cells B2 through B5.
What is =SUM(B2:B5)?
500
These are pieces of information that describe the appearance of the cell's content.
What are format attributes?
500
You can use these to force an order of operations in a formula.
What is By using parentheses you can force an order of operations in a formula.
500
What is the argument in this formula =COUNT(B11:H14)
What is B11:H14
500
Using the correct order of operations, what does this formula equal? =16/4*2
What is 8?
500
What do these functions do? (MAX, MIN, and COUNT?)
What is...
MAX - calculates the largest value in the data set
MIN - calculates the smallest value in the data set
COUNT - counts the total number of values in the selected group of cells.