Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
25 Cards in this Set
- Front
- Back
|
The auto add function adds numbers in a column or row you specify. True or false? |
False |
|
|
AAA is an example of a ___ in excel |
Column heading |
|
|
Quickly highlights important info on a spreadsheet that match your criteria by applying formatting options data bars color scales or icon sets |
Conditional formatting |
|
|
=B2-B3 |
|
|
=AVERAGE(B4:D4) |
|
|
As a general rule excel will ___ align numbers |
Right |
|
|
Cell D4 contains the formula =C1+C2. What formula will you see when you paste this into cell E5? |
=D2+D3 |
|
|
When you copy a formula that contains an absolute reference to a new location, the reference... |
Does not change |
|
|
Which of the following is a logical function? |
IF |
|
|
Column chart |
|
|
$A$1:$B$7 |
|
|
Legend |
|
|
Arranges content in reverse alphabetical order |
Descending |
|
|
A powerful tool used to quickly group summarize and rearrange large datasets |
Pivot tables |
|
|
Show items that match "food" only |
|
|
A worksheet ___ is a collection of two or more selected worksheets |
Group |
|
|
A reference that refers to the same cell or range on multiple sheets is called... |
3-D |
|
|
Helps automate repetitive tasks in excel by recording steps. |
Macro |
|
|
You can use data ___ to restrict the type of data or the values that users enter into a cell. |
Validation |
|
|
The ___ function returns true if an y of its arguments evaluate to true and returns false if all arguments are false . |
OR |
|
|
COUNTIFS |
|
|
Calculates a payment for a loan based on a constant payment and constant interest rate |
PMT |
|
|
A ___ analysis is the process of changing the values in cells to see how those changes will affect the outcome of the formulas on the worksheet. |
What-If |
|
|
Returns the number of characters you specify from the right side of a string |
RIGHT |
|
|
Removes all spaces from text other than single spaces between words. |
CLEAN |
