Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
EXCEL
Chapter 3
| Question | Answer |
|---|---|
| What are assumptions? | cell values that you can change to determine new values for formulas |
| What is a fill series? | fill destination area with series using format of source area. this is the default |
| Can you create your own custom fill sequences for use with the fill handle? | yes |
| Where should the What-If Assumptions be placed in the worksheet? | in an accessible area but does not impair the view of the main section of the workbook |
| What is an office clipboard? | a temporary storage area in the computer's memory that allows you to collect text and graphics from any Office document and then paste them into another type of document |
| What is drag and drop? | Using the mouse to move or copy cells |
| Should you insert a singlecell or entire rows/entire columns? | entire rows or entire columns |
| Is clearing a cell the same as deleting a cell. | no; clearing the cell, takes the data out of the cell deleting the cell-removes the cell from the worksheet |
| How do you know you have a cell reference error? | error message: #REF |
| What are format symbols? | assign a format to numbers as they are entered Symbols include: $ , % |
| NOW function | system date tracked by your computer ;may have to change the format |
| What is absolute cell reference? | cell address that refers to a specific cell and does NOT change when you copy the formula |
| How would you type and absolute cell reference for L23? | $L$23 |
| What is a relative cell reference? | a cell address in a formula that automatically changes to reflect the new location when the formula is copied or moved |
| How would you type a relative cell reference for C5? | C5 |
| What is a mixed cell reference? | a cell reference that combines both absolute and relative; it includes a dollar sign before the column OR row, not before both |
| How would you type a mixed cell refence for the cell B4 with a column reference? | B$4 |
| How would you type a mixed cell reference for the cell B4 with a row reference? | $B4 |
| When do you use the IF function? | when you want to assign a value to a cell based on a logical test |
| What is a logical test? | decision-making process; made up of two expressions and a comparison operator |
| What does the IF formula look like? | =IF( logical test, value_if_true, value_if_false) |
| What are the comparison operators? | =, <, >, >=, <= <> |
| What does an error message begin with? | # |
| What is a nested IF function? | the action to be taken for the true or false case includes another IF function; the second IF function is nested, or layered within the first |
| How do you know if there is a nested IF function? | In the formula there will be two sets of parenthesis |
| What is format painter? | copying of a cells format to another cell or a range of cells |
| How do you select nonadjacent ranges, like A3, C7, F2 | select A3, press and hold Ctrl, Select C7 and F2 |
| What is the What-if analysis? | A decision-making tool that changes input values recalculate formulas, in order to predict various possible outcome |
| What does the What-if analysis allow you to do? | allows you to review results of different scenarios |
| What is goal seek? | a problem-solving method in which you specify a solution |
| What is accessibility? | removing barriers that may prevent individuals with disabilities from interacting with data or an app |
| When would you add a clustered column chart? | to compare values side by side, broken down by category |
| Why are data labels used? | makes a chart more easily to understand; they can be removed if it does accomplish that |
Created by:
tammy.smithusd410
Popular Computers sets