Unit 4 Flashcards
To simplify long and complex tasks use _____.
If you insert cells within a range used in a function, the function will _____ adjust to _____ the new cell.
Functions
Automatically, include
A function is a _____ formula that performs a _____ _____ or other action on _____ and _____.
You specify the _____ on which the function performs the _____.
Format of a function: _____ (_____, _____)
Pre-defined, specific calculation, numbers, text
Values, calculations
Function name, argument1, argument2
Functions always begin with a __ _____.
_____ are the _____ values of a function.
Arguments can be _____, _____, _____ _____, _____ or _____ functions.
= sign
Arguments, input
Numbers, text, cell addresses, ranges, other
One of the most commonly use functions is _____.
_____ calculate the total of all of the _____ listed in it’s _____.
(A1:A4) is called _____ _____ _____.
Sum function
Sum, values, arguments
Contiguous range reference
If Excel suspects an error in a cell, it _____ you by _____ a _____ _____ called the _____ _____ in the _____-_____corner of the cell.
When you select the cell the _____ _____ _____ appears.
Warns, displaying, green triangle, error indicator, top left
Error checking button
You can click the _____ _____ _____ to display a _____ of _____ you can perform on the formula.
Use this menu to _____ the error or _____ it, or use one of the _____ _____ options.
Error checking button, menu, actions
Resolve, ignore, error checking
_____ _____ is when a formula or function is entered in the wrong format or is _____ some required _____.
When a function is entered incorrectly Excel _____ to ____ the error.
If it appears to be a _____ _____ Excel will _____ a solution.
Syntax error, missing, punctuation
Attempts, diagnosis
Syntax error, suggest
When using a mouse to enter a range, press enter to _____ insert the _____ _____ and enter the _____.
Automatically, closing, parentheses, formula
When entering functions in the formula bar you can enter _____, _____ and _____ directly into the formula bar.
When the formula bar is _____, _____ and _____ buttons appear to the left.
Text, numbers, formulas
Activated, cancel, enter
Use the insert function dialog box instead of _____ functions.
When you choose a function, Excel _____ you for both _____ and _____ arguments.
Memorizing
Prompts, required, optional
How to insert a function:
- Select cell where you want the function.
- Click _____ _____ button on _____ bar to open the _____ _____ _____ box.
- Select a function _____ and a function, click OK. Excel opens the function _____ _____ _____ that is specific to the chosen function.
- In the argument boxes, enter arguments for the function, you can use the _____ buttons to _____ the dialog box _____ and then select cells or ranges by using the mouse, click OK.
Insert function, formula, insert function dialog
Category, argument dialog box
Collapse, minimize, temporarily
The _____ feature _____ inserts the sum formula and _____ for a function.
When you click a cell and use the Autosum button, Excel _____ the _____of values you want to use as the _____. Excel is sometimes _____.
Autosum, automatically, arguments
Guesses, range, wrong
The Autosum function can enter Sum functions at _____ locations _____.
Select all the cells that should contain the _____ _____ and click the _____ _____.
Several, simultaneously
Sum function, Autosum button
Statistical functions provide _____ a function from _____ to _____.
Frequently used functions are _____, _____, _____, _____ and _____.
Hundreds, simple, complex
Average, MIN, MAX, COUNT, COUNTA
The _____ function calculates the _____ _____ of a list of values.
_____ specify values to be used in the _____.
_____ is determined by _____ the values in the _____ and dividing that Sum by the number of values.
Average, arithmetic mean
Arguments, calculations
Average, summing, arguments
