479748
Description
Flashcards by tschaffner, updated more than 1 year ago
|
Created by tschaffner
over 10 years ago
|
|
| Question | Answer |
| What does the sum function do? | Returns the total of cells you put in the brackets. |
| What symbol does every function begin with? | = |
| Name a use of conditional formatting... | To check whether a cell is equal to, more than or less than another value or cell. |
| The button that automatically turns numbers into currency looks like... |
Image:
excel07currency (image/jpg)
|
| The autosum button looks like... | |
| The letter in the cell reference refers to the row or column? | Column |
| The number in the cell reference refers to the row or column? | Row |
| What does the autosum button do? | Automatically selects the nearest column or row of data and adds it up. |
| What symbol is used for multiplication? | * |
| What symbol is used for division? | / |
| What symbol is used for absolute cell referencing? | $ |
| What is absolute cell referencing? | If you copy formulas along a row or down a column, the cell references will not be adjusted. |
| How would we find the average of cells C4 and A6 in Excel? | =AVERAGE(C4, A6) |
| What button is used to filter data? | Sort and Filter |
| What button can insert functions? | fX button. |
Want to create your own Flashcards for free with GoConqr? Learn more.